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)
View Complete Post