Integrating subreport with main report

[arodri]

Hello,

I'm not even sure if this is possible, but I have two seperate reports right now that I need to make one. I don't work with subreports much but when I do, I normally put them in the main report footer, so that the subreport will just appear at the end of the main report.
The reports also have different groups, but they BOTH have a group called "Site", and another called "Period."

Instead of putting the subreport at the end of the main report, I need to integrate it into the main report in such a way that when the report displays, for the Sit=Arizona it will display all the data from the main report for Arizona, then right below that will be all of the data for the subreport for site=Arizona. Then right below that will be all the data from the main report for site=El Paso, and following that will be all the data for the subreport for Site=El Paso ... and so on.


Is this possible? And if so, how would I go about doing this?

Not sure if this is important or not but I have one parameter for both reports and that's "Site." I have a drop down where users can either select a site, or select "ALL" to run the report for ALL sites.

Thanks

 

[IanWaterman]

Place the subreport in your SIT group footer.

Right click subreport and select Change links. Selct SIT field from main report and drag into main linking pane.

In drop down window select SIT from subreport and link.

Remove the SIT parameter from Subreport.

Ian