Report based on view currency shows 4 decimals

[Rich196]

I have a report based on a view. The field in the view comes from a table that has the correct format for currency and displays correctly when browsed. (Format $, InputMask 999,999.99) The report shows the field as $999.9999. I have set the property for the field in the view designer as Format $, InputMask 999,999.99 but it still shows with 4 decimals. I have tried all kinds of combinations to no avail.

I can SET DECIMAL and SET FIXED to get the correct display for the currency but the other numeric fields then have decimals.

How can I just affect the currency decimals in the report?

Rich

 

[craigsboyd]

Put the following in format on the Report Expression dialog box for your report field(s):

@$ 999,999.99

The space between the $ symbol and the 999,999.99 has to be there for it to format correctly.

http://www.sweetpotatosoftware.com

 

[Rich196]

Thanks Craig,

Right on! I didn't have the space after the $ in the report expression. Strange how that makes the difference.

Rich