Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Matrix reports with Drill down functionality Expand / Collapse
Author
Message
Posted Tuesday, August 10, 2010 8:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 10:36 AM
Points: 72, Visits: 284
I have created an SSRS matrix report with drill down functionality. The report is very very slow in processing if it even processes at all. The report runs relatively fast without the drill down functionality in SSRS.
However, when I view the data dynamically by connecting the underlying data source to Excel it runs much much faster. Is there any remedy for this in SSRS or should I just considered presenting the data via Excel.

Thanks

Steven
Post #966735
Posted Wednesday, August 11, 2010 11:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 11, 2010 11:27 PM
Points: 1, Visits: 0
SQL Server Newbies
Line comments starts with two dashes(–) and ends with carriage returns. Everything between two dashes(–) and carriage returns is considered as comment. This comments can be placed anywhere in the code. This comment can be placed after code in the same line and everything before two dashes (–) will execute like normal T-SQL and after two dashes(–) will not be executed and considered as comment.




____________________________________________________________________________________________

Want to get-on Google's first page and loads of traffic to your website? Hire a SEO Specialist from Ocean Groups seo pecialist
Post #967938
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse