No one logged in. Log in
Report Surfer Blog

SQL Server 2008 Sample Reports

Grant Paisley - Tuesday, October 07, 2008
There are three sets of sample reports released by Microsoft for SQL Server 2008. You can find the full details of the samples on MDSN here http://msdn.microsoft.com/en-us/library/ms161542.aspx. The new samples also include Offline Reports - a new feature in SQL Server 2008. 

Detils of the samples - From MDSN:
Report Description

Report Builder 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.

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.

To run the individual reports featured in these samples go to the Report Library page.

SQL Server 2005 Report Packs

Grant Paisley - Tuesday, October 07, 2008
The following SQL Server 2005 Report Packs are available for download from Microsoft.com or you can view the individual reports by clicking on the Report Library page.

SQL Server 2005 Integration Services Log Reports
    Download this set of reports that are designed to filter, analyze, and organize Log and Error row data generated by SQL Server 2005 Integration Services (SSIS). The reports provide useful views of the SSIS log data saved in a SQL Server database.

SQL Server 2005 Report Pack for Microsoft SharePoint Portal Server 2003
    Download this set of eight predefined reports and a sample database to easily visualize and author managed reports such as site trend, storage trend, site collection, and search terms, based on information extracted from a SharePoint Portal Server 2003 environment

SQL Server 2005 Report Pack for Microsoft Dynamics Axapta 3.0
    Download this set of six predefined Axapta 3.0 reports and a sample database. These sample reports include purchase order, sales order, rolling invoice, CRM recap, and order delivery performance. With some minor changes, this report pack can also work against an existing Microsoft Dynamics Axapta 3.0 environment

SQL Server 2005 Report Pack for Microsoft Dynamics Navision 4.0
    Download this set of 22 predefined Navision 4.0 reports. These sample reports include customer profitability, regional sales, inventory turnover, and budget analysis. With some minor changes, this report pack can also work against an existing Microsoft Dynamics Navision 4.0 environment.

SQL Server 2005 Report Pack for Microsoft Dynamics Great Plains 8.0
    Download this set of eight predefined reports that work with Fabrikam, the Microsoft Dynamics Great Plains sample database. The sample reports include inventory value, item back order, sales commissions, purchase order, and sales order. With some minor changes, this report pack can also work against an existing Microsoft Dynamics Great Plains 8.0 environment

SQL Server 2005 Report Pack for Microsoft Dynamics Great Plains 9.0
    Download this set of eight predefined reports that work with Fabrikam, the Microsoft Dynamics Great Plains sample database. The sample reports include inventory value, item back order, sales commissions, purchase order, and sales order. With some minor changes, this report pack can also work against an existing Microsoft Dynamics Great Plains 9.0 environment

SQL Server 2005 Report Pack for Microsoft Internet Information Services (IIS)
    Download this set of 12 predefined reports and a sample database to easily visualize and author managed reports such as site summary statistics, time period, page views and user statistics, based on information extracted from IIS log files.

SQL Server 2005 Report Pack for Financial Reporting
    Download this set of six predefined financial reports and a sample database to easily visualize and author managed reports to support key finance activities

"Get More Charts" Example Charts and Reports - SQL Server 2005

Grant Paisley - Tuesday, October 07, 2008

This is a set of Microsoft Chart Examples. See more details about the example charts here http://technet.microsoft.com/en-gb/library/aa964128.aspx

  • Column and Line Hybrid Charts
    Describes combinational charts in general and the SalesCostTarget sample report.
  • Pareto Charts
    Implements a Pareto visualization for a chart (ParetoChart sample report).
  • Moving Average Calculations
    Calculation and visualization of time-series trends in charts (MovingAverage sample report).
  • Custom Chart Color Palettes and Legends
    How to customize the colors in your chart (CustomColorPalette sample report).
  • Pie and Doughnut Charts
    Specific information to keep in mind when working with pie or doughnut charts.
  • Adding Chart Data Tables
    Shows how to link aggregated chart data to detailed data (PiePercentage sample report).
  • Scatter and Bubble Charts
    Important tips for designing scatter and bubble charts (BubbleChart, StepFunctionChart).
  • Table Inline Charts
    Maybe you don't need complex chart visualizations or you have to deal with an unknown amount of data at runtime but still want useful and nice visualizations. This section provides ways to achieve this goal (TableInlineCharts).

To access these individual reports click on the Report Library menu.

Adventure Works Report Pack - SQL Server 2005

Grant Paisley - Tuesday, October 07, 2008

These are the standard set of reports that come with SSRS in SQL Server 2005. The pack Includes the following report types

These are the standard set of reports that come with SSRS in SQL Server 2005. The pack Includes the following report types
  • Basic Pivot Report
  • Drill Down and Drill Through
  • Basic Charts
  • Charts will Drill Down
  • Hierarchical data structures
  • Master / Detail Report
  • Reports based on the Adventure Works DW Cube

To access these individual reports click on the Report Library menu.
or the Report Pack is installed with SQL Server 2005. See http://msdn.microsoft.com/en-us/library/ms160721(SQL.90).aspx for more details on how to install and use these reports on your SQL Server.


Print

Latest Report Surfer Blog Posts
REPORT SURFER IS BROUGHT TO YOU BY:
Robert Bruckner's Latest Blog Posts