Last post Apr 12, 2011 08:11 PM by codemihir1
Mar 27, 2011 07:30 AM|Nishantg|LINK
I have a report having lakhs of rows, I wana that the report will process page by page. It means when Report run for the first time it will show the first 100 records and after that if user will go to 5th page he will see records from 500 to 600.
Is this possible in SSRS. Also if any one of you explain about On-Demand Report processing then it will be great.
Mar 27, 2011 12:36 PM|mbanavige|LINK
the on demand capabilities of ssrs 2008 are not for collecting/deferring pages of data in a single dataset. the on-demand process determines which datasets are required for the currently displayed page and then requests the data for those datasets - potentially
deferring the data in other datasets used in other pages not yet displayed.
so if you have multiple datasets in a report, you can get a performance boost, but for an individual dataset, it will still request all the data.
Mar 28, 2011 02:24 AM|Nishantg|LINK
Thanks for your reply. I have a simple report which is using a table to display the records, the problem here I am facing is its taking too much time to display the first page of the Report. I have more than 5Lakhs of rows to display. Is there any way to
boost the performance of the Report.
Mar 28, 2011 04:35 AM|mahioak|LINK
If your intension is to limit the no. of records per page, you can do that. Please refer the below link
If you are bothering about performance related issues for processing large reports,
please refer the below link
Apr 05, 2011 04:28 AM|You-Hu Fu|LINK
On-Demand Report Processing is supported in Reporting services 2008 or later version, to
the scenario of yours, you could utilize cache process mechanism, with this mechanism, the Report Server can cache the intermediate format of the report, to shorten the time required to retrieve a report. This accelerated retrieval can mean an improved user
experience, particularly in cases where the report is large or accessed frequently. Caching is a performance-enhancement technique that is effective in many cases. Besides cache process mechanism, you could also use snapshot or subscription, both of these
methods are performance-enhancement techniques.
For more information about Caching SSRS Reports for Performance, please see
Reporting Services Performance Optimizations
Apr 05, 2011 07:08 AM|Nishantg|LINK
Hi, You-Hu Fu
Thanks for your reply. As per my understanding caching is only work when the Report will processed for the first time, my problem is that my Report is taking so much time to display the first page. So here I want any solution which will give the first page
of the report as quickly as possible.
Apr 12, 2011 08:11 PM|codemihir1|LINK
I think, if ReportViewer is taking to much time to render the report, means you need to work on your SQL query. create appropriate indexes. you need to post your SQL query in order to determine.
hope this help.