Click here to Skip to main content
15,919,245 members
Please Sign up or sign in to vote.
1.00/5 (1 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 ?
Posted
Updated 23-Apr-18 19:31pm

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.
 
Share this answer
 
Comments
Patrice T 24-Apr-18 2:55am    
2013

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900