Dataset: DataSet1.rsd

CollapseAll image

Collapse image Dataset properties


 Property   Value 
 Path   C:\Users\Alen\Desktop\SSRS items\AdventureWorks 2012 SSRS Samples - Copy\DataSet1.rsd 
 Data source   DataSource3 

Collapse image Parameters


Name  Data type  Nullable  Omit from query  Read only 
cddsf Boolean True True True
Total: 1 parameter(s)

Collapse image 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
Total: 11 field(s)

Collapse image 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

Collapse image See also


About this documentation