Supress Zero Values 1

[maeling]

If a report is returning rows of values and rows of zero values how can I supress the zero value rows.

 

[synapsevampire]

To eliminate the rows from the report entirely, so that you don't have to suppress, in the record selection formula (Report->Edit Selection Formula->Record) place something like:

(
{Table.Field1value} <> 0
and
{Table.Field2value} <> 0
and
{Table.Field3value} <> 0
)

This says that if all 3 of these fields have a value of 0, then don't retrieve them.

Change the table.fields to yours.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Hm786]

Right click the field and in the common tab, double click the right side button of the suppress and write the formula Your field name =0 then the fields with zeros are suppressed.

Thanks,
Hamida

 

[roatis]

If it is a numeric zero, simply format the field and put a check in the box that says &quot;supress if zero&quot; Rod Oatis
Venturi Technology Partners
Crystal Decisions Certified
Trainer/Consultant/Developer/Implementor
Rod_Oatis@hotmail.com