GROUP HEADER SUPPRESSION 1

[77walker]

I have several levels of groupings that I will need to display based upon detail value that is false. Here is the group levels:
Location
Position
Emplastname
dttm/class attended = false

There could be two employees that were supposed to have attended a class but only one did. I need to display all levels of groupings if the employee did not attend. I am having trouble with the logic to not display a Position grouping if there's only one employee who has attended, and displaying the Position grouping if there were two employees where only one has not attended.

 

[lbass]

Please clarify. Is it that you ONLY want to show the Position grouping if at least one employee did not attend a class?

If so, create a formula like this:

//{@DidNotAttend}:
if {table.dttm/class attended} = false then 1

Then go to report->selection formula->GROUP and enter:

sum({@DidNotAttend},{table.Position}) > 0

-LB

 

[77walker]

Yes, that is correct thank you your suggestion worked great.

-lw