Report & Subreport & Extra Pages

[AndyS48UK]

I've added a sub report to my main report.

Each of the reports uses the same query as its source.

The report and sub report are related by Order Number but are showing different Item Numbers.

Both Order Number and Item Number are grouped on each report and they all have footers so that I can then use the "Keep Together By Group" option for each.

But their NOT togther! I keep getting an extra page for each separate item. My main report without the sub report worked fine but when I brought in my sub report I now get these extra pages.

Can anyone tell me why it did this...better still how to cure it!? Access help seems to think that the Keep Together option will do just that so I'm obviously confusing it in some way.

THanks

 

[mdemarte]

report running over

Two thoughts occur to me. First, check your group headers. Is the Format option Force New Page set to None for Item Number? Otherwise, it could be creating the second page. Is the Item Number section so long that there is not enough room to keep it on the same page, thus forcing it to a second page?