The accounting software that my company makes uses Crystal Reports Viewer.
We often host the software for our clients... On a new setup, when reports are Exported to Excel 2010 - instead of seeing $0.00 we are seeing <Default Format>
My developers wrote the following to resolve the issue.
Note: Steps to resolve error related to this issue:
1) Open the report file with Crystal Reports.
2) Select all amount fields of the report, right click on it and select "Format Field".
3) Click on "Customize".
4) Change the field "Show Zero Values as:” from <Default Format> to zero or manually type 0.00 if needed trailing zeros(decimal format).
5) Click "OK" and save the report.
Six Million Dollar question - when I do the same export on my local machine running Win 7 and Excel 2010 - I don't have the issue with seeing <Default Format> .
The way my brain works makes me think there is a setting in Excel that would cure this... That would be a lot easier than having to tweak RPT files. I've compared the Excel settings and couldn't see any differences.
If it makes any difference, the Server is running Win Server 2003 and only has Excel and Word 2010 installed... My local Win 7 machine has the whole Office 2010 Pro installed.
Thoughts and Suggestion would be appreciated.
|