I have a very interesting issue with a customer. They use lots of images in their reports. The report performance is very poor after
deploying the report to Sharepoint Integrated Mode and executing the report from Sharepoint Report Viewer. The single server is setup with SQL Server 2008 R2. Sharepoint and Reporting Services are running all on the same server.
The goal is to be able to use the Report Viewer Web Part and Sharepoint Filters to create Dashboards.
We have tried the following ways to get satisfactory performance out of these reports:
When we run the reports in a page viewer web part in Sharepoint against a native SQL 2008 Report Manager on another server, they execute great
When we run the reports in a page viewer web part in Sharepoint against the Sharepoint Integrated Report server on same server, they execute way more quickly then when using the Report
Viewer against the same Sharepoint Integrated Report server .
When we remove the images from the reports and execute the reports via report viewer or in the Integrated library they execute satisfactorily
in both Report Manager and Sharepoint Integrated - but th
View Complete Post