|
Answer» Following are the benefits of paginated reports in SQL Server Reporting Services (SSRS):- - Reports provide a unified perspective of data to aid in business decision-making. For this, we should use a single set of data sources to get a single set of FACTS.
- We can view reports for our own use or share reports with our team or organisation by PUBLISHING them to a report server or SHAREPOINT site.
- Once we have defined a report, we can use it in a variety of ways. We can export the report to a variety of file formats, or send it to subscribers as an e-mail attachment or a shared file. Multiple linked reports can be created with different parameter settings applied to the same report definition.
- Using data regions, we may visualise our data in a variety of interconnected ways. We can display data in TABLES, matrices, expand/collapse groups, charts, gauges, indicators or KPIS (Key Performance Index), and maps, and nest charts in tables.
- We can manage report data sources separately from the report definition. We can, for example, go from a test to a production data source without affecting the report.
- To create reusable data visualisations, we can employ report sections, shared data sources, shared queries, and subreports.
- We can define expressions that allow us to tailor the way report data is filtered, aggregated, and sorted.
- We can create a free-form layout for our reports. The arrangement of a report is not limited to data. We can arrange the facts on the page so that it fosters comprehension, insight as well as action.
- To allow report readers to engage with the report, we can enable drillthrough actions, expand/collapse toggles, sort buttons, Tooltips, and report parameters. We use report parameters in conjunction with custom expressions to provide report readers control over how data is filtered, aggregated, and sorted.
|