Last post May 03, 2017 02:31 AM by Chris Zhao
May 02, 2017 10:18 AM|sukhdeep_kambo|LINK
I'm working with SSRS. I have used report viewer in asp.net MVC application. I am concerned how many records/ data size can be viewed in report viewer.
What are the limitations of report viewer?
I have some stored procedures which return millions of records. Report viewer goes blank while stored procedure is still in the execution mode when checked. Time out is set to "Never time out" for reports .
How to deal with this case?
Please let me know if there is a tool which can be used to measure the performance of stored procedure? I'd like to let you know that data will get increased day by day. What's the best way to make report viewer user responsive? Is it good approach to load
millions of records in report viewer? If there is any alternate please let me know.
May 03, 2017 02:31 AM|Chris Zhao|LINK
More report data requires more resource use, more network traffic, more processing time, and more storage. If the report is not paginated, all of the data is included in a single page, which cannot be accommodated by most browsers. To get the highest performance
when handling large workloads that include user requests for large reports, implement the following recommendations.
For details, see
Process Large Reports.