Group Header Splits When Spanning Multiple Pages

Coder09,

Please provide the settings... I would like to try to duplicate is as it
happened to me once and it turned out to be the margins for the printer vs.
the report.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"coder09" wrote in message
...
Thanks for the reply. The margins are set appropriately, per what the
printer can accept.

coder09 wrote:

Yes, the repeat section header is being split. It is the only header
I have, but I have multiple other Field/Expression entries within the
Sorting and Grouping menu (Time and Date), if that effects anything.
I've tried the ForceNewPage property, but it did not have any effect.


How can that be? If it's at the top of the Sorting and
Grouping list, it's the first section in the report (except
for the report header that was never mentioned). After the
first time, the RepeatSection property should only display
it at the top of any subsequent pages.

Barring some bizare corruption, all that just strikes me as
being impossible for Access to mess up. I suspect that Gina
is onto something re the printer. The first thing I would
check is to make sure the Access page height is the same as
the printer's page height. But if your printer's driver is
out of whack then anything can go berserk.

--
Marsh
MVP [MS Access]

I will provide the settings as soon as possible, Gina, as I am out of
the office currently. Marsh, there is a report and page header and
the subreports are in the Detail section. If data in the other
subreports force another subreport to near the end of a page (and the
group header cannot fit), Access will cut it and display the rest on
the other page. Sorry, if I didn't clarify appropriately.

Thanks

Okie dokie...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"coder09" wrote in message
...
I will provide the settings as soon as possible, Gina, as I am out of
the office currently. Marsh, there is a report and page header and
the subreports are in the Detail section. If data in the other
subreports force another subreport to near the end of a page (and the
group header cannot fit), Access will cut it and display the rest on
the other page. Sorry, if I didn't clarify appropriately.

Thanks

Gina,

Here are my margin settings:

Top is .256; Bottom is .5; Left is .4; Right is .459. The report is
set to landscape and extends to 10" horizontally. Vertically, there
are approximately 50 subreports, which may or may not appear, based
upon if there is data or not (there is also a report header, page
header, and page footer. This is meant to fit standard 8.5" x 11"
paper.

I've tried modifying the margins upwards and downwards and didn't have
any success.

Thanks


On Jul 23, 9:21*pm, "Gina Whipp" wrote:
Okie dokie...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"coder09" wrote in message

...



I will provide the settings as soon as possible, Gina, as I am out of
the office currently. *Marsh, there is a report and page header and
the subreports are in the Detail section. *If data in the other
subreports force another subreport to near the end of a page (and the
group header cannot fit), Access will cut it and display the rest on
the other page. *Sorry, if I didn't clarify appropriately.

Thanks- Hide quoted text -

- Show quoted text -

Update - I created a test database with one table, one query, and
three reports (one main report and two to be included as subreports).
I was able to reproduce the issue, so that rules out any code issues
or property setting strangeness that may have been a part of the
production database. Don't know if that helps, but it's in the
direction of narrowing down the problem. I'll try to host it
somewhere, so that someone can take a look. I can't attach files on
this forum. Thank you

Which is why I am leaning towards the Printer having the issue. As I said,
had this happen once and drove me crazy until I figured out it was the
printer not the database. It has something to do with the amount of
subreports and the printer not understanding. I am now, in between working
on my regular Client stuff, trying to find the database that I have this
problem on so I can see how I fixed it.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"coder09" wrote in message
...
Update - I created a test database with one table, one query, and
three reports (one main report and two to be included as subreports).
I was able to reproduce the issue, so that rules out any code issues
or property setting strangeness that may have been a part of the
production database. Don't know if that helps, but it's in the
direction of narrowing down the problem. I'll try to host it
somewhere, so that someone can take a look. I can't attach files on
this forum. Thank you

Great! Thank you so much!

coder09,

Okay, I FINALLY found the report! Yippee!!! It occurred because the main
report header and the subreports report header all were vying for the
*report header* section and neither *realized* that they both could not fit.
What I did to fix was... I created my main report and header to always have
the same information and put my subreports in the report footer with page
breaks. I had a logo which I did not wnt to *store* on each subreport so I
placed that in the page header.

I should also note, it was not a Printer issue it was in fact an Access
report issue. I think what it came down to is if the header on the main
report and the subreports exceeds the length of the printable area you get
the overflow and because it is report/subreport and each actually prints
without the others notice they both try to fit. However, if they are both
together do not exceed that length try setting the section to Can Shrink =
Yes.

I hope I explained that so it is understandable!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"coder09" wrote in message
...
Great! Thank you so much!

Thank you, Gina. I really appreciate you looking that up for me.
However, that is unfortunate that your fix involved page breaks, as
the reason I implemented the group headers and "=1" trick was to
eliminate page breaks and the code that was required to properly
control them with my database. Interestingly, I was not able to make
the subreports break across pages with Access 2007 running in
compatibility mode (Access 2002-2003 database) versus Access 2003,
which I had been using. I guess it's back to the drawing board. If
anyone else has any ideas, I appreciate the help.