Object type: Reporting Services report

Detail of an individual Adventure Works order. This report can be accessed as a drillthrough report from the Employee Sales Summary and Territory Sales drilldown report. This report illustrates the use of lists, tables, parameters, and expressions.

Parameters 

Variable	Data Type	Description
SalesOrderNumber	String

Reports drilled from 

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.
Territory Sales Drilldown	Adventure Works sales by territory. This report drills down through salesperson and order number with drillthrough to individual orders. This report illustrates the use of a table data region that provides drilldown from summary data into detail data by showing and hiding rows. This report also illustrates the use of drillthrough links and conditional formatting.

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.Address	Street address information for customers, employees, and vendors.
Person.Contact	Names of each employee, customer contact, and vendor contact.
Person.CountryRegion	Lookup table containing the ISO standard codes for countries and regions.
Person.StateProvince	State and province lookup table.
Production.Product	Products sold or used in the manfacturing of sold products.
Purchasing.ShipMethod	Shipping company lookup table.
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.

Report Queries 

SalesOrder Used In:  Name  Report type  Description  OrderHeader  List    Parameters  Variable  Description  SalesOrderNumber    Output Recordset  Column  Description  SalesOrderNumber    Store    OrderDate    SalesFirstName    SalesLastName    SalesTitle    PurchaseOrderNumber    ShipMethod    BillAddress1    BillAddress2    BillCity    BillPostalCode    BillStateProvince    BillCountryRegion    ShipAddress1    ShipAddress2    ShipCity    ShipPostalCode    ShipStateProvince    ShipCountryRegion    CustPhone    CustFirstName    CustLastName    Data source  Description  HumanResources.Employee  Employee information such as salary, department, and title.  Person.Address  Street address information for customers, employees, and vendors.  Person.Contact  Names of each employee, customer contact, and vendor contact.  Person.CountryRegion  Lookup table containing the ISO standard codes for countries and regions.  Person.StateProvince  State and province lookup table.  Purchasing.ShipMethod  Shipping company lookup table.  Sales.SalesOrderHeader  General sales order information.  Sales.Store  Customers (resellers) of Adventure Works products.

SalesOrderDetail Used In:  Name  Report type  Description  OrderDetail  Table    Parameters  Variable  Description  SalesOrderNumber    Output Recordset  Column  Description  SalesOrderDetailID    OrderQty    UnitPrice    UnitPriceDiscount    LineTotal    CarrierTrackingNumber    SalesOrderID    Name    ProductNumber    Data source  Description  Production.Product  Products sold or used in the manfacturing of sold products.  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