Report Group Header

[Andrea]

I have a report grouped on a person ID, with only a group header and a detail
section. The report is actually a letter (or many letters as there are many
people in the query for the report) with two pages. I put the logo in the
group header as I wanted it to appear once for each person, on page one.
Instead, it appears on its own page and does not appear in the first or
second page of the report. Nor does it appear on the third page (first page
for second person). I've read what I could find here and I've set and reset
keep together -- grouping and sorting, and keep together for report sections.
But, I'm not having any success. Surely, this can't be this difficult?
I'd appreciate any help.

 

[Allen Browne]

Hi Andrea. You are certainly on the right track, putting the logo into the
group header.

Select the PersonID group header, and look at its Properties.
Make sure the Force New Page property is None.
Do the same for the Detail section.

Once you confirm that this is the setting that is causing the problem, you
can find a way to start each letter on a new page, such as setting the Force
New Page property of the PersonID group footer to "After section."

 

[Andrea]

Well, Force New Page is (already was) None for both sections. Footer for
PersonID already had After Section setting for Force New Page property (that
suggestion was actually in a thread here). But still, I get the group header
info on page one, the Person 1 letter page one, folllowed by the Person 1
letter page two. Person 2 shows up without a header. What else can I have
inadvertently set incorrectly? Any other ideas?

 

[Allen Browne]

To sort out what's wrong, set all the sections to no forced page break, and
the grouping'n'sorting so things don't have to keep together or anything
else in that dialog.

Then once you have it working (with all the letters running into each other
and a logo at the top of each one), you can force a page break after each
letter.

Or you may find you have inadvertently placed the logo in the Report Header
instead of the group header.

 

[Andrea]

Well, it's definitely in the group header (group header 0). But I don't get
all elements running together. The info in the group header is still on its
own page and then the remainder of the data in the detail section follows
(there is nothing in the group footer). I looked for a page break in the
detail and group header sections, but didn't find one. I'm not sure what
else I should look for.

 

[Allen Browne]

Andrea, how tall are your sections? Is the enough height to fit the group
header + the detail section + the top and bottom margins on the same page?

It's just remotely possible that a problem like this could be due to a bad
printer driver, since Access uses the printer driver metrics to calculate
how the report should be laid out. Try choosing a different default printer,
and preview it again.

What version of Access is this? If A2007, try Print Preview rather than
Report view or Layout view.

If none of that helps, you may be able to look at the internal defnition of
the report, and identify what's wrong. Open the Immediate Window (Ctrl+G),
and enter something like this:
SaveAsText acReport, "Report1.txt", "C:\MyFolder\Report1.txt"
substituting your report name for Report1. Then open the text file (with
Notepad) and have a read. You can ignore the PrtDevMode part, but see if
there's anything you can spot in the rest.

 

[Andrea]

Group header section is about 2" tall and detail section is more than one
page tall -- a little more than 13". I don't have another printer, but did
change to some printer choices evidently built in. Same problem.

I'm using Access 2003. With the saveas text command I get an error saying
argument not optional.


One thing I didn't say before is that the report is designed to be used in
conjunction with a form that limits the records to be displayed for person1
so there is only one record for each person -- i.e., the group. But it I
still get the header info on a separate page at the beginning whether I open
the report from the form or from the database window (where I can get several
people per group).

I'm at a loss. I'm going to go sleep on it and decide tomorrow if it's just
easier to rebuild the report.

 

[Allen Browne]

If the Detail section is too tall, it will go onto the next page.

Try reducing it so it all fits, e.g.:
Top Margin 1"
Group header 2"
Detail Section 6.9"
Bottom Margin 1"
Page header 0
Page footer 0
=================
Total: 10.9"

That should fit on an 11" page.

 

[Marshall Barton]

Group header section is about 2" tall and detail section is more than one
page tall -- a little more than 13". I don't have another printer, but did
change to some printer choices evidently built in. Same problem.

It's starting to sound like the detail section has its
KeepTogether property set to Yes.

 

[Andrea]

Well, that did it. Reducing the page size forced the group header info to
its proper location. However, I really needed two pages. So, I redesigned
the query feeding the report so I didn't need grouping and put the info that
was in the header back in the detail section and it now works fine.

You helped a lot and I learned a lot about what to check to try to
troubleshoot persnickity reports. Thanks.