Reporting Services reports | SQL 2005 Adventure Works OLTP |
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