AdventureWorksOffline Report Samples
05/28/2010
The AdventureWorksOffline report samples are a set of predefined report definition files that use XML representations of data taken from the
AdventureWorks databases. As a result, the AdventureWorksOffline report samples do not require an active connection to the AdventureWorks database. You can use these sample reports to familiarize yourself with individual features for authoring reports.
Scenario
Adventure Works Cycles publishes product and sales information that is accessed by employees throughout the company. The reports present this data in a variety of formats.
Language
Report Definition Language (RDL)
Chart Sample Reports
The AdventureWorks sample reports demonstrate a wide range of report features. The following table provides descriptions that explain the chart samples that are available.
| Report | Description |
|---|
| Axis_ScaleBreaks | This report illustrates how the chart calculates a scale break if there is sufficient space. |
| Axis_SecondaryAxis | This report illustrates how to make use of the secondary axis. |
| Axis_SpecifyNumOfIntervals | This report illustrates how to show all labels on an axis. |
| ChartSamplesRS2008R2.rptproj | This Reporting Services report project contains all of the AdventureWorks chart sample reports. |
| Data_AddingCalculatedSeries | This report illustrates how to add a calculated series to a chart. |
| Data_HighlightMaxPoint | This report illustrates how to highlight the maximum data point in a series. |
| Data_InsertingEmptyPoints | This report illustrates how to handle null values by adding empty points to the chart. |
| Data_Trendlines | This report illustrates how to add a trend line to the chart. |
| PieCharts_CollectingSlices | This report illustrates how to collect small slices on a pie chart. |
| PieCharts_DisplayingLabelsOutside | This report illustrates how to display labels around the outside of a pie chart. |
| Stock Charts | This report illustrates how to set properties on a stock chart. |
Gauge Sample Reports
The AdventureWorks sample reports demonstrate a wide range of report features. The following table provides descriptions that explain the gauge samples that are available.
| Report | Description |
|---|
| Gallery_Thermometer | This report contains an example of a thermometer. |
| GaugeSamplesRS2008R2.rptproj | This Reporting Services report project contains all of the AdventureWorks gauge sample reports. |
| Pointers | This report illustrates how to format the gauge pointer. |
| Scales | This report illustrates how to format the gauge scale. |
Text Sample Reports
The AdventureWorks sample reports demonstrate a wide range of report features. The following table provides descriptions that explain the text samples that are available.
| Report | Description |
|---|
| HTML_Import | This report illustrates how to import HTML into a text box. |
| HTML_MailMerge | This report illustrates how to create a mail merge after importing HTML into a text box. |
| Text_FormattingSelected | This report illustrates how to mix multiple formats inside of a single text box. |
| Text_MailMerge | This report illustrates how to create a mail merge inside of a single text box. |
| TextSamplesRS2008R2.rptproj | This Reporting Services report project contains all of the AdventureWorks text sample reports. |
Prerequisites
Your system must have Business Intelligence Development Studio installed.
Note: 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 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.
See Also
Tasks
Considerations for Installing SQL Server Samples and Sample DatabasesAdventureWorks Report Samples
Other Resources
Charts (Report Builder 3.0)Gauges (Report Builder 3.0) © 2010 Microsoft Corporation. All rights reserved.