SSRS Interview Questions 12

SSRS [General] Questions: Notes: What are the differences between Push and Pull Deliver Methods? With the Pull delivery method, the user is accessing the file from the Report Manager themselves.   With the Push delivery method, the reports are automatically delivered to the user. What are Subscriptions? Subscriptions are a functionality with SSRS that pushes […]

Read More

SSRS Interview Questions 11

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 […]

Read More

SSRS Interview Questions 10

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 […]

Read More

SSRS Interview Questions 9

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 […]

Read More