Tim Mackey's Weblog
.Net Windows Forms
Wednesday, 02 August 2006
Crystal Reports: not picking up correct date format
i'm part of the dd/MM/yyyy world, and that often means running into problems when using software developed with MM/dd/yyyy defaults, such as crystal reports.
i have all the report options set to use the system defaults, which are regionally set to ireland in windows, but that isn't enough, the dates still come out in MM/dd/yyyy format. i have the date + date/time fields customised within crystal reports to dd/MM/yyyy but that isn't enough either. with lots of hours googling and no answers that worked, i resorted to searching the registry and found that some of the user accounts were still using US regional settings. If you look in HKEY_USERS > you see a list of all the account IDs on the computer. My guess is that crystal reports must use the SYSTEM account or another non-interactive account, and it takes the regional settings from there. So if you search for sShortDate in the registry, you will find all the appropriate settings and can replace the MM/dd/yyyy values with your preferred format.
i had to reboot to get it to take effect.
Wednesday, 02 August 2006 20:45:07 (GMT Daylight Time, UTC+01:00)
Thursday, 25 September 2008 14:12:24 (GMT Daylight Time, UTC+01:00)
It's the same for the decimal sign and decimal separator... anyway, you can always create a new account with the right regional settings, and use this account to log the CMS and others process...
Tuesday, 14 October 2008 16:09:10 (GMT Daylight Time, UTC+01:00)
Brilliant - thank you so much for posting this. Been having the same problem and it has been driving me mad! Dates are now displaying correctly!
Tuesday, 31 March 2009 06:35:27 (GMT Daylight Time, UTC+01:00)
Could you please tell me in detail whats the solution for it as I am facing same problem with crystal report and when we change the regional setting, the format such as date is not reflected in the report.........:)
Tuesday, 31 March 2009 13:27:45 (GMT Daylight Time, UTC+01:00)
Hi puneet. I have explained it in the post, it sounds like you are not familiar with searching and updating the registry, if you google for this you will find tutorials. Then come back to this post and re-read the instructions with your new-found knowledge. Best of luck.
Monday, 08 June 2009 07:16:42 (GMT Daylight Time, UTC+01:00)
I have the exact same problem!
My system was built using US regional settings ie M/dd/yyyy (by the computer suppliers, instead of the Australian settings ie dd/MM/yyyy).
So, I went through set regional settings and parameters and changed to Australian. This still didn't solve the problem with Crystal reports displaying date in MM/dd/yyyy format.
I then did what was described in this post ie through regedit change MM/dd/yyyy to dd/MM/yyyy and also rebooted the system as described above, however problem still there.
There are no occurences of M(M)/d(d)/yy(yy) in the registry.
Thanking you in advance.
Monday, 08 June 2009 07:19:26 (GMT Daylight Time, UTC+01:00)
Forgot to mention, the only way I solved this on another occassion was by reinstalling Win XP Pro and selecting the correct regional settings ie Australia.
I don't want to reinstall everything from scratch. This is my last resort.
Furthermore, this application running is VB.NET, with IIS
Monday, 08 June 2009 19:58:07 (GMT Daylight Time, UTC+01:00)
Hi. Did you apply the regional changes in the registry to all users? Including the unnamed users/SID accounts?
Beyond that I don't believe there are any regional settings in windows. Make sure the crystal report itself is configured to display the correct values. Set your web.config culture appropriately also.
This is all I can suggest!
Monday, 13 July 2009 09:15:16 (GMT Daylight Time, UTC+01:00)
Thanks very much Tim, But still no success. I went through regedit, searched everything and changed to dd/MM/yy format (where applicable), and checked web.config for my application and in Crystal reports, the dates are configured to display in dd/MM/yy format.
I do appreciate your advice though.
This problem reared it's ugly head again after a manufacturer built a system for me and after I told him to select Australian format, he still put in US format ... urghh
Anyway, I will have to rebuild system myself, however, in the meanwhile, if I find something that solves this problem, I'll let you know.
Your website comes up first when I put in this query ... congrats!
Monday, 13 July 2009 12:48:11 (GMT Daylight Time, UTC+01:00)
Sounds like you've gone through it as thoroughly as possible, if I were in your shoes I would post to the business objects support forums, I've actually had positive support experiences there from the tech support. https://forums.sdn.sap.com/forum.jspa?forumID=313&start=0
The only other thing I would suggest is to inspect the registry settings by hand in the relevant sections, i.e. go to HKEY_USERS\XYZ\Control Panel\International for each and every user (you may have one Administrator account set up, but there could be 10 or so other 'built-in' accounts, any of which CR could be configured to run under so you should change all of them). And inspect them by hand just to make sure.
Best of luck
Monday, 23 August 2010 14:42:02 (GMT Daylight Time, UTC+01:00)
I have Crystal Report 8.5 and Oracle 10g Database installed at Windows 2003 Server. I have created a DSN. I created a report, but the numberic is coming wrong ie 1010 is displaying as 10.10. All numberic field seems to displayed as Number/100. When I query the DB, value is displaying perfect. My regional Setting is en-Australia.
I have tried various combination of format, but none is working. But when I connect the same DB with another PC (Windows XP) whose regional setting is same, the value is being displayed correctly.
I have written mail to business objects, but no reply even after 1 month. I can use the formula to display the write value, but there are 100 reports, so not possible.
When i used MS Access DB, no problem occurs.
Tuesday, 01 November 2011 09:34:00 (GMT Standard Time, UTC+00:00)
I've found a possible fix for this.
1. Set your regional settings in Control Panel to what they should be.
2. REGEDIT and browse to HKEY_Users > [Your ID] > Control Panel > International
3. Make a note of all the settings under here and copy them to HKEY_Users > .SYSTEM > Control Panel > International
4. Make a note of the LOCALE entry here, for UK it should be 00000809
5. Browse to HKEY_Users > [Your ID] > Software > Business Objects > Suite XX.X > Crystal Reports > Language Options
6. There should be two entries here. PreferredViewingLocale and ProductLocale. Paste the LOCALE code in here.
My machine did not require a reboot after this change.
Monday, 05 December 2011 07:33:19 (GMT Standard Time, UTC+00:00)
sometime my report shows incorrect date :(
Below is one case:
my regional settings is yy-mm-dd format and input string is 11-10-25
i used date function like date("11-10-25") but it give result as 25-10-11 which is mm-dd-yy fornat
i am doing date comparision and due to above problem, my application generate wrong date range of data
Please login with either your
above, or your details below.
Comment (Some html is allowed:
) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.
Enter the code shown (prevents robots):
Live Comment Preview
© Copyright 2017 Tim Mackey