Multiple Detail sections?

J

Joel Wiseheart

I need to be able to group four sections of a report in
the following fashion:

Header

Group 1 Header
Group 1 Detail
Group 1 Footer

Group 2 Header
Group 2 Detail
Group 2 Footer

Group 3 Header
Group 3 Detail
Group 3 Footer

Group 4 Header
Group 4 Detail
Group 4 Footer


Access seems to only want to group the information this
way:

Header

Group 1 Header
Group 2 Header
Group 3 Header
Group 4 Header
Detail
Group 4 Footer
Group 3 Footer
Group 2 Footer
Group 1 Footer

Is there any way to get multiple "Detail" sections like
the first example?

Thanks!
 
M

MGFoster

Joel said:
I need to be able to group four sections of a report in
the following fashion:

Header

Group 1 Header
Group 1 Detail
Group 1 Footer

Group 2 Header
Group 2 Detail
Group 2 Footer

Group 3 Header
Group 3 Detail
Group 3 Footer

Group 4 Header
Group 4 Detail
Group 4 Footer


Access seems to only want to group the information this
way:

Header

Group 1 Header
Group 2 Header
Group 3 Header
Group 4 Header
Detail
Group 4 Footer
Group 3 Footer
Group 2 Footer
Group 1 Footer

Is there any way to get multiple "Detail" sections like
the first example?

Thanks!
Click to expand...

Subreports.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
 
J

Joel Wiseheart

-----Original Message-----


Subreports.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

.
Click to expand...
I've tried that. I get an error pertaining to the bottom
section: Error number 2100: The control or subform control
is too large for this location.

Somehow, I need to get this subreport to continue onto the
next page, if it hits the bottom.

Since the number of records in the detail sections can
vary, the size of the subreport grows or shrinks with it.
 
L

Larry Linson

I've tried that. I get an error pertaining to the bottom
section: Error number 2100: The control or subform control
is too large for this location.

Somehow, I need to get this subreport to continue onto the
next page, if it hits the bottom.

Since the number of records in the detail sections can
vary, the size of the subreport grows or shrinks with it.
Click to expand...

Have you set all the Subreport Controls' CanGrow and CanShrink property to
Yes? Have you set the main Report's Detail Section's CanGrow and CanShrink
property to Yes? Have you then squeezed the Subreport Controls in Design
View so they all fit on the Page?

When is it that you are getting Error 2100? In Design View or at Runtime?

Larry Linson
Microsoft Access MVP
 
Top