Click here to Skip to main content
14,669,432 members
Rate this:
Please Sign up or sign in to vote.
See more:
I have query it contains 50,869 rows which executes in SQL server 2008 R2 in 10 mins.

In SSRS ,When i preview the report it will takes more than 10 mins. while preview the report,it should take less time to show the report output(means less than 8 sec)

How will i improve the performance of SSRS report ?
Updated 23-Apr-18 19:31pm

Rate this:
Please Sign up or sign in to vote.

Solution 4

1.Add the filter in the data set query itself instead of adding filter in report level
2.Avoid showing all the data in single page.Because single page data will take more time
3.If it is parameterzised report then go for cascading parameter and add only required parameter
4.If you are using a complex query to retrieve the data better create a view for the complex query to get the data in source.
Patrice T 24-Apr-18 2:55am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100