Repeat Section Problem

[Tom]

Hi:

I'm having a problem with a simple report in a simple database.
Basically it's an issue tracking database - what is the issue, what is
the proposed solution, who is responsible, a tracking number, and that
is it. Two tables - one for the issue, one for the people (one issue
can have more than one responsible person). No code - whole thing
slapped together in 15 minutes.

The report is set up to print the tracking number, issue, and solution
in the detail section, grouped on responsible person. I wanted the
responsible person section header to repeat on each page.

The problem is that Access takes FOREVER to format this (it's only
about 40 records long). If I set the group header to not repeat, it's
done immediately. Some of the issues or solutions can be very long
(both memo fields) and can span multiple pages. If I take out the
real data and put in dummy stuff only a few characters long, there is
no problem with the repeat header.

So it seems that Access is choking on group headers repeating where
one detail record spans multiple pages. Is there any solution to
this? Or do I just live with it? Or am I missing something.

Thanks

[Tom]

Update:

I've further confirmed that the issue revolves around the long memo
fields. If I set the detail fields to CanGrow = false, the report is
well-behaved. Unfortunately, CanGrow = false is not a solution - only
a troubleshooting approach. I still need the complete detail fields
with a repeated group header.

Thanks

[Tim Marshall]

Tom wrote:

So it seems that Access is choking on group headers repeating where
one detail record spans multiple pages. Is there any solution to
this? Or do I just live with it? Or am I missing something.

I ran into exactly this myself a while back with a major application and
very long reports stored in records. If you fiddle with the "keep
together" property of the headers and detail section, changing them to
NO, this should clear up.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Tom]

Cool - the keep together on the detail was what I was missing.

Thanks

[Tim Marshall]

Tom wrote:

Cool - the keep together on the detail was what I was missing.

The unfortunate issue with the solution I offered is that sometimes,
with a footer, the text gets cut off about halfway on the last line.
It's an infrequent enough occurrence with my app that I'm just shrugging
and not going to pursue it further unless I get complaints from my
users. 8)

The other thing that is a PITA is when a record gets split over more
than one page. Even with the headers on repeat on page break, it
sometimes doesn't "look right".

For the most part, it's OK.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me