CODEWITHSUNDEEP
sql-serverssrs-2008
Mark 909
Mark 909

Reputation: 1835

Date Format incorrect in Reporting Services

I have a Date Time field in a report with format set to 31/01/2000 13:30. It says on the dialog that Formats that begin with an asterisk () will reflect the regional settings of the report.

It also confirms below that my current regional settings are: English (UK)

I then deploy to my local report server and run the report and it displays in American Date format e.g. 01/31/2009.

The local report server is set to run under my own local account which is set to UK format regional settinsg.

Where is it picking up these American settings from?

Upvotes: 3

Views: 7795

Answers (1)

adrianm
adrianm

Reputation: 14726

In BIDS or ReportBuilder NOT in the SSRS website, select "Report" in the properties window and set the language:

enter image description here

Upvotes: 9

Related Questions