Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format Editor

Status
Not open for further replies.

byteias

Programmer
Apr 17, 2007
68
US
Using CR XI SP 3 with Oracle 9i.
I'm using the Format Eitor to supress printing if the field=0 (Decimals 1, Rounding 1). But, if the field is = 0.02 or 0.001- it will print 0.
Is any way there without using a separate formula to suppress them (I have 75 numeric fields)?
Thanks,
Ivan.

 
Select all relevant fields->format field->suppress->x+2 and enter:

round(currentfieldvalue) = 0

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top