TechBrothersIT is the blog spot and a video (Youtube) Channel to learn and share Information, scenarios, real time examples about SQL Server, Transact-SQL (TSQL), SQL Server Database Administration (SQL DBA), Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Warehouse (DWH) Concepts, Microsoft Dynamics AX, Microsoft Dynamics Lifecycle Services and all other different Microsoft Technologies.
What type of reports you can create in SSRS - SSRS Interview Questions and Answers
We can create different types of reports in SQL Server Reporting Services.
Simple Tabular Reports
You can call this report detail report, where we simple use some fields to display data in tabular format.
This type of reports are used to showed summarized data. Some people call them Pivot Table or Cross Tab reports. Matrix reports are different from tabular as number of columns can change in matrix dynamically depending upon the input data.
Linked report is Report Server side item which provide link to existing report on server.
Clickthrough reports are created from Report Model and you can see the details of data by clicking on interactive data from report model.
Drill Down is the way to have summary values view and if we would like to see the detail , we can expand that part to see the details.
You can use + and - signs to change to summarize view or detail view of a report.
Drill-through report is report that is open by the clicking a link within another another report.
Cached reports are saved copy of processed report.
Ad hoc Reports
The reports those can be crated from Report Model on demand. You will be using Report Builder to create these reports.
SubReport Item can be used to display another report in Main report.
Snapshot report is a report that contains layout information and query results that were retrieved at a specific point in time.
Parameters reports are the reports which accept parameter/s to complete report.