Tuesday, March 20, 2012

Crystal Reports 7 using wrong date format

Whenever one of my users prints any of our reports, the date is in dd/mm/yyyy format, when it should be in mm/dd/yyyy format. This might be more of a Windows settings issue rather than a CR7 issue, but it only seems to do this when a CR7 report is printed, anything else involving a date in any other software prints/displays correctly. I have checked the regional settings on their computer and they are all set properly. Uninstalling and reinstalling the CR7 runtime files didn't seem to help either.

Does anyone know if CR7 stores its own date formatting information? Thank you in advance.Use Field Formatting to set the format of the date. Else you can covert the date into a string also.

In case you need to pass date as a parameter, Crystal Reports allows you to pass the date in three pieces (Date, Month and Year).

Hope you will solve the problem.

Kangkan

<a href="http://links.10026.com/?link=http://www.geekays.net">geekays.net</a>sql

No comments:

Post a Comment