I have a field on my report that displays an amount... I am having difficulty getting the format output to be the way that I want...

What I would like is the amount, 2 decimal places, with a floating dollar sign before it.

My was set for NUMERIC and the format string was $$$$,$$9.99. This worked fine when I was printing the field from the database file. Now that it is either the field from the file or the result of the field times another field (time*rate) which is stored AS in the cursor, I get ********* for the printout.

If I remove the format string entirely, I get the appropriate value (minus the $). If I set it for NUMERIC and CURRENCY, which puts in a @$ for the format, the amount of 140.00 shows as $140.00, the amount of 65.00 shows as $65.000.

I checked the settings according to the "regional" for currency and that seems to be correct. Am I missing something or does it have to do with the AS in the SELECT statement that stores the result in a variable in the cursor. Should I predeclare that cursor variable somewhere, somehow as a currency amount?

Thanks