Different Types Of Reports in SSRS.

Pooja Patil
Nov 2 · 1 min read

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:

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade