Hi All I am creating a cheque sp 1

[HyperHeidi]

Hi All

I am creating a cheque spec where I have a Debit & Credit columns. I need to have either the debit or credit to appear, but not both. Debit or credit can not have a 0.00 but rather I require blank.

Situation is:
If netAmt > 0 then print the value
If netAmt <=0 then suppress printing the value to the form

I have coded inside a variable called Debit:
if {APADV.NETAMTPD} < 0 then {APADV.NETAMTPD} else &quot;0&quot;

But the client does not want the 0.00 to show on the report.

I can not Suppress the detail line if APADV.NETMTPD = 0 because I print inside of the variable CREDIT beside it, and vice versa.

This code is going inside both of my variables on the same detail line, but debit prints when < 0 and credit prints when >0.

Thank you in advance
Hyper Heidi

 

[aker]

Sometimes the answers are staring you in the face. Go to the Help menu, and do a search for 'Suppress Zero'.

Hope this helps.
Regards.

 

[HyperHeidi]

I would love to go to HELP however, my company does not have HELP installed on the server, and IT has no idea where the cyrstal CD is. Otherwisde I would have done that first. Thank you in advance
Hyper Heidi

 

[Jacque]

Right click on the text field or formula, select format field, common tab and add your zero condition for the suppress object formatting.
For number fields, right click on the field, format field, number tab, hit the Customize button, number tab and you will see the Suppress if zero checkbox.

 

[HyperHeidi]

JACQUE!!!!!!
THANK YOU SO VERY MUCH!!!!! I WILL NOT FORGET THIS AREA EXIST!!! THANK YOU!!! THANK YOU!!!! Thank you in advance
Hyper Heidi