Last post May 29, 2015 03:44 AM by Edwin Guru Singh
May 27, 2015 11:11 PM|Balakumar90|LINK
In my ssrs reports , I am passing 2 parameters . For testing sake , I am binding two datasets that are populating a dropdown list in SSRS report , so that I can check from the Reportserver by passing values to it . Now When I integrate with the Asp.net ,
I am hiding those parameters and they are fed from the asp.net . My doubt is ... When I call the ssrs report from asp.net will those datasets binding the dropdowns will also get filled ??? I am trying to improvise my report performance . Your reponse might
help me out .
May 28, 2015 12:42 PM|PatriceSc|LINK
Use SQL Server Profiler to see if the queries needed for those lists is done.
It seems to me SSRS should be clever enough to see that the value is provided and that the drop down is not shown to the user (I assume this is a dropdown list for suggesting parameters to the user or do you mean it is some additional datasets found really
INSIDE the report itself ?)
Anyway just trace which SQL statements are sent to the server to find the correct response.
May 29, 2015 03:44 AM|Edwin Guru Singh|LINK
When I call the ssrs report from asp.net will those datasets binding the dropdowns will also get filled ??? I am trying to improvise my report performance
As per this case, I suggest you to consider caching concept in SSRS. Because SSRS has a built-in caching capability where the data required to render a report can be retrieved from the ReportServerTempDB database instead of executing queries on the
database specified in the report's data source. Caching is enabled in the Execution Properties for the report in the Report Manager. You can expire the cache based on elapsed time or a schedule
for more information , refer the following links :
Click here to know more about :How To Enable Caching in SQL Server Reporting Services (SSRS).
Click here to know more about Caching SSRS Reports for Performance.