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!