|
Answer» Following are the different types of reports in SQL Server Reporting Services (SSRS):- - Parameterised Reports: A parameterized report completes report or data processing by using input values. You can change the output of a report using a parameterized report by changing the values that are set when the report runs. DRILLTHROUGH reports, linked reports, and subreports are all common USES for parameterized reports, which connect and filter reports with related data.
- Linked Reports: A linked report is an item on the report server that provides a link to an existing report. It's akin to a programme shortcut that you use to start a programme or open a file in terms of concept. A linked report is created from an existing report and preserves the report definition from the original. The report style and data source attributes of a linked report are always inherited from the original report. All additional attributes and options, including security, parameters, location, subscriptions, and scheduling, can differ from those in the original report.
When you need to make extra copies of an existing report, you can use the report server to build a linked report. For example, you might build region-specific reports for all of your sales regions using a single regional sales report. Although parameterized reports are commonly used to create connected reports, they are not essential. When you want to deploy an existing report with different settings, you can construct linked reports. - Snapshot Reports: A report snapshot is a report that provides layout information and query results from a single point in time. Report snapshots are processed on a schedule and then saved to a report server, unlike on-demand reports, which obtain up-to-date query results as you select the report. The report server gets the stored report from the report server database and DISPLAYS the data and layout that were current for the report at the time the snapshot was created when you select a report snapshot for viewing.
Snapshots of reports are not saved in a specific rendering format. Instead, when a user or an application asks for it, report snapshots are rendered in a final viewing format (such as HTML). A snapshot is portable thanks to deferred rendering. The report can be displayed in the appropriate format for the requesting device or browser. - Cached Reports: A cached report is a copy of a processed report that has been saved. Cached reports increase speed by lowering the number of processing requests sent to the report processor and the time it takes to obtain large reports. They must expire after a certain amount of time, which is commonly measured in minutes.
- Clickthrough Reports: When you click the interactive data contained inside your model-based report, a clickthrough report displays relevant data from a report model. The report server generates these reports using the information given in the report model. When a clickthrough report is opened, the person who designed the model selects which fields are interactive and which fields are returned. The report creation tools do not allow you to update certain field settings.
Clickthrough reports are generated automatically. You can, however, construct a customised report for interactive data items that is displayed instead of the model. The custom report is a Reporting Services standard report. - Drilldown Reports: Drilldown reports hide complexity at first, allowing the user to select how much detailed data they want to see by toggling conditionally hidden report components. Drilldown reports are required to retrieve all data that can be displayed in the report. Consider drillthrough reports for reports with a lot of data.
- Drillthrough Reports: Drillthrough reports are regular reports that can be viewed by clicking on a hyperlink in the original report's TEXT box. Drillthrough reports are used in conjunction with main reports and are the target of a drillthrough action for a report item like placeholder text or a chart. The main report provides summary data in a matrix or graphic, for example. Drillthrough links to reports based on the AGGREGATE in the main report are provided by actions defined in the matrix or chart. Drillthrough reports can but do not have to, be filtered by parameters. Drillthrough reports are distinct from subreports in that they do not appear within the original report, but instead open as a new window.
They differ from clickthrough reports in that they are custom reports that are saved on the report server rather than being generated automatically from the data source. They differ from drilldown reports in that they only retrieve report data for the parameters or dataset query supplied. - Subreports: A subreport is a report that presents a different report within the main report's body. A subreport is akin to a frame in a Web page in terms of concept. It's used to put a report inside another report. A subreport can be created from any report. Different data sources can be used in the subreport than in the main report. The report that the subreport displays is normally kept in the same folder as the parent report on a report server. The parent report can be configured to transmit parameters to the subreport. Although a subreport can be repeated inside data regions by using a parameter to filter data in each instance, subreports are usually used in conjunction with the main report as a briefing book or as a container for a series of related reports.
Consider using drillthrough reports instead of subreports for reports with a lot of them.
|