Different Types Of Reports in SSRS.
SSRS: SSRS stands for SQL Server Reporting Services.
The SSRS allows producing formatted reports with tables in the form of data, graphs, images, and charts.
There are many useful types of SSRS reports, each report displaying data in a unique way.
Types Of Reports:-
- Linked reports
- Snapshot reports
- Cached reports
- Parameterized reports
- Drilldown reports
- Drillthrough reports
- Subreports
Linked reports:-
The linked report is Report Server-side item which provides a link to an existing report on the server.
Snapshot reports:-
Snapshot report is a pre-executed report that contains layout information and query results that were retrieved at a specific point in time.
Cached reports:-
Cached reports are saved for a copy of the processed reports.
Parameterized reports:-
Parameters reports are the reports which accept parameters to complete the report.
Drilldown reports:-
Drill Down Reports in SSR allowing Users to Show or Hide the Column Data by providing plus and minus symbols on a text box.
Drillthrough reports:-
The drill-through report is reporting that is open by clicking a link within another report.
Subreports:-
SubReport data can be used to display another report in the Main report.
If you are new to SQL Server start with the following must-watch the video:
