Is there a way to filter out groups that only have a 0 value? I've got a true/false 0/1 formula and need all jobs that have any 1 in it at all, so if there are 0s and 1s then I want to include it or if it's only 1s but not if it's only 0s

Is there a way to filter out groups that only have a 0 value? I've got a true/false 0/1 formula and need all jobs that have any 1 in it at all, so if there are 0s and 1s then I want to include it or if it's only 1s but not if it's only 0s

• crystal-reports

1 Answer 1

Step 1: create a group-level Sum (or Max) of the 0/1 formula.

Step 2: Create a Group Selection Formula of @Group_Sum_Formula > 0
(or @Group_Max_formula = 1).