Crystal Reports exporting and rounding issue

[Former Member]

I'm working in Crystal Reports 2013 SP5 and building reports off of views.  The database is SQL Server 2008 R2.  In the view, I am rounding some dollar amounts to have only 2 decimal places and it seems successful.

The round function:

ROUND(SUM(list_price), 2) dollar_list_price

Querying the view for this column:

I have also done formatting on the numbers in Crystal to only show two decimal places.  When I export the report using the Microsoft Excel (97–2003) option, the resulting file shows the numbers as having two decimal places.  However, when I select the number, it shows up in the function bar with 4 decimals.

I'm not even sure how Crystal has 4 decimal places to export because the round function in the view should only be returning two decimal places to Crystal.  Any advice on how to get the value to have 2 decimal places would be much appreciated!

[abhilash_kumar · Accepted solution]

Hi Pooja,

I remember I had a similar issue in the past. The workaround is to create a formula in the report using the Round function:

Round({database_field},2)

-Abhilash

[Former Member · Accepted solution]

That worked, thanks!

Do you know why the round function in the view is not taking care of this for me?