Object type: Reporting Services report

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.

Parameters 

Variable	Data Type	Description
ReportMonth	Integer
ReportYear	Integer
EmpID	String

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.

Reports drilled from 

Name	Description
Product Line Sales	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.

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.SalesOrderDetail	Individual products associated with a specific sales order. See SalesOrderHeader.
Sales.SalesOrderHeader	General sales order information.
Sales.SalesPerson	Sales representative current information.

Report Queries 

EmpSalesYearOverYear Used In:  Name  Report type  Description  SalesComparison  Chart  Yearly Sales Comparison  Parameters  Variable  Description  ReportYear    ReportMonth    EmpID    Output Recordset  Column  Description  Employee    OrderYear    OrderMonthNum    OrderMonth    Sales    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.SalesOrderDetail  Individual products associated with a specific sales order. See SalesOrderHeader.  Sales.SalesOrderHeader  General sales order information.  Sales.SalesPerson  Sales representative current information.

SalesEmps Used In:  Name  Report type  Description  EmpID  Valid parameter values    Output Recordset  Column  Description  EmployeeID    Employee    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.SalesPerson  Sales representative current information.

EmpSalesMonth Used In:  Name  Report type  Description  MonthSalesComparison  Chart  =MonthName(Parameters!ReportMonth.Value) & " Sales Comparison"  Parameters  Variable  Description  ReportYear    ReportMonth    EmpID    Output Recordset  Column  Description  Employee    OrderYear    OrderMonthNum    OrderMonth    ProdCat    Sales    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.

EmpSalesDetail Used In:  Name  Report type  Description  OrderSummary  Table    Parameters  Variable  Description  ReportYear    ReportMonth    EmpID    Output Recordset  Column  Description  Employee    OrderMonthNum    SubCat    Sales    SalesOrderNumber    Product    OrderQty    UnitPrice    ProdCat    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.

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