Group header makes report too long

  • Thread starter Thread starter Barry A&P
  • Start date Start date
B

Barry A&P

I am working on a report for a list of items grouped by part number, in the
group header i have the part number and description and in the detail i have
the Serialized info in a stepped type report. this is great for groups that
have 20 or 30 records but the 5 or 6 hundred records with one detail record
all become Two Liners wich add 20 pages to the report. I would like to get
rid of the group header and add a part number and description control to the
detail section but i ONLY want the first record in each series to have these
controls visible so that each new series is easily visible.

Like this

Part type a, Item 1
Item 2
Item 3
Item 4
Part Type b, Item 1
Item 2
item 3
Part Type c, item 1
Part Type d, Item 1

Not like this
Part type a,
Item 1
Item 2
Item 3
Item 4
Part Type b,
Item 1
Item 2
item 3
Part Type c,
item 1
Part Type d,
Item 1

Thanks For any help
Barry
 
Hi Barry,

You can do this by moving the textbox containing Part Type into the (I
assume) Details section, and set its Hide Duplicates property to Yes. Then
remove the grouping (or close up the Group Header section to zero height).

HTH,

Rob
 
Have you tried moving the controls from the group header to the detail
section and setting their Hide Duplicates property to Yes. Then you shouldn't
need a group header section.
 
Barry said:
I am working on a report for a list of items grouped by part number, in the
group header i have the part number and description and in the detail i have
the Serialized info in a stepped type report. this is great for groups that
have 20 or 30 records but the 5 or 6 hundred records with one detail record
all become Two Liners wich add 20 pages to the report. I would like to get
rid of the group header and add a part number and description control to the
detail section but i ONLY want the first record in each series to have these
controls visible so that each new series is easily visible.

Like this

Part type a, Item 1
Item 2
Item 3
Item 4
Part Type b, Item 1
Item 2
item 3
Part Type c, item 1
Part Type d, Item 1

Not like this
Part type a,
Item 1
Item 2
Item 3
Item 4
Part Type b,
Item 1
Item 2
item 3
Part Type c,
item 1
Part Type d,
Item 1
Click to expand...


HideDuplicates should take care of it for the simple example
you posted. A more versatile approach is to add a line of
code to the group header section's Format or Print event
procedure:

Me.MoveLayout = False

OTOH, if you can fit two or more items on a single line, you
might want to consider putting all the item stuff in a
subreport with 2 or more columns. The main report would only
have the part info in its detail section and the subreport
next to it. The report would look then look like:

Part type a Item 1 Item 2
Item 3 Item 4
 
Back
Top