Showing three different reports in the single report

Question

Hi ,
I have three different reports and want to show it in the single report.
For Example I have Table A,Table B and Table C
Report 1 : Select * From Table A
Report 2 : Select * From Table B
Report 3 : Select * From Table C
Is there any way to show the result of these different report in the single report at SSRS??

Answer 1

Set them up as separate datasets in the data tab in SSRS BIDS.

In the layout page, have 3 different tables/matrix/textbox etc, and attach each table/matrix/textbox etc to a different dataset.

Answer 2

create three dataset
dataset1:Select * From Table A
dataset2:Select * From Table B
dataset3:Select * From Table C

take three table report
1st report assign dataset 1 and drag all the fileds into table 1
2nd report assign dataset 2 and drag all the fileds into table 2
3rd report assign dataset 3 and drag all the fileds into table 3

---

Praxy

Answer 3

use sub reports if the above cases was not on your pocket.!

---

Regards, KarthikShanth.