Get Group Header above Details

Silas2
Silas2 used Ask the Experts™
on
How do you insert a group which goes above Detail section and with a page break so only one group on a page?
E.g. if the data is this:
Company      InvIDs
CoA      333
CoA      334
CoB      337
And you want the report to be:
Page 1
Page Head: Company Name: CoA
Details: InvIDs
333
334
Page 2
Page Head: Company Name: CoB
Details: InvIDs
337

Every time I insert a group it goes below the Detail section, not where i want it, in the page header.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2007

Commented:
Go into section expert and select the group header it will display you properties winow where you can check the "new page After" checkbox. it will display each new group in new page. best of luck
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Actually you want either

NEW PAGE BEFORE on the groiup header or NEW PAGE AFTER on the group footer.

Use the formula rather than the check box.
For New Page Before on the group header use
Not OnFirstRecord

On the group footer use
Not OnLastRecord

Otherwise you will get a blank page as the first page or last page

Groups go around the detail section
Group header
Details
Group footer

mlmcc

Author

Commented:
Thanks for that, I get the page break, but I'm having problems getting the Group header above the Details (So its in the page header, not in with the details)
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

Top Expert 2007

Commented:
if you will select the options for group header then it will solve your issue.

Author

Commented:
I've been scratching my head with this Group Expert dialog for ages, and I can't see it an option for where the group header goes!
I go Group Expert/Choose my field to group on, click Options, then I get a tabbed dialog with Common/Options the two tabs, neither of which seems to be giving me the chance to place the group header...
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
You can't place the group header.

To get what you want you have to drag the field that is in the group header into the page header.

The other way to do this is on the second tab of the group expert.  CHoose to print the group header on each new page.

mlmcc

Author

Commented:
So lets say I put the CompanyName (which I want to group on) in the Page Header, would I then still add a group header, (which would go with the details), but maybe make it invisible, but use it for the 'force page break' aspect of grouping?
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Yes.  
Add the group
Put the information you want in the page header.
Suppress or hide the group header through the SECTION EXPERT
Set the NEW PAGE BEFORE on the SECTION EXPERT

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial