Group Suppress

[Smithsc]

Is it possible to suppress an entire group (including any sections within) based on a field in the detail section?

 

[lbass]

Do you mean if the group contains a field with a certain value? If so, yes. Create a formula like this:

//{@hasA}:
if {table.field} = "A" then 1

Then use group selection (not suppression) by going to report->selection formula->GROUP and entering:

sum({@hasA},{table.groupfield}) = 0

This would select all groups that did NOT contain "A". You would then need to use running totals for any calculations across groups, since non-group selected records would contribute to the more usual inserted summaries.

-LB

 

[Smithsc]

Thanks for the help. Unfortunately it keeps telling me the field cannot be summarized. What have I done wrong?

 

[lbass]

You will have to show the content of the formulas you used.

-LB