I'm new so please bear with me. I have a stored proc that generates 4 tables of disparate data (ie 4 datasets). What is the best way to connect to all 4 datasets in my SSRS report? Thanks.

If you are using 2008r2, you can use lookup functions to join the datasets in one table. If using a previous version, and you want to combine the datasets into one matrix for example, you will need to join the data in your query. Depending on size it might be better to join the datasets into the one in your query, even if using 2008r2.

Thanks, my 4 sets of data are completely unrelated with different column names. How would you join them?

Thanks, my 4 sets of data are completely unrelated with different column names. How would you join them?

If you want to combine data from multiple datasets, You have three options: 1. Combine the dataset by using the Join fundamentals ( this may not work for you,as the columns are unrelated) 2. Using the sub-report. But a sub-report in the table cell may help you. 3. Put the data you need in a hidden parameter. In the table, refer the value of parameter like : = Parameters!data1.value Hope they are helpful. Cheers.. Srid malt..

Hi Rick, Same problem i have faced when i used multiple dataset in same report and the best way is to upgrade the SSRS to SSRS R2 .otherwise take the thing as malavathu suggest. Amit

Hi, In SSRS 2005 we can't access the second resultset,best option to access second Result set is Create Same Stored Procedure Multiple Times and Change the Result Set Orders. For Example: SP_Test ....Return 2 Result set with diff columns. like .. select * fom table1.....Result set1 select * fom table2.....Result set2 alternatively change the Result set order. RAZ..

Thanks, my 4 sets of data are completely unrelated with different column names. How would you join them? Hi rick, Since the 4 datasets are unrelated, why do you need to join them? Could you clarify your requirement in more details? thanks, Jerry