|
Answer» Following are the use cases of Snapshot reports in SQL Server Reporting Services (SSRS):- - History of the REPORT: You may create a reported history that displays how data changes over time by taking a series of report snapshots.
- Consistency: When you WANT to give consistent RESULTS for multiple users who must work with the same data sets, use report snapshots. An on-demand report can offer different results from one minute to the next when dealing with VARIABLE data. A report snapshot, on the other hand, allows you to compare data from the same point in time to data from other reports or analytical tools.
- Performance: You can lessen the processing effect on the report server during core business hours by SCHEDULING large reports to execute during off-peak hours.
|