Multiple group summaries not printing on same page

[dorianr]

My reports have group summaries in the footer up to 4 or 5 levels. It looks bad when the last group summary (or a few of them) print at the top of the next page without any preceeding data. I would like to keep all of the group summaries together. If they can not fit on the current page, then they should be moved to the next page with at least 2 rows of detail. Does anyone know how to do this?

 

[evalesthy]

See Access Help "Keep a group of records together on a report page "

Is that what you are asking about?

 

[dorianr]

I need something that is much more robust. I want to keep the group footer summaries (for up to 5 levels) all together. The report has many detail records that are followed by up to 5 Group level summaries in the Group Footer (total for Group 1, Total for Group 2, etc.) The report does not look good when some of the group footers appaear on the next page. I want to keep all group footers on the same page. In addition, it does not look good to have a page start with the 5 group footers and not have any detail rows. That is why I was hunting for some type of orphan control so that there would always be at least 3 records (for example) appearing at the top of the next page that are followed the all of the group footer summaries.

 

[CosmoKramer]

Can you duplicate your summaries in subreport(s) that you can place in your report footer?? It won't solve your "problem" of "it does not look good to have a page start with the 5 group footers and not have any detail rows", but I don't feel that it's a problem to start a page with summary information, provided you supply good labeling.....

Si hoc legere scis, nimis eruditionis habes

 

[dorianr]

No, placing the group summaries in the report footer, will not work since the summaries occur throughout the report. For example, when ever the sample medium (soil, air, water, sediment, ...) changes. When ever the sample medium changes, there are 3 or 4 group level summaries (there are other groups that are inferior to the sample medium)

By the way, I do have a total summary that is in the report footer.

 

[CosmoKramer]

I wasn't referring to placing the group summaries in the report footer as they currently are. What I meant was to replicate the group summaries by using aggregate functions (DSum, DCount, etc.) that would return the same values.

Si hoc legere scis, nimis eruditionis habes