Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal Reports exporting and rounding issue

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!


Tags:
Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question