How do I supress field data that equals 0 ? 1

[TheLibrary]

I have a column of data that has mostly (0) zero data entries. I want to supress to 0's to bring more attention the the quantities present.

If I setup the supression formula for the data field as:
If {qty} = 0 then "yes" else "no"
I get an error message saying the formula must be boolean?

I think I'm going about this all wrong.

Advice?

 

[vidru]

Don't have Crystal in front of me, but this should point you in the right direction.

Right click on your field > Format Field > click on the Number tab > click Customize button > there should be a 'Suppress if zero' checkbox. I believe that's what you're looking for.

-dave

 

[Reebo99]

A suppression formula needs the result to be a boolean, i.e. true or false. Therefore, your formula should have read:
{qty} = 0

if the value of {qty} is 1, then the result is false as {qty} does not equal 0, etc.

Using the suppress if zero option is best in this case, but I hope this helps with the suppress formula in the future...

Reebo
UK

 

[Madawc]

I'd put the check in the Report Selection, found by [Edit Selection Formula] under [Report] in Crystal 8.5. Quicker and easier if the unwanted records are discarded at the start of the run.

Madawc Williams
East Anglia, Great Britain