|
SSRS |
|
|
[General] |
|
|
Questions: |
Notes: |
|
What are Report Snapshots? |
A report snapshot is a report that contains layout information and a dataset that is retrieved at a specific point in time. Unlike on-demand reports, which get up-to-date query results when you select them, report snapshots are processed on a schedule and then saved to a report server.
When you select a report snapshot for viewing, the report server retrieves the stored report from the report server database, and shows the data and layout that were current for the report at the time the snapshot was created. |
|
What is the process of Authorization? |
After authentication, the process of authorization grants permissions to the user to access content on the report server and to perform specific actions.
In native mode, Reporting Services uses a role-based authorization system to control what users can see and do on the report server. |
|
What are Report Caches? |
If the report has to retrieve a large amount of data or multiple users are accessing the report frequently then a Report cache would increase its efficiency.
Caching reduces the burden on the server’s resources. We use the cache report functionality to store the report execution in the cache for a desired period of time and all the user requests will be addressed by the Cache.
You would use a cache when you are dealing with an excessive amount of data or there are multiple users accessing the files. |
|
What are things to consider before Caching, Snapshots, or Subscriptions? |
Before you schedule any caches, snapshots, or subscriptions,
Make sure:
|
|
What are the different ways to deliver Reports? |
There are many different ways to deliver a report such as via email, shared folders, or subscriptions. |
