Types of SSRS Reports
- Parameterized reports: When the output of a report is not static but instead depends on the input parameters supplied to the reports at run time, the report is known as a Parameterized report.Drillthrough reports, linked reports, subreport and all other report types are a kind of Parameterized reports.
- Linked Report: A linked report is a report server item that is derived from an existing report and retains the original report’s definition. A linked report always inherits report layout and data source properties of the original report. All other properties and settings can be different from those of the original report, including security, parameters, location, subscriptions, and schedules. Linked report act as a shortcut to the original report. To create a linked report, we can go to the report manager. Click on the dropdown mark of any individual report. A menu will appear. Click on the “Create Linked Report” option from the menu to create a new linked report. To change the parameters,subscription, schedules, etc. Of the linked report click on the dropdown mark of the linked report and from the same menu shown in image-1 select the “Manage” option and you will get different options to modify according to your requirement.
- Snapshot reports: A report snapshot is the report output reference i.e. report layout information and query results retrieved at a specific point of time.The report snapshot is stored in the report server to be delivered at the specified time to specific users. Basically, report subscription is a report snapshot generated on some defined scheduled time and delivered to the intended audience by the report server. The report snapshot can be used to build a history of a report that can be further used to analyze data changes over time.
- Cached reports : A cached report is a saved copy of a processed report. Cached reports are used to improve performance by reducing the number of processing requests to the report processor and by reducing the time required to retrieve large reports. They have a mandatory expiration period, usually in minutes.
- Adhoc reports: Reports which are created by the End user from the reporting model with predefined layout are called Adhoc reports. The developer needs to develop the Report Model or even give only the SSAS cubes so that the user can create Data model or views from existing cube to access in report depending on their requirements. To create a adhoc report on the Report Manager Server, we need to use the Report Builder feature of the Report Manger.
- Drilldown reports:
- Drillthrough reports:
- Subreports : A subreport is a report that displays another report inside the body of a main report. It is used to embed a report within a report. Any report can be used as a subreport. The subreport can use different data sources than the main report and it can have its own datasets. The parameters can be passed from Main report to the subreport.
Tagged SSRS. Bookmark the permalink.