Reports and grouping

  • Thread starter Thread starter rbruhn
  • Start date Start date
R

rbruhn

I was wondering if it was possible to have various pages
within a report group according to criteria. Such as, I
have two storage ID's: "SB3333" and "SC3333". The "SB"
designation has different levels and quadrants (L1Q1,
L1Q2, L2Q1, L2Q2), the "SC" designation has drawer levels
(A, B, C, D). There are catalog numbers under each of
these columns.
Right now, my report groups by ID and page breaks are
between the ID's. This works fine for the SB designation
because the report just goes into the designated box.
However, the "SC" designates a cabinet with different
drawers, and each drawer needs to have it's own list. I
wish to break between the level designations (A, B, C, D)
and have them on seperate pages.
Do I have to make two seperate reports? Or, is it possible
to change the grouping according to the criteria of SB or
SC and have each page of a single report print out
appropriately?
Sorry for the length. Would appreciate any suggestions.
R
 
Open report. Select design. Click on the 'sorting and
grouping' menu button (next to the 'hammer and wrench'
usually. You can sort and 'break' using this function.
My experience is that you have to 'toy around' with it a
bit to get it to do what you want it to do, but this
is 'button' to accomplish what you're looking for.

dr
 
R,

I don't think there should be any problem with this. Make a second
grouping level on the Drawer field, and use this to create a group
footer section on the report (Drawer Footer?). Possibly nothing needs
to be put in this section, but set its ForceNewPage property to After
Section. That way, the different drawers within the SC group will
show on separate pages, but this will have no effect on the SB group,
since presumably these records have no entry in the Drawer field.

- Steve Schapel, Microsoft Access MVP
 
Back
Top