Re: report "too long"
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Fri, 29 Jul 2005 09:05:42 +0800
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" <blank@xxxxxxxxx> wrote in message
news:2efGe.7886$_%4.4153@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>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".
.
- Follow-Ups:
- Re: report "too long"
- From: Michael S. Montoya
- Re: report "too long"
- References:
- report "too long"
- From: Michael S. Montoya
- report "too long"
- Prev by Date: report "too long"
- Next by Date: Re: How to make all access to linked table read-only
- Previous by thread: report "too long"
- Next by thread: Re: report "too long"
- Index(es):
Relevant Pages
|
