Need to suppress a field in the report based on a value

[Former Member]

I have a query where give me a input of data and it has a field called Include if this column has values of true only then the the suppress should be true else it has to be false. the issue is I am getting 1000 records for this query and need to check from these 1000 rows whether all has true values or false values. any support on the formula for supress

[abhilash_kumar]

Hi Shazmin,

1) Create a formula (@Suppress) with this code:

If {Include} = 'True' then 1

2) Right-click the Include field > Format field > Common tab > Click the formula button beside 'Suppress' and use this code:

Minimum({@Suppress}) = 1

AND

Maximum({@Suppress}) = 1

-Abhilash