Export (0) Print
Expand All

Report Samples (Reporting Services)

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.100).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 AdventureWorks databases. For more information about the sample report model, see Report Model Samples.
  • The AdventureWorks sample reports are a set of predefined report definition files that use the AdventureWorks 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.100).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

Report Builder 1.0 Report Samples

Describes a report sample that you can access directly from the report server and modify in Report Builder.

AdventureWorks Report Samples

Describes the set of reports that use the AdventureWorks 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 AdventureWorks 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 AdventureWorks sample databases to demonstrate features of Reporting Services. Note that these samples do not require an active connection to the AdventureWorks 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.

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

Community Additions

Show:
© 2014 Microsoft