Reporting Services reports | SQL 2005 Adventure Works OLTP |
Adventure Works top five sales people and stores. This report illustrates a dataset with queries containing the TOP clause. It also illustrates the use of tables, charts, parameters, calculated fields, and drillthrough links.
Parameters
Variable Data Type Description ProductCategory Integer ProductSubCategory Integer StartDate DateTime EndDate DateTime
Reports drilled into
Name Description Employee Sales Summary Adventure Works sales for an individual employee. This report includes Sales Comparison and Current Month Sales Comparison charts in addition to a Current Month Order Summary table with drillthrough to individual orders. This report illustrates the use of multiple datasets, charts, tables, drillthrough, and dynamic parameters.
Properties
Transactional Uses cursors Executes procedures Dynamic content No No No No
Data Source Activity
Accesses Description HumanResources.Employee Employee information such as salary, department, and title. Person.Contact Names of each employee, customer contact, and vendor contact. 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.Customer Current customer information. Also see the Individual and Store tables. Sales.SalesOrderDetail Individual products associated with a specific sales order. See SalesOrderHeader. Sales.SalesOrderHeader General sales order information. Sales.SalesPerson Sales representative current information. Sales.Store Customers (resellers) of Adventure Works products.
Report Queries
TopEmployees
Used In:
Name Report type Description TopEmployeesChart Chart TopEmployeesTable Table Parameters
Variable Description ProductCategory ProductSubcategory StartDate EndDate Output Recordset
Column Description LastName FirstName EmployeeID SaleAmount FullName
Data source Description HumanResources.Employee Employee information such as salary, department, and title. Person.Contact Names of each employee, customer contact, and vendor contact. 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. Sales.SalesPerson Sales representative current information.
ProductCategories
Used In:
Name Report type Description ProductCategory Valid parameter values Output Recordset
Column Description ProductCategoryID Name
Data source Description Production.ProductCategory High-level product categorization.
TopCustomers
Used In:
Name Report type Description TopStoresChart Chart TopStoresTable Table Parameters
Variable Description ProductSubcategory StartDate EndDate ProductCategory Output Recordset
Column Description StoreName SaleAmount ProductSubCategoryID ProductCategoryID
Data source Description Production.Product Products sold or used in the manfacturing of sold products. Production.ProductSubcategory Product subcategories. See ProductCategory table. Sales.Customer Current customer information. Also see the Individual and Store tables. Sales.SalesOrderDetail Individual products associated with a specific sales order. See SalesOrderHeader. Sales.SalesOrderHeader General sales order information. Sales.Store Customers (resellers) of Adventure Works products.
ProductSubCategories
Used In:
Name Report type Description ProductSubCategory Valid parameter values Parameters
Variable Description ProductCategory Output Recordset
Column Description ProductSubCategoryID ProductCategoryID Name
Data source Description Production.ProductSubcategory Product subcategories. See ProductCategory table.
Applies to
Reporting Services reports | Command Text