subreport of crosstabs

[DBAFrog]

I am trying to pull 3 crosstab reports into one master report.
I've added the sub-reports to a master report, but they are all on indvidual pages. I want them all on the same, or contiguous, pages.
I see that the crosstab puts the data into the Report Header, is that what is causing the problem? and if so, how do I correct it?

Lastly, all three crosstabs are based on the same Month Parameter, but to different tables with DATA.MONTH fields. Can I condense the paramter request from 3 to 1.

thanks


------------------
Curious by Nature,
Linux by Design

 

[lbass]

In each subreport, make sure you are suppressing unused sections. Also in the main report, right click on each subreport->format subreport->common and uncheck "Keep object together".

To use the same parameter, create the parameter within each subreport and set it equal to the datefield particular to the subreport in the record selection formula. Also create the parameter within the main report and use it in a record selection formula (even if you are displaying no records), and then link the main report parameter to each subreport parameter (edit->subreport links). When choosing the subreport parameter, be sure to choose the parameter {?parm} that is in the drop down box, not the {?pm-?parm} that appears as the default.

-LB

 

[DBAFrog]

Thank you...This works well



------------------
Curious by Nature,
Linux by Design