Grouping question.

[Frank Martin]

We designed out multipart-paper invoice report in several sections.

1/ Report header/footer.

2/ Page header/footer.

3/ DeliveryID header (only).

4/ CustID header (only.)

5/ OrderID header (only.)

The DeliveryID and CustID contain only a subreport appropriately linked to
the Customer and Delivery subforms.

The OrderID header is for the Order number, Inv date etc.

The 'details' section of the report is for "invoice lines".

We ask the following questions:

(a) Why is it necessary to name the extra sections after a field? Any
field seems to work and we need to know the significance of this.

(b) Even with the above subreports in their own sections, we sometimes
have trouble with an overflowing field forcing the sections down the
invoice-paper printout. Of course we have applied the relevant can-shrink
can-grow properties. Is there something else we can try here?

(c) How close can the above sections be to one another on the invoice
paper before they start conflicting with one another vertically?

Should we use footers for the above DeliveryID, CustID, OrderID sections?

Please help, Frank

 

[Marshall Barton]

We designed out multipart-paper invoice report in several sections.

1/ Report header/footer.

2/ Page header/footer.

3/ DeliveryID header (only).

4/ CustID header (only.)

5/ OrderID header (only.)

The DeliveryID and CustID contain only a subreport appropriately linked to
the Customer and Delivery subforms.

The OrderID header is for the Order number, Inv date etc.

The 'details' section of the report is for "invoice lines".

We ask the following questions:

(a) Why is it necessary to name the extra sections after a field? Any
field seems to work and we need to know the significance of this.

It'a not significant. Access just shows the group's
field/expression in the section's header/footer separator
bar. The actual name of a section is whatever's in the
section's name property, which you can change if you like.

(b) Even with the above subreports in their own sections, we sometimes
have trouble with an overflowing field forcing the sections down the
invoice-paper printout. Of course we have applied the relevant can-shrink
can-grow properties. Is there something else we can try here?

If you don't want an over/under flowing field to push other
things down/up, then you can't use CanGrow/CanShrink for
that field.

(c) How close can the above sections be to one another on the invoice
paper before they start conflicting with one another vertically?

Each section follows immediately after the previous section.
They can not conflict with one another. Any space you see
between sections is space you left at the bottom of one or
the top of the next.

Should we use footers for the above DeliveryID, CustID, OrderID sections?

No, I don't think so. But, make a copy of the report and
try it to see if you like it.

 

[Frank Martin]

Many thanks. We will turn off the "CanGrow" in the properties of the
subreport window.
Regards Frank