Language and Date Formatting

[bluecjh]

RS 2005.

Currently our report dates format by default in US format. i.e MM/DD/YY

To obtain UK formats we have to apply formatting formulae in text boxes etc...,
which is a bit cumbersome.

I am aware that I can set the XML in the body of the report to English. i.e. <Language>en-US</Language>
to
<Language>en-GB</Language> but is there a more generic server setting, or would the issue be in the local settings for BIDS. This seems to be a commonly blogged issue, but I can find no authoritative answer for this....

Many thanks for any help.

BlueCJH

 

[DaveInIowa]

Try setting your Report's Language property to the expression:

=User("Language")

 

[bluecjh]

Hi Dave,

where do i set the reports language property...

i can't find this? it's not a 2008 property? i'm using 2005.

thanks

BlueCJH

 

[DaveInIowa]

I see the RS 2005 in your original post now. Sorry, it must be a new feature in RS 2008 designer. Since you mentioned being able to set the XML I assumed this feature was available. What happens if you manually place the =User("Language") between the <Language> tags?

 

[bluecjh]

Okay.. i've been putting en

<Language>en-GB</Language>

i suppose that's really the same thing, but thanks
for this

BlueCJH

 

[DaveInIowa]

They're not the same thing. en-GB is hardcoding the language setting for anybody viewing the report. =User("Language") will adjust the report's date formats depending on the current user's Regional Options setting. To test this, go to Control Panel > Regional and Language Options > Regional Options tab and then select and apply a different language. When you go back into the report you should see the dates reformatted based on this new language setting. Note that you will need to use a format code (such as "g") as opposed to a format string for the date field's format value for this to be effective.

 

[bluecjh]

Dave,
I follow.... What I would like is really to change either
the server language or the BIDS language setting (which ever is the correct route) so that all developers have
the default setting to either User("language") or
en-GB.

I'm trying to get the default changed.

thanks



chris.

BlueCJH