Change Regional Settings for your Report

: Joel Lipman; SQL Server Reporting Services; 17 May 2010; Hits: 25644

Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a quick note on how to set Dates and Times used in parameter fields to UK format (dd/MM/yyyy).

You can override this in the report by:

Go to Design
Select the View tab
Check that the "Properties" pane is displayed/ticked
Change Language under Report Properties > Localization to en-GB
Save the report and test.

Credit where Credit is Due:

Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com

SSRS / MDX Date Queries (9080) Joel Lipman (SQL Server Reporting Services)
So I find myself using date ranges endlessly as I've been working in SSRS. The below is derived from a collection of...
SSRS Templates in BIDS 2008 (8796) Joel Lipman (SQL Server Reporting Services)
Open a Windows Explorer and make a duplicate of the report that you want to use as a template. Rename the copy (suffix with...
Border settings not saving in SSRS (26197) Joel Lipman (SQL Server Reporting Services)
This may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My...
SSRS Change Background Color of Image (14111) Joel Lipman (SQL Server Reporting Services)
What? Sounds easy but actually if you use an image which has transparent areas, ie. has one color which will be...
SSRS Expand specific drilldown by default (11126) Joel Lipman (SQL Server Reporting Services)
I thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied &...
Before and After, Highs and Lows (8732) Joel Lipman (SQL Server Reporting Services)
So I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP &...
How to Display Report Execution Time in SSRS (milliseconds) (37534) Joel Lipman (SQL Server Reporting Services)
How to Display Report Execution Time in SQL Server Reporting Services 2008 R2 So there are other articles out there...