By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,100 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

Repeat Section Problem

P: n/a
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

Mar 14 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Mar 14 '07 #2

P: n/a
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
Mar 14 '07 #3

P: n/a
Tom
Cool - the keep together on the detail was what I was missing.

Thanks

Mar 14 '07 #4

P: n/a
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
Mar 14 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.