Conditional Printing of a Label and Field

[dnsquires]

I am working with Crystal Reports 6.0 and have a question. I am developing a report to display any back order amount of an order. If any of the items on the order contain a back order amount, the label (B/O) and amount need to be displayed for all items (if there is no back order amount, 0 is to be printed). If none of the items on the order contain a back order amount, nothing is to be printed.
The information for the report comes from an SQL database table that contains a column for the back order amount (which is the scheduled amount - invoiced amount)

Any help would be greatly appreciated!

 

[paulmarr]

Dear dnsquires,

You need to write a formula instead of a label, that checks if that back order field is greater than zero, if it is, then "Back ORder Amount:" else "", which will print nothing.
Use the formula as a label.
Cheers,

paulmarr@arcom.com.au

 

[dnsquires]

I tried that and what I need is if 1 item on the order has a back order amount then every item on the order should print the "Back Order Amount:" label and the amount (even if the amount is zero). I am just having trouble trying to figure out how to get the formulas on the report to recognize that.