How to cancel printing of group header sections on report

[Eddy]

Is there a means to cancel the printing of a groupheader section on a report
so the subsequent sections move up on the page thus eliminating a blank space
on the report where the canceled section would have been. I want to trigger
this based on the value of the sole field in the groupheader section. Simply
put, if it is null section is eliminated and sections below move up.

Thanks

 

[fredg]

Is there a means to cancel the printing of a groupheader section on a report
so the subsequent sections move up on the page thus eliminating a blank space
on the report where the canceled section would have been. I want to trigger
this based on the value of the sole field in the groupheader section. Simply
put, if it is null section is eliminated and sections below move up.

Thanks

If you wish to cancel the GroupHeader section if the Control is Null,
code the GroupHeader Format event:

Cancel = IsNull([SomeField])

 

[Marshall Barton]

Is there a means to cancel the printing of a groupheader section on a report
so the subsequent sections move up on the page thus eliminating a blank space
on the report where the canceled section would have been. I want to trigger
this based on the value of the sole field in the groupheader section. Simply
put, if it is null section is eliminated and sections below move up.

If the section's CanShrink property is set ot Yes, you can
make the section invisible in its Format event.

Even easier, is to use the section's Format event to cancel
the event:

If <some condition> Then Cancel = True