zero suppress the report

[sitmapa]

cr 8.5
vb 6.0

i have this conditional formula:

{database.fielda} <> 0

for select only the records that have any number different of zero in the fielda, but cr show record that have zero in this field.

i show this fielda in my program, and show the values like

006414E-14

how can exclude the record with this values....

thank´s for some help or any idea, i will be apreciate,,

saludos

 

[GMcNamara]

It looks like your numbers are very small but not quite zero. You need to choose a threshold and show all numbers greater than your threshold. For instance, {database.fielda} > 0.0125.

 

[Ngolem]

another way could be to truncate to say 3 decimals

Truncate({database.fielda} <> 0



Jim Broadbent