Types of Reports available in SSRS

With reporting service we can create different types of Reports. They are

• Drilldown Reports
• Drillthrough Reports
• Sub Reports
• Parametrized  Reports
• Linked Reports
• Cached Reports
• Click through Reports
• Adhoc Reports

Drilldown Reports :

Drill down reports initially hide complexity and enable the user to toggle conditionally hidden report items to control details data they want to see.

Drillthrough Reports:

Drill through reports are standard reports that are accessed through a hyperlink on a text box in a original report.

Sub Report:

A Sub report is a report that displays another report inside the body of a main reports.

Parametrized  Reports

A Parametrized  Reports uses input values to complete report or data processing. With  a Parametrized  Reports, you can vary the out put of  a report based on a values that are set when the report runs. Parametrized  Reports are frequently used for  Drillthrough reports, linked reports and Sub reports, connecting and filtering reports with the related data.

Linked Reports:

A Linked report is a report server item that provides an access point to an existing report. 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, subscription, and schedules.

Cached Report
A Cached Report is a saved copy of a processed report. Cached reports are used to improve the performance by reducing the number of processing requests to the report processor and by reducing the time required to retrieve large reports.


Click Through Reports:
Click through report is a report that displays related data from a report model when you click the interactive data contained with in your model based report. These reports are generated by the report server based on the information contained within the report model.