Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Reporting Services Reports (SSRS)

SQL Server Reporting Services reports are XML based report definitions that include report data and report layout elements. On a client file system, report definitions have the file extension .rdl. After a report is published, it is a report item stored on the report server or SharePoint site. Reports are one part of the server-based reporting platform provided by Reporting Services.

If you are new to Reporting Services, be sure to review the information in Reporting Services Concepts (SSRS).

You can use Reporting Services report solutions to:

  • Use one set of data sources that provide a single version of the facts. Base reports on those data sources to provide a unified view of data to help make business decisions.

  • Visualize your data in multiple, interconnected ways by using data regions. Display data organized in tables, matrices or cross-tabs, expand/collapse groups, charts, gauges, indicators or KPIs, and maps, with the ability to nest charts in tables.

  • View reports for your own use or publish reports to a report server or SharePoint site to share with your team or organization.

  • Define a report once and display it in a variety of ways. You can export the report to multiple file formats, or deliver the report to subscribers as e-mail or to a shared file. You can create multiple linked reports that apply separate parameter sets to the same report definition.

  • Use report parts, shared data sources, shared queries, and subreports to define data visualizations for re-use.

  • Manage report data sources separately from the report definition. For example, you can change from a test data source to a production data source without changing the report.

  • Design reports in a free-form layout. Report layout is not restricted to bands of information. You can organize data display on the page in a way that promotes understanding, insight, and action.

  • Enable drillthrough actions, expand/collapse toggles, sort buttons, Tooltips, and report parameters to enable report reader interactions with the report. Use report parameters combined with expressions that you write to enable report readers to control how data is filtered, grouped, and sorted.

  • Define expressions that provide you with the ability to customize how report data is filtered, grouped, and sorted.

rs_GettingStartedReport

When you create a report, you define a report definition file (.rdl) in XML format. This file contains all the information that is needed to combine report data and report layout by the report processor. When you view a report, the report progresses through the following stages:

  • Compile. Evaluate expressions in the report definition and store the compiled intermediate format internally on the report server.

  • Process. Run dataset queries, and combine intermediate format with data and layout.

  • Render. Send processed report to a rendering extension to determine how much information fits on each page and create the paged report.

  • Export (optional). Export the report to a different file format.

For more information, see Stages of Reports in Reporting Services Concepts (SSRS).

To create a report:

Each report authoring tool supports previewing a report. For more information, see Preview, Report Builder (SSRS), and Previewing Reports in Report Builder in the Report Builder documentation on msdn.microsoft.com.

Each authoring tool supports saving a report locally or publishing the report to a report server or SharePoint site. For more information, see Save and Deploy, Report Builder (SSRS), and Saving Reports (Report Builder) in the Report Builder documentation on msdn.microsoft.com.

In addition to previewing a report saved locally or published to a report server, you can provide a variety of viewing experiences for your report readers. To view a report:

To manage a published report:

  • Data sources. Shared and embedded data sources are managed independently from the report definition.

  • Datasets. Shared datasets are managed independently from the report definition.

  • Parameters. Parameters are managed independently from the report definition. After parameters are changed on the report server, report authoring clients cannot publish over the changes made on the server.

  • Resources. Images and spatial data in ESRI shapefiles are resources that can be published and managed independently from the report definition.

  • Report cache. By scheduling large reports to run during off-peak hours, you can reduce processing impact on the report server during core business hours.

  • Snapshots. Use report snapshots when you want to provide consistent results for multiple users who must work with identical sets of data. With volatile data, an on-demand report can produce different results from one minute to the next. A report snapshot, by contrast, allows you to make valid comparisons against other reports or analytical tools that contain data from the same point in time.

  • Report history. By creating a series of report snapshots, you can build a history of a report that shows how data changes over time.

For more information about performance, see Performance, Snapshots, Caching (Reporting Services).

To secure a report:

  • From the report server administrator, identify the authorization and authentication system that is used for your Reporting Services installation. By default, Reporting Services uses Windows authentication, integrated security, and role assignment to help control access to published reports. For more information, see Roles and Permissions (Reporting Services) and Security and Protection (SSRS).

You can create data alerts for published reports on a SharePoint site. Data alerts are based on data feeds from data regions in the report. By default, data regions are named automatically. Report authors can make it easier to create data alerts in their reports by naming data regions based on their business purpose. When you create a data alert, you are notified in email when data meets the conditions that you specify. For more information, see Generating Data Feeds from Reports (Report Builder and SSRS), Create a Data Alert in Data Alert Designer and Data Alerts (SSRS).

Reporting Services supports multiple versions of report definitions, report servers, and SharePoint sites. To upgrade a report:

To troubleshoot a report:

  • Determine where the issue is occurring. Review the information in Stages of a Report.

  • Determine where you can find more information. For example, for report design that includes expressions, the Report Designer tool provides more information about expression evaluation issues than the Report Builder tool. For report processing errors, the log files contain detailed information.

For links to step-by-step topics, see the Task section in feature articles mentioned in the previous sections of this topic.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft