Issue with two subreports in Report Footer

[cspuckett]

I have a report with two subreports in the Report Footer. Each subreport calls a unique table (with distinct information) based on one parameter in the main report.

For example, it might be "ITEM ID" in the main report. Subreport1 shows the item history for the past week. Subreport2 shows the item stock levels in each warehouse.

I would like to have Subreport2 appear under Subreport1 in the Report Footer. However, because Subreport1 can grow (and needs to be able to grow), I'm having an issue with how to position Subreport2.


I tried putting Subreport1 in the Report Footer and then Subreport2 in the page footer, but (a) I can't get the suppression to work (i.e., would suppress it on all but the last page), and (b) there could be (often is) a lot of white space in between the two subreports in this scenario.

Is there any way to have subreport2 appear vertically on the page right after a "growing" subreport1?

 

[lbass]

Insert a second report footer section, so you have RF_a, and RF_b. You can do this in the section expert or by right clicking on the gray area to the left of the report footer->insert section below. Place each sub in its own section.

-LB

 

[cspuckett]

Oh good grief. It always helps to have a fresh set of eyes look at an issue!

Thanks, that solution worked perfectly!