Sub report / main report formatting

[MNNovice]

3 sub reports containing 3 separate expense data are placed under groupheader0 on a main report. The summary total for these expenses is placed under the groupfooter0.

Because of the fact that some data may be longer than the other, I am having difficulty keeping each expense sub report together. On some pages part of one sub report data hangs as an orphan.

Is there a way to keep it together without compromising the summary total for all three?

Thanks.

[ChipR]

What is it that you would like to happen? I'm not sure how the sub report running over the page length would "compromise" the total.

[MNNovice]

Well, all three sub reports (report AP, Report pay and report Allocation) are under one groupheader. I also have a report header and footer. I added a groupfooter to display the summary total expense for each sub report.

In print preview I see that on some pages only the title a sub report (let's say Payroll Expenses) is hanging all by itself and the actual payroll data is on the next page. My question is how do I keep the label "Payroll Expenses" and its relevant data on the same page?

If I put the 3 sub reports under 3 separate groupheaders, then I cannot get a summary total for all 3 because I will then have 3 separate groupfooters. Am I making sense?

Thanks.

[ChipR]

Where is the title of the sub-report located? Make sure that section has Keep Together set to Yes. On the Group & Sort menu, there is also a Keep Group Together option for "Keep header and first record together on one page."

[MNNovice]

Each sub report has all that you mentioned as "YES". May be I didn't explain it better. Picture this:


Report header
Main report title

Group header0
Sub report 1 title
sub report 2 data

Sub report 2 title
sub report 2 data

Sub report 3 title
sub report 3 data
Groupfooter0
Summary: srpt1 $xxxx
srpt2 $xxxxx
srpt3 $xxxxx
Total $xxxxx
ReportFooter
Summary.....

On some pages my report has only the sub report title and the data falls to the next page. I am trying to figure how do I keep these two together.

Thanks.

[ChipR]

Obviously, the data for a sub report is in the detail section of the sub report. What section is the title in? The header of the sub report, or the group header of the main report?

[NeoPa]

I'll give this some further thought later, but I suspect your options here are quite limited.

For an individual section Header / Footer you can choose to try to keep it with its details, but over multiple items that will be clumsy to say the least.

[NeoPa]

I've looked at this again, and I can't think of a way of doing this.

One reason is that the three reports are all within the same section so Section level properties are not available to you. Controlling this may be possible within your reports (the ones within the subreports), but intelligent control - depending on how much space is available for specific instances - will be complicated (asuming it's even possible).

[MNNovice]

Thanks. I thought so too.