Dollars not showing correctly

[Timmkatt]

CR10-
I have several fields that are dollar amounts and are not showing correctly in the report. 50.00 shows as 5000 without the decimal. If I browse the data it appears correctly. Is there a way I can format the field so that it shows as 100.00, 50.00 etc. instead of 10000, 5000? I have tried format field and various number formats but with no luck. Thank you

 

[Madawc]

I'm puzzled that it shows differently on the report and in the data. But as a work-round, reference the data in a formula field and divide it by one hundred. Then show that.

You might also find that the field isn't numberic. You could make it so if necessary, which might fix the original problem.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

I would also check the number formatting in file->options.

-LB