Crystal Report number reformat
Posted on 2009-04-09
I have a crystal Report which displays a dollar amount from a database field (which is defined in the database as (NUMBER 19, 2). Instead of displaying the field with edits, i need to display as and unedited field (no decimal point, no dollar sign) with leading zeroes. I checked the normal field edits for a numerical field and you can remove the dollar sign, but can only replace the decimal with another character (I don't want any anything in the "decimal point" character. Also, i don't see any way to place leading zeroes in the field. I would assume that i need to use a formula to do this.