asked on

CRYSTAL REPORTS print full dollar field

I want to print a dollar field on a report with the following characteristics:

No dollar sign
No decimal point
print full size of field, up to 7 digits, including leading zeroes (FYI if field contains 56.71 I want it to print as 0005671)

I tried playing around with \the "format field" options, but could not get it to do these things.
Please advise

SOLUTION

dhobale

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mbroad02

ASKER

Not that I don't appreciate your response but isn't there a simpler way?

SOLUTION

dhobale

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dhobale

I forgot to mention, before you pass your field to this function, you need to replace the decimal i.e. multiply by 100.

ASKER CERTIFIED SOLUTION

James0628

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mbroad02

ASKER

While I appreciate the dhobale answers, james0628's answer was perfect. Worked great and was simple!
Thanks

James0628

I assume that you're referring to the DisplayString option. It can really simplify things. The only real issue I have with it is that it's something I don't use often, so if I come back and look at a field later that used DisplayString, I may have some trouble figuring out how I formatted that field. :-) The fact that a supposedly numeric field doesn't have a Number tab in the format window could be particularly confusing.

Anyway ...

You're welcome. Glad I could help.

James