Page Header and Group Header 1

[smibarb]

I have inserted a new group in a report. The information that appeared in the Report Header should now be in the Group Header and print at the beginning of each group. However, I would like the Page Header to appear under the Group Header, not above it. How can I acheive this?

Thanks in advance.

 

[smibarb]

P.S. I am using version 11

 

[synapsevampire]

Place the fields in the page header, and then in the group footer formatting turn on the new page after.

-k

 

[lbass]

In other words, you could place the groupname in Page Header_a, and the page header fields in a newly inserted Page Header_b.

-LB

 

[smibarb]

Thank you. I put the group name in Page Header_a and suppressed this section after page one for each group. Perfect!

Now I want to have a form letter that prints at the beginning of each group as well. I thought I would create a Page Header_c and format it similar to above. Problem is, I wanted to start a new page after the letter (in other words, letter for group 1, new page report for group one, new page letter for group 2). Of course, it won't let me - it wants the page header and page footer on the same page (go figure) with the report in the middle. Any suggestions?

Page 1
Form letter group 1

Page 2
PageHeader_a Group 1(Contains info from Suppressed Group Header)
Page Header_b (contains column headings)
Details
Page Footer

Page 3
Page Header_a suppress
Page Header_b
Details
Group Footer Group 1
Page Footer

Page 4

Form Letter Group 2

etc.

 

[lbass]

Put the form letter in the group header and then format that (in the section expert) to "new page after". You should also have "new page after" set for the group footer, but with a formula in the x+2 formula area:

not onlastrecord

-LB

 

[smibarb]

Oh thank you, I am almost there! Right now everything appears as I like except the page numbers. The letter appears as page one, and then the report follows as page 2 and so on,until the next group. I do not want a page number on the letter. If I reset the page number after the group I could probably suppress the page number on the group header (not sure how), but the problem is that I suppress my various page headers depending on the page numbers and I cannot have two page ones. Is there another way I can achieve this?

Page 1 (no page number)
Form letter group 1 (Group Header) no page number

Page 2 (labelled page 1)
PageHeader_a Group 1(Contains info from Suppressed Group Header)
Page Header_b (contains column headings)
Details
Page Footer

Page 3 (labelled page 2)
Page Header_a suppress
Page Header_b
Details
Group Footer Group 1
Page Footer

Page 4

Form Letter Group 2 (no page number)

etc.

 

[smibarb]

Oh yes, and one other thing. My report is landscape but I would prefer my letter in the group header to print portrait. Is this possible?

 

[smibarb]

Further to my last post -

I found a way to rotate the text of my letter, I guess this could work to achieve the "portrait" orientation in the group header, but the OLE object (company letterhead) does not seem to be able to be rotated.

So, in summary, I am stumped on the page numbering and the orientation of my letterhead graphic in the form letter.

Thanks for your time.

 

[lbass]

First, format your group footer to "new page after" and to "reset page number after". For the pagenumber, create a formula:

pagenumber - 1

Insert another page header section and drag it so that it becomes the topmost section, and then place the page number formula in this section. In the section expert, check Underlay following sections for PH_a and also go to->suppress->x+2 and enter:

pagenumber = 1

This will align the pagenumber with the groupname in PH_b when it is not suppressed. You can still use:

pagenumber in [1,3]

...to suppress PH_b, and pagenumber = 1 to suppress PH_c.

As far as I know, there is no way to print part of a report in landscape and part in portrait.

-LB

 

[smibarb]

Thanks again, as usual you nailed it.

I am able to print the letter "portait" in the Group Header section by rotating the text field 90 degrees. I am unable to rotate the object (company graphic) so I will just request our graphics dept to rotate the graphic in their program and I will use that.