Drill through report is slow when calling it directly, not through another report.
I have a main report (2008R2) with several drill throrugh reports in it. These drillthorugh reports render very quickly with parametervalues set from the main report. Calling the same reports but directly (all of them show the same symptoms) - not through the main report - is very slow: Showing the parameters and possible values is quick. Efter picking my parameter value and opening the report, it is very very slow. Reportloading starts and then stops and the green symbol freezes for several seconds, then loading continues and finishes. Why is that and can I do anything to overcome this issue, when I call the reports directly. The report server is in native mode and data is on the same server as Reporting services (SQL Server 2008 R2)
October 26th, 2010 9:20am
Hi Anmaluje, Without your reports and datasource, we could not reproduce the issue, but you could follow below several options to monitor report’s performance. Firstly, you could have a check to the values in columns TimeDataRetrieval, TimeProcessing, and TimeRendering from ExecutionLog2 table in the ReportServer database when the report is executed. In this way, we could get to know the performance of each step. If the Data Retrieval takes too much time, you should improve your dataset performance by optimizing the query statements or considering creating execution snapshots for a report If the report takes too long to process, I assume that you are using some complicated aggregate calculation. If so, you can move some aggregate calculation to the T-SQL level and try to redesign the dataset. You could also add a page break to the report, as a user pages through a report, the report processor combines data and report layout information for each report page and passes the page to the report renderer. For a report that has no page breaks, the whole report must be processed before the user can view the first page. Here is a document about troubleshooting report performance, you could click it to learn more: http://msdn.microsoft.com/en-us/library/bb522806.aspx Report Performance Optimization Tips (Subreports, Drilldown)http://blogs.msdn.com/b/robertbruckner/archive/2009/01/08/report-performance-optimization-tips-subreports-drilldown.aspx Hope this helps. Regards, Challen Fu
November 1st, 2010 1:35am