Dataset: DataSet1.rsd
Dataset properties
| Property | Value |
| Path | C:\Users\Alen\Desktop\SSRS items\AdventureWorks 2012 SSRS Samples - Copy\DataSet1.rsd |
| Data source | DataSource3 |
Parameters
| Name | Data type | Nullable | Omit from query | Read only |
| cddsf | Boolean | True | True | True |
Fields
| Name | Field source column | Data type |
| Country | System.String | |
| State_Province | System.String | |
| City | System.String | |
| Postal_Code | System.String | |
| Customer | System.String | |
| Growth_in_Customer_Base_Value | System.Int32 | |
| Growth_in_Customer_Base_Goal | System.Int32 | |
| Product_Gross_Profit_Margin_Value | System.Int32 | |
| Internet_Order_Count | System.Int32 | |
| Reseller_Order_Count | System.Int32 | |
| Sales_Amount_Quota | System.Int32 |
Query
SELECT NON EMPTY { KPIValue("Growth in Customer Base"), KPIGoal("Growth in Customer Base"), KPIValue("Product Gross Profit Margin"), [Measures].[Internet Order Count], [Measures].[Reseller Order Count], [Measures].[Sales Amount Quota] } ON COLUMNS, NON EMPTY { ([Customer].[Customer Geography].[Customer].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [Adventure Works] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS |
See also