Here are a few tips I’ve discovered whilst building SSRS reports to host in SharePoint. Some of these are report based tips and a few apply to SharePoint. I willadd to and update these as I discover more.
1. [Report based] Avoid using the Total Pages built in field as if you use this the rendering engine has to complete a full pre-render of the entire report primary dataset before it starts the final render. This can add a great deal of processing overhead and the report will take much long to finally display;
2. [Report based] Ensure results are paged. This should occur by default but if you choose to turn it off for your report there is a risk that you will encounter problems as the HTML rendering format that is used to initially render a report opens the report in your browser. If the report is not paginated, all of the data is included in a single page, which cannot be accommodated by most browsers.
3. [SharePoint] If the source data changes infrequently consider setting up dataset caching and make use of Shared Datasets to reduce the number of cached results stored on the server.
4. [SharePoint] Consider the usage scenario of the reports and where appropriate implement caching of the report. For example if the report is a monthly financial statistics summary you could cache the report once a month rather than have it dynamically update everytime someone views it.