Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Change Visual Studio "Current regional settings" value

I'm designing some SSRS reports in Visual Studio and every datetime field is displaying as MM/dd/yyy instead of my preference of dd/MM/yyyy

My Windows regional settings are English(Ireland) but if I look at any datetmie placeholder propery window it shows "Current regional settings: English (United States)". I don't know where it's picking this up from (pretty certain it's not the SQL login defined in the dataset either) or how to change it. Any ideas?

(I could forcibly change the output of every datetime field to my preferred format would would like to not have to do this every time and instead just get the environment into the right regional setting)

Update: Forgot to add, I can see a Language tag in the RDL which is set to "en-US" and whenever I try to change that to anything else and save it automatically changes back to "en-US"

like image 849
KrustyGString Avatar asked Jan 14 '13 16:01

KrustyGString


1 Answers

Each report has its own regional settings.

Click on a part of your reporting design surface that has no objects and look at the Properties window for the report. Under Localization there is a setting called Language which defaults to English (United States) or en-US. You could set this to your own regional settings but I like to set it to =User!Language so that it displays in the regional settings preferences of the user.

like image 197
Chris Latta Avatar answered Sep 30 '22 03:09

Chris Latta