1.

What are the use cases of Snapshot reports in the context of SQL Server Reporting Services (SSRS)?

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.


Discussion

No Comment Found