Conditional Groups

  • Thread starter Thread starter trosen
  • Start date Start date
T

trosen

I have a group footer that I only want to print when the
field it's based has a value equal to "BASE". The rest
of the time I need it to be either invisible or
suppressed some other way. Does anyone know how I can do
this. Thanks!
 
I have a group footer that I only want to print when the
field it's based has a value equal to "BASE". The rest
of the time I need it to be either invisible or
suppressed some other way. Does anyone know how I can do
this. Thanks!
Click to expand...


I don't know all the details of your report, so try both of these and
see which works.

Code the Group Footer Format event:
Me.Section(?).Visible = [SomeField] = "BASE"

Change the ? in Section(?) to whatever the actual Group Section number
is in your report. It will vary depending upon report layout.

If it doesn't work in the Group Footer Format event, place the same
code in the Detail Format event.
 
I have a group footer that I only want to print when the
field it's based has a value equal to "BASE". The rest
of the time I need it to be either invisible or
suppressed some other way. Does anyone know how I can do
this. Thanks!
Click to expand...


I don't know all the details of your report, so try both of these and
see which works.

Code the Group Footer Format event:
Me.Section(?).Visible = [SomeField] = "BASE"

Change the ? in Section(?) to whatever the actual Group Section number
is in your report. It will vary depending upon report layout.

If it doesn't work in the Group Footer Format event, place the same
code in the Detail Format event.
Click to expand...

I mis-spoke. If the code doesn't work in the Group Footer, place the
same code in the Group Header Format event.
 
Back
Top