CODEWITHSUNDEEP
reporting-servicesdate-formattingreportbuilder3.0
user3060571
user3060571

Reputation: 131

Report Builder 3 Date format

In Report Builder 3 the dates on reports are coming through in the format MM-DD-YYYY however in the data set (source) they are in DD-MM-YYYY format (and the query designer shows them as DD-MM-YY).

I know how we can change them on the report by formatting each column and I can also set the localisation to be en-GB but is there anyway to do this by default?

i.e to make all the dates come out in DD-MM-YYYY format for all reports so users don't have to change the localisation settings for every new report.

After reading up on this it seems that they can take the settings from the client machine however my PC location is set as UK so it doesn't seem to be picking them up.

Also the Report Server is set up as UK location.

Any help you can provide would be greatly appreciated.

Thanks,

Nic

Upvotes: 0

Views: 1117

Answers (2)

user3060571
user3060571

Reputation: 131

It turned out to actually be an issue with the language pack installed in IE on the Report Server.

Everything was set to a UK locale however the language option in IE wanted to download the UK language pack.

By installing it and then selecting the UK language pack in IE for the SSRS service account this resolved the issue.

Thanks for your assistance,

Nic

Upvotes: 1

rcarvalhoxavier
rcarvalhoxavier

Reputation: 329

I don't know if i understand totally right, but you can use an specific user to connect on data-source, an user only for reports. This user you can specify a "region" en-GB

enter image description here

Upvotes: 0

Related Questions