Dateformat

[TomLefever]

Hi,

I made several reports in .NET (to use in my ASP.NET application). In a few reports I am using long dateformats (to print for instance the birth date,...). All of my reports were developped in a dutch environment. The production environment is english, so in my reports, dates are now printed in english while I want them in dutch.

Is there a possibility to change this, in general on the server (reports are always made on serverside)? Or have I no other solution than check for each month and manually built my long formatted date,

so:

select case month(date) 
      case 1 
       formula = "Januari" (dutch month-name)
      ...

Thanks!

Tom Lefever

 

[Mike Lewis]

Tom,

Have you tried selecting 'Windows date format' as a custom date format? This will cause the dates to be printed in whatever format and language the user has established in Windows. (Or maybe that's not what you want?)

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[TomLefever]

Mike,

Yes, I already did this. When I choose "custom", I selected the option DMY, but the monthnames are still in english. I changed the regional settings in Control Panel, but even this seems not to work (even after a reboot) :-(

Tom Lefever

 

[TomLefever]

Is there anyone having a solution to my problem (see beyond)?

Thanks!!

Tom

 

[Mike Lewis]

Tom,

. I changed the regional settings in Control Panel, but even this seems not to work

This surprises me.

I just went into Control Panel / Regional Settings, and changed my country (on the first page of the setting sheet) from English/UK to French Canadian. I have a date of Thursday 21st March 2002 in my report. With the date format set to Windows, that date now appears as jeudi 21 mars 2002. When I set the regional settings to Spanish, it is jueves 21 de marzo de 2002.

This is in Windows 98. I didn't need to reboot.

Pehaps someone else can confirm this behaviour, or otherwise. I don't know if there is anything unusual in my system. I'll check it under Windows 2000 when I get a moment.

Mike



Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[TomLefever]

Hi,

I read the following on Crystal Reports site:
The date and time fields use the default U.S. English locale because the Web Form viewer and report engine (crpe32.dll) are run under the aspnet_wp.exe process (which, by defaults starts under the System account).

The System account, by default, uses the locale settings that were set as default when the operating system was installed. When regional settings are changed, the settings only apply to the currently logged on user and not the System account.


How can I change the regional Settings of my aspnet_wp.exe process (system account)?

Thanks

 

[Mike Lewis]

Tom,

How can I change the regional Settings of my aspnet_wp.exe process (system account)?

Sorry. Don't know. This is not really a Crystal issue, but no doubt someone else will know the answer.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk