Suppressing Detail rows 1

[padytom]

i have a column that has two values 1 and 0. these have been grouped and I want to suppress the detail of the group that has only 0s and show those that have both 1 and 0. any help?

 

[bdreed35]

To just suppress the Detail section if it only has 0's, you can suppress the detail section based on an Aggregate function.
Not sure if your field that can be 0 or 1 is numeric or a string, so you may have to adjust my solution for that.
Let's assume it is a string.

Open the Section Expert, click on the Detail section on the left, then click the X+2 button to the right of the "Suppress (No Drill Down)" property.
Add this formula, swapping with your fields:

Maximum({table.field},{table.groupingfield}) = "0"

Change = "0" to just = 0 if the field is a number.

A second option would be to use the Sum function if the field is a number:

Sum({table.field},{table.groupingfield}) = 0

~Brian

 

[padytom]

Thanks so much Brian. It works great