SSRS - Improvoing Performance

1. Avoid long running reports, by creating a report snapshot to run nightly or during low activity on your system.

2. Define pagination to hide overhead. for example, if a user requests a report that returns 1000 rows of data, you can use page breaking to render the initial page or results while the report server renders the rest of the pages in the background. without pagination, the user would have to wait until it rendered all 1000 rows.

3. Implement filters for performance.
If you use report-level filtering on data regions and data grouping rather than using query parameters as filters.

4. Enable drill down for detail.
Instead of giving users a report that shows all the data at once, design a summary report that
presents a subset of data and let usrs drill down to get more detail. using master detail
reports that take advantage of SSRS's navigation capabilities. Many parts of the report
controls have navigation property, which we use to create a hyperlink on the control for
passing the specific values.