Localization on Reports in Reporting Services

I came across a report in reporting services that had a lot of dates in the data.
When the report eventually ended up un the report server I had a most annoying problem.
My dates was displayed in the wrong format.
I needed them to show up in danish and they showed up in english.
After a heavy doze of trial and error I finally got it.
On every report there is a property called language.
A lot of peers told me that this setting did not matter if it was not set in the first place.
Guys - it does matter.

If you want your report to show up in an different locale then set the language to the appropriate countrys locale.
If you want to support multiple languages, then set an expression on the language instead where you set the value to user.language
After this it is the language settings in Internet Explorer that decides the locale settings in the report.

Best regards
Michael Torpegart

Month List