Hi Experts, I have two datasets in a report, I have created a report with "Dataset1" I need to get a field from "Dataset2" into the "Dataset 1". Please help me to create a report. Thanks,Siva

Hi Siva, I presume that you can't call field from one dataset to another dataset in SSRS, instead you can combine two datasets as one to display in the report. Select Field1,Field2,Field3 from Table1 UNION ALL Select NULL as Expr,NUll as Expr1, Field4 from Table2Nanda

Hi Nanda, Thanks very much for your reply.. Following is my Dataset1: SELECT NON EMPTY { [Measures].[Traited Distr points], [Measures].[Traited SKUs], [Measures].[Traited Stores], [Measures].[Sales Value] } ON COLUMNS, NON EMPTY { ([Dim Store].[ASDA Store Code].[ASDA Store Code].ALLMEMBERS * [Dim Prod].[ASDA Product Code].[ASDA Product Code].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Dim Prod].[Muller Supplier].&[MULLER DAIRY (UK) LTD] } ) ON COLUMNS FROM [G4 Muller ASDA]) WHERE ( [Dim Prod].[Muller Supplier].&[MULLER DAIRY (UK) LTD] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS Following is my Dataset2: SELECT NON EMPTY { [Measures].[Base Vol - Rolling Avg] } ON COLUMNS FROM ( SELECT ( { [Dim Unit of Measure].[Dim Unit of Measure].&[3] } ) ON COLUMNS FROM [G4 Muller ASDA]) WHERE ( [Dim Unit of Measure].[Dim Unit of Measure].&[3] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS If I "UNION ALL" this 2 datasets, I am getting an error. ERROR: Query (3, 1) Parser: The syntax for 'UNION' is incorrect. Help me to solve the issue. Thanks,Siva