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 […]
SSRS [General] Questions: Notes: Can you create Report Models from Cubes in BIDS? You cannot generate a model from your OLAP systems in BIDS. But if you have to use your Cube as a source to your Ad Hoc reports you can use your Report Manager to generate a SMDL file that you will […]
SSRS [General] Questions: Notes: What are Drill Through Reports? Drill Through Reports are reports which link objects to specific actions. This makes the report more interactive because the user can click on an object such as a table field and open another report which elaborates on that specific value. What are Sub Reports? Sub […]
SSRS [General] Questions: Notes: What is a Shared Data Source? A Shared Data Source is a data source connection string that is shared by all the reports in the project. What is a Data Set? Query used to retrieve the data to be shown in the report. What are Shared Data Sets? Share Data Sets […]