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

report "too long"

P: n/a
I have a report which has 3 sub-reports in the detail section. Everything
(subforms, detail section) is set to Can Grow and Can Shrink as True.

I have one record in which one of the subforms has about 7 detail items and
the other subforms have several detail items. When I try and print this
record it does not get past "Formating - Hit Control-Break" in the status
line. When I delete a couple of the 7 line items, it prints fine. Is there
something else besides the "can grow" that I am missing? It is as if it
doens't want the report to go to two pages and "hangs up".
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Try placing each subreport into a section of its own instead of all 3 in the
Detail section.

In the Sortin'and'grouping box (View menu), choose the Primary Key field. In
the lower pane of the dialog, choose Yes for group header and group footer.
This gives you 2 more sections that repeat for every record (each primary
key value).

Do that again on the next row of the Sorting And Grouping dialog to get
another group footer for your 3rd subreport.

Place each subreport in its own section.

That should make it easier for Access to calculate whether the entire
subreport can fit onto the page before it has to figure out whether the next
one will fit as well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Michael S. Montoya" <bl***@blank.com> wrote in message
news:2e*****************@newssvr14.news.prodigy.co m...
I have a report which has 3 sub-reports in the detail section. Everything
(subforms, detail section) is set to Can Grow and Can Shrink as True.

I have one record in which one of the subforms has about 7 detail items
and
the other subforms have several detail items. When I try and print this
record it does not get past "Formating - Hit Control-Break" in the status
line. When I delete a couple of the 7 line items, it prints fine. Is
there
something else besides the "can grow" that I am missing? It is as if it
doens't want the report to go to two pages and "hangs up".

Nov 13 '05 #2

P: n/a
perfect...thanks for such a quick solution

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:42**********************@per-qv1-newsreader-01.iinet.net.au...
Try placing each subreport into a section of its own instead of all 3 in the Detail section.

In the Sortin'and'grouping box (View menu), choose the Primary Key field. In the lower pane of the dialog, choose Yes for group header and group footer. This gives you 2 more sections that repeat for every record (each primary
key value).

Do that again on the next row of the Sorting And Grouping dialog to get
another group footer for your 3rd subreport.

Place each subreport in its own section.

That should make it easier for Access to calculate whether the entire
subreport can fit onto the page before it has to figure out whether the next one will fit as well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Michael S. Montoya" <bl***@blank.com> wrote in message
news:2e*****************@newssvr14.news.prodigy.co m...
I have a report which has 3 sub-reports in the detail section. Everything (subforms, detail section) is set to Can Grow and Can Shrink as True.

I have one record in which one of the subforms has about 7 detail items
and
the other subforms have several detail items. When I try and print this
record it does not get past "Formating - Hit Control-Break" in the status line. When I delete a couple of the 7 line items, it prints fine. Is
there
something else besides the "can grow" that I am missing? It is as if it
doens't want the report to go to two pages and "hangs up".


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.