How can I supress a section header if the value returned for the header is empty?

[Dave]

I have a Grouping withing a Report that may or may not contain a value. If
there is no value for this grouping field, I want to supress the grouping
header. IOW I do not want it to take up any space in the report.

For example, I have a report that has two groupings: one by country and one
by state. There should always be a country value but there may not be a
state value. If there is no state value, I do not want the report to create
an empty state header (leaving a blank space in the report). I simply want
it skip this header all together and move right into the detail section.

I set the "Can Shrink" property for this section to "Yes." And I played
around with _format and _print events, settting the visibility of the state
textbox to false. But this isn't working.

How do I supress a section header if the value returned is empty?

 

[Jeff Boyce]

Dave

You may need to set the CanGrow & CanShrink properties of both the Header
and any controls within the Header.

I'm confused, though... if you don't have a grouping value to show in the
header, how could you have (corresponding) detail section records?