Reporting Services reports SQL 2005 Adventure Works OLTP

Company Sales

Object type: Reporting Services report

Adventure Works sales by quarter and product category. This report illustrates the use of a matrix data region that provides drilldown from summary data into detail data by showing and hiding rows. This report also illustrates the use of background images.

Properties 

Transactional  Uses cursors  Executes procedures  Dynamic content 
No No No No

Data Source Activity 

Accesses  Description 
Production.Product  Products sold or used in the manfacturing of sold products. 
Production.ProductCategory  High-level product categorization. 
Production.ProductSubcategory  Product subcategories. See ProductCategory table. 
Sales.SalesOrderDetail  Individual products associated with a specific sales order. See SalesOrderHeader. 
Sales.SalesOrderHeader  General sales order information. 

Report Queries 

Sales

Used In: 

Name  Report type  Description 
SalesMatrix  Matrix   

Output Recordset 

Column  Description 
ProdCat   
SubCat   
OrderYear   
OrderQtr   
Sales   


Data source  Description 
Production.Product  Products sold or used in the manfacturing of sold products. 
Production.ProductCategory  High-level product categorization. 
Production.ProductSubcategory  Product subcategories. See ProductCategory table. 
Sales.SalesOrderDetail  Individual products associated with a specific sales order. See SalesOrderHeader. 
Sales.SalesOrderHeader  General sales order information. 

Applies to

Reporting Services reports | Command Text
The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation

Document was prepared on: Thursday, April 05, 2007
Help compiled by DBDocumentor, a Pikauba Software product. All rights reserved.