Object type: Reporting Services report

Shows sales reason comparison data from an Analysis Services cube. Also illustrates the use of a multivalued parameter. The Sales Reason Comparisons report requires SQL Server Analysis Services and the AdventureWorks Analysis Services database.

Parameters 

Variable	Data Type	Description
ProductCategory	String

Properties 

Transactional	Uses cursors	Executes procedures	Dynamic content
No	No	No	No

Report Queries 

ProductData Used In:  Name  Report type  Description  matrix1  Matrix    Parameters  Variable  Description  ProductCategory    Output Recordset  Column  Description  Sales_Reason    Sales_Territory_Group    Internet_Order_Quantity    Internet_Sales_Amount    Internet_Total_Product_Cost

ProductList Used In:  Name  Report type  Description  ProductCategory  Valid parameter values    Output Recordset  Column  Description  Category    ParameterCaption    ParameterValue    ParameterLevel

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