mroberson
asked on
Conditionally Printing the Report Footer
I have a report where
Group #1 Header - Prints the persons last name plus a formula for initializing a counter to zero the formula is suppressed
Group #2 Header – is suppressed
Group #3 Header – is suppressed
Detail A – is suppressed
Detail B – is suppressed
Group #3 Footer – Displays the data for the report
Group # 2 Footer – is suppressed
Group #1 Footer – displays the summary totals – Prints a new page after – a formula for incrementing the counter
Report Footer – displays Grand Totals
What I am trying to accomplish is at the end of a report if there is room on the next to last page of the report to print the grand totals instead of having them print at the top of a new page what would be the last page. The conditions for this would be when the Groupnumber for Group #3 is less than 20 and Groupname for Group #1 is blank or there are no more Group #1 left
In the section expert I have tried a number be conditional formulas in the New Page After attribute for the Group #1 Footer. No, I do not have the checked boxed checked.
Group #1 Header - Prints the persons last name plus a formula for initializing a counter to zero the formula is suppressed
Group #2 Header – is suppressed
Group #3 Header – is suppressed
Detail A – is suppressed
Detail B – is suppressed
Group #3 Footer – Displays the data for the report
Group # 2 Footer – is suppressed
Group #1 Footer – displays the summary totals – Prints a new page after – a formula for incrementing the counter
Report Footer – displays Grand Totals
What I am trying to accomplish is at the end of a report if there is room on the next to last page of the report to print the grand totals instead of having them print at the top of a new page what would be the last page. The conditions for this would be when the Groupnumber for Group #3 is less than 20 and Groupname for Group #1 is blank or there are no more Group #1 left
In the section expert I have tried a number be conditional formulas in the New Page After attribute for the Group #1 Footer. No, I do not have the checked boxed checked.
So, you don't want a new page after the last group 3 if there were less than 20 of them, and you already have some kind of counter set up for group 3?
When you say "Groupname for Group #1 is blank", can the group name actually be blank, or is that tied to the "no more Group #1 left" condition? Assuming the latter, how about a New Page After formula like:
Not OnLastRecord OR Groupnumber >= 20
James
When you say "Groupname for Group #1 is blank", can the group name actually be blank, or is that tied to the "no more Group #1 left" condition? Assuming the latter, how about a New Page After formula like:
Not OnLastRecord OR Groupnumber >= 20
James
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As far as I'm concerned, if you found the answer on your own, I don't need any points.
James
James
Don't use NEW PAGE AFTER on the group footers.
Use KEEP TOGETHER on the REPORT FOOTER
That way if there is room on the page it will be printed if not then it will appear on the next page.
mlmcc