Exchange Rate in Crystal Report Rounds Down to Incorrect Value

[helen_jim]

Dear Expert,

I am seeking assistance in resolving a number formatting issue within a Crystal Report.

The exchange rate displayed for marketing documents requires precision to six decimal places. However, despite inputting an exchange rate of 1.467750, the value presented within the Crystal Report is rounded down to 1.000000.

Attached, please find the field format of 'DocRate' in the Crystal Report for your reference.

Your expertise in addressing this discrepancy would be greatly appreciated.

Regards,

Helen Jimuntitled1.jpg

[Abdul]

It depends upon the decimals settings in general setting, have you allowed SAP to save 6 decimals? if yes please check the data stored in DB.

if DB has 6 decimals then simply convert it to text and crystal report will no round it.