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"
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With