Reporting Services, you can create the following types of reports.
- Parameterized reports
Parameter/Input values are used to generate the report. Parameterized reports are frequently used for drillthrough reports, linked reports, and subreports, connecting and filtering reports with related data. Reporting Services supports two kinds of parameters:
- Query parameters : Query parameters are used during data processing to select or filter data.
- Report parameters : Report parameters are used during report processing to show a different aspect of the data.
- Linked reports
A linked report is a report server item that provides an access point to an existing report. Conceptually, it is similar to a program shortcut that you use to run a program or open a file.
A linked report is derived from an existing report and retains the original's report 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
- Snapshot reports 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.
- Cached reports
A cached report is a saved copy of a processed report.
- Ad hoc reports
- Clickthrough reports
A clickthrough report is a report that provides detailed information about the
data contained within the main report.
Clickthrough reports are available only when running SQL Server Enterprise.
By default, the report server generates
two clickthrough template types for each entity: a single instance template and
a multiple instance template. The item that you click on determines which
template is used. If the person reading the report clicks a scalar attribute,
the single instance template is used. If the person reading the report clicks an
aggregate attribute, the multiple instance template is used.
- Drilldown reports
Drill down reports are the reports which can collapse or expand as per requirement i.e. information can be drilled down in to minor level information if required.
- Drillthrough reports
- Subreports
Sub reports are the reports which can be called in main report and can be generate through main report.
Parameters can be passed from main report to sub report and basis of that report can be generated.
Verify
- TSQL Reports:
TSQL Reports are made up of plain SQL Query. Data source in this case is SQL server database engine.
- MDX Reports:
MDX reports are created through cubes. For this data source is analysis services cubes.
