I am fairly new at using Crystal Reports with Adagio and have been trying to create a formula that when the field has a "zero" qty it will return a - (dash)instead of a 0 otherwise it returns the value but have been unsuccessful. This is the formula I tried ...

IF {ICW65 Items.Qty on sales order} = 0 THEN "-" ELSE {ICW65 Items.Qty on sales order}

Can anyone tell me what I am doing wrong.

Thanks,

Also I do not want to just surpress the zeros.

Hi Reen,

Crystal Reports wants both the 'True' and 'False' results to have the same data type. In your example, the 'True' result is a character, but the 'False' result is a number. This is an error as far as Crystal Reports is concerned.

There is a way to do this without even having to create a formula field. Assuming you have the 'Qty on Sales Order' field already in your report, right-click on it and pick 'Format Field' from the pop-up menu. From the Number tab, click the Customize button below all the pre-defined number formats.

On this 'Custom style' screen at the bottom right side, there is a selection for 'Show zero values as', and a dash is one of the available choices. Pick this and click OK to save it. Now when you print the report, zeroes are replaced by dashes.

Thank you. I had been through the format field section but missed the setting for zeros.

Much appreciated.