Export (0) Print
Expand All

Report Samples (Reporting Services)

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

ms161542.note(en-us,SQL.105).gifNote:
For SQL Server 2008 R2, there have been no changes to the content that is listed in this topic.

Reporting Services includes a variety of sample reports that demonstrate a range of report styles. You can use the samples to learn about report design, data retrieval, and how to work with the report authoring tools.

ms161542.note(en-us,SQL.105).gifImportant:
SQL Server samples and sample databases must be downloaded and installed before you can view or work with them. For more information, see Considerations for Installing SQL Server Samples and Sample Databases.

There are three sets of sample reports:

  • The Report Builder sample report demonstrates the ad hoc reporting functionality in Reporting Services. The report works with a sample report model that defines the underlying data from the AdventureWorks2008R2 databases. For more information about the sample report model, see Report Model Samples.
  • The AdventureWorks2008R2 sample reports are a set of predefined report definition files that use the AdventureWorks2008R2 databases as data sources.
  • The Server Management sample reports include two sets of predefined report definition files for database administrators. Use the server management reports to view metadata for selected data sources. Use the execution log sample reports to view information from the report execution log. To learn more about the report execution log, see Report Server Execution Log.
ms161542.note(en-us,SQL.105).gifNote:
Business Intelligence (BI) Development Studio is not supported on Itanium-based computers. However, support for BI Development Studio is available for x64-based computers. If the SQL Server 2005 sample databases have been deployed on an Itanium-based computer, use BI Development Studio on either an x86-based or x64-based computer to modify and run the samples.

Report Description

AdventureWorks Report Samples

Describes the set of reports that use the AdventureWorks2008R2 sample databases to demonstrate features of Reporting Services. To publish and view the reports, use Business Intelligence Development Studio and Report Manager.

Note that Sales Reason Comparison sample report retrieves data from a sample cube database. The Analysis Services cube that provides data for this report is installed separately from the AdventureWorks2008R2 sample database. For more information about deploying the cube, follow the instructions in AdventureWorks Report Samples.

AdventureWorksOffline Report Samples

Describes the set of reports that use data from the AdventureWorks2008R2 sample databases to demonstrate features of Reporting Services. Note that these samples do not require an active connection to the AdventureWorks2008R2 sample database.

How to: Publish Report Samples

Describes how to publish the AdventureWorks report samples to your server.

Server Management Report Samples

Describes the set of reports that retrieve data from the report execution log.

Describes the set of reports that use SQL Server metadata to display information about SQL Server components.

Community Additions

Show:
© 2014 Microsoft