Re: report "too long"
- From: "Michael S. Montoya" <blank@xxxxxxxxx>
- Date: Fri, 29 Jul 2005 01:19:27 GMT
perfect...thanks for such a quick solution
"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:42e980e7$0$5425$5a62ac22@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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".
>
>
.
- References:
- report "too long"
- From: Michael S. Montoya
- Re: report "too long"
- From: Allen Browne
- report "too long"
- Prev by Date: Re: How to make all access to linked table read-only
- Next by Date: Re: How to make all access to linked table read-only
- Previous by thread: Re: report "too long"
- Next by thread: Using NOW() to display long date in a report
- Index(es):
Relevant Pages
|
