How to make a label invisible on report pages containing no detail

[Guest]

I'm creating a report that has long section headers. The structure of the
report data will always be one section header page followed by one or more
detail pages.

I wanted some labels in my Page Header to be invisible on that "section
header page", and only show up on the detail pages.

1. Is it possible?
2. Where should I place the code? The label objects themselves cannot
handle event procedures.
3. What will be some key objects to use, ie. how would the core pseudo code
look like?

Thanks!

 

[Allen Browne]

In the Sorting and Grouping dialog (accessed through the View menu in report
design view), create a second group header on the same field.

On this second instance, set the Keep Together property (lower pane of the
Sorting And Grouping box) to With First Detail. In the Properties box, set
Repeat Section to Yes.

Put the labels into this second group header. This second header will now
appear on the same page as your previous group header if there is room for
it and at least one detail record. Otherwise it will appear on the next
page. If the Detail records do spill over onto a new page, this group header
will appear at the top of the overflow page also.

 

[Guest]

Super!!!! Thank you so much Allen! You rock!!!!