Dataset: DataSet1.rsd
Property | Value |
Path | C:\Users\Alen\Desktop\SSRS items\AdventureWorks 2012 SSRS Samples - Copy\DataSet1.rsd |
Data source | DataSource3 |
Name | Data type | Nullable | Omit from query | Read only |
cddsf | Boolean | True | True | True |
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 |
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 |