Hi.
I've got a report which has a group footer.
The footer sometimes appears by itself on a page. The previous page is full and so the footer (just some totals) appears on the following page.
This is fine to a point.
What I would like is to have the header of the group repeated at the top of the page as the column headings would be useful for the total columns.
If a group goes over a page break, then the header is displayed.
The issue only occurs when it is only the group footer that is being printed.
As an example, assume that a page can only hold 10 lines.
So, with the page header/footer and group header/footer, that leaves 6 detail lines.
PAGE HEADER
GROUP HEADER
DETAIL 1
DETAIL 2
DETAIL 3
DETAIL 4
DETAIL 5
DETAIL 6
GROUP FOOTER
PAGE FOOTER
Now, say there are 8 detail lines.
I get (which is correct for me) ...
PAGE HEADER
GROUP HEADER
DETAIL 1
DETAIL 2
DETAIL 3
DETAIL 4
DETAIL 5
DETAIL 6
DETAIL 7
PAGE FOOTER
PAGE HEADER
GROUP HEADER
DETAIL 8
GROUP FOOTER
-B-L-A-N-K-
-B-L-A-N-K-
-B-L-A-N-K-
-B-L-A-N-K-
-B-L-A-N-K-
PAGE FOOTER
But for 7 detail lines ...
PAGE HEADER
GROUP HEADER
DETAIL 1
DETAIL 2
DETAIL 3
DETAIL 4
DETAIL 5
DETAIL 6
DETAIL 7
PAGE FOOTER
PAGE HEADER
GROUP FOOTER
-B-L-A-N-K-
-B-L-A-N-K-
-B-L-A-N-K-
-B-L-A-N-K-
-B-L-A-N-K-
-B-L-A-N-K-
-B-L-A-N-K-
PAGE FOOTER
For the second page, I want the GROUP HEADER ...
PAGE HEADER
GROUP HEADER
GROUP FOOTER
-B-L-A-N-K-
-B-L-A-N-K-
-B-L-A-N-K-
-B-L-A-N-K-
-B-L-A-N-K-
-B-L-A-N-K-
PAGE FOOTER
Hmm.
Whilst I'm thinking of this, my report actually has a few more groups.
They are
Filename (header suppressed)
Cost Centre (header suppressed)
User (header suppressed)
Source (header displayed and forces a new page)
Type (non page breaking grouping, but group header printed at the top of each page).
I think if I have a copy of the headers on the User Group Header and somehow only show it when I'm on page 2 where there is no details ... or something like that ... then I think it will work.
Ideas?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I used to use an old product called Sage Retrieve 4GL. It had a page control system which would allow for headers to be printed for footers. I was hoping I could use the same.
In the end, TPTB have made a suggestion of just printing the headers in the page header and having the group header print in the normal way, but indented.
And on the group footer, use "Total {group name}".
This seems to work ok and looks ok too.
But I'll certainly have a look at doing it with your suggestions.
Thank you.
Richard.
Business Accounts
Answer for Membership
by: peter57rPosted on 2009-10-13 at 06:53:17ID: 25559913
I suspect your example is closer to the truth than you might have expected. There are no built-in settings that will do this.
I've never done this but this is what I would do...
I think you will have to count printed lines to do what you want. So you need a varaible which is reset in the group footer and you add 1 to it every time you print any line.
You also need an extra 'dummy' detail section which is supressed unless :
the line count = max lines per page AND the next(groupfieldvalue) <> groupfieldvalue.
The group header must be set to repeat on each page, but i guess you have already done that.
What this should do is print an extra (blank) detail line at the end of a group if you have reached the bottom of the page and the end of all details for the group- this should print at the top of the next page, which in turn should force the group header to appear.