hi, i want to combine 2 different datasources in one report with RS 2008R2. Please how can i do that? because when i try to put 2 fields from diffrent datasets in my report, RS doesn't want! Thanks Newfon

You can configure multiple datasources on a Report, and that should be an issue. There would be different datasets for each DataSource. Having said that, a single control like Tablix cannot have multiple datasets associated with that. Check this discussion: http://social.msdn.microsoft.com/forums/en-us/sqlreportingservices/thread/465B842F-1AA6-4662-B614-1045EC3F1010 Here is the response for a similar request on Connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=419819&wa=wsignin1.0 Hope this helps.. Chaitanya

hi, thanks for the links! the info. that i missed was "Please also be aware that for each data region (Table, Matrix, Chart), only one dataset can be specified." i now create 1 column outside my tablix + dataset2 and it works. But i can only build the aggregate of the field with the expression sum(Fields!Price.Value, "DataSet2"). I want to put the field Price.Value itself. How can i select this field and specify the dataset2? Thanks newfon

For specifying the field alone, edit the expression and say Fields!Price.Value. You can have Price alone, you don't need to have aggregate value everytime.. Since your Tablix is associated with DataSet2, it would consider Price from DataSet2 only. Hope this helps..Chaitanya

Hi Chaitanya my tablix is asscociated to Dataset1 and my column(same report but not in tablix) is associated to Dataset2(another datasource). As i want to select only field value from dataset2, it causes problem although my column is not in tablix. newfon

So, what I assume is that you are not using Price within Tablix. You are using it outside of the Tablix control. Then its fine. After you select the column name Price, go ahead and edit the corresponding expression, and just leave Fields!Price.Value. Chaitanya

So, what I assume is that you are not using Price within Tablix. You are using it outside of the Tablix control. Then its fine. After you select the column name Price, go ahead and edit the corresponding expression, and just leave Fields!Price.Value. Chaitanya