Object type: Reporting Services report

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.

Reports drilled into 

Name	Description
Sales Order Detail	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.

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.
Sales.SalesOrderHeader	General sales order information.
Sales.SalesPerson	Sales representative current information.
Sales.SalesTerritory	Sales territory lookup table.

Report Queries 

TerritorySales Used In:  Name  Report type  Description  SalesTable  Table    Output Recordset  Column  Description  Name    SalesPersonID    FirstName    LastName    SalesOrderNumber    TotalDue    Data source  Description  HumanResources.Employee  Employee information such as salary, department, and title.  Person.Contact  Names of each employee, customer contact, and vendor contact.  Sales.SalesOrderHeader  General sales order information.  Sales.SalesPerson  Sales representative current information.  Sales.SalesTerritory  Sales territory lookup table.

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