How to use the output of one report in another report

I need to integrate the data from one report into another report. I saw
in one of SSRS 2005 presentations that the output of one report can be
used as input into another report.
Appreciate if you somebody could point me how this can be done.
Thanks
KarenKaren,
You can use one report and within it place a subreport.
The magic is placed in the parameters passing into the subreport. You
can set those parameters to be some Report Items from the current
report.
So here is an example:
You have a report called MasterReport. It gets 1 field from the
database called Field1.
So you create a new report called ChildReport- which will be your
subreport (the report inside the other one)
You place a SubReport inside the MasterReport report and refernce that
subreport to the ChildReport.
Then there is a Parameters... section where you can set the parameters
passing into the ChildReport.
You basically set that to Parameters!Field1.Value
hope this helped.
Regards,
Stas K.|||Stas
Thanks for the tips on using the output of one report to another.
The primary reason why I was looking at using the one report output to
another is since Reporting services does not support multiple datasets
from different datasources on a report table or matrix I was wondering
I could have the report1 against a MS Access dataset and report2
against a Oracle dataset and report3 joining the data from report1 and
report2.
I was wondering if this will work.
Thanks
Karen|||Karen,
This is a good idea and it might work if you have the same amount of
records in both data sets.
I mean, if for example this report is for products, and in one database
you have 500 products but in another you have 501, your item line up
will not work.
Reporting Services does NOT allow you to join both data sets using any
type of Join or anything. Reporting Services will treat both reports as
2 seperate reports.
It CAN be implimented, but the data structure, # of rows, and the order
by have to all match.
I hope you succeed,
Stas K.|||Stas
Thanks for the info . yes both datasets have a common key and the
data joins between the two.
Are there some samples somewhere or in the documentation how
to create a report the takes output of one report to another
Thanks
Karen