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 Reporting Samples on Codeplex

Grant Paisley - Tuesday, October 07, 2008
There is a comprehensive round-up of current SQL Server reporting samples from Microsoft available on Codeplex here http://www.codeplex.com/MSFTRSProdSamples. Samples include reports for SQL Server 2005 and SQL Server 2008.

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

Report Packs for SQL Server 2000

Grant Paisley - Monday, October 06, 2008
If you are looking for report packs for the older SQL Server 2000 there are some downloads that still can be found on the Microsoft site.

See this blog post for the details and the links http://www.jasonhartman.net/2004/10/new-report-packs-for-sql-server.html

Print

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