November 8, 2011 at 4:45 pm
Hi,
I would like to change the display of date format on all my SSRS reports (SQL 2008 R2) from mm\dd\yyyy to dd\mmm\yyyy. I am looking for a server level setting not for each individual report.
Does anybody know what would do the trick?
Thank you kindly,
AK
November 8, 2011 at 4:59 pm
You could use the SSRS formatting functions, or you could more simply retrieve the data from the database already in that format.
Otherwise, you could try using the English (UK) report properties
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 9, 2011 at 10:17 am
Don't think it's possible server wide.
You could create a template file with the localisation language set to en-GB and use that for new reports. Won't help you with the existing ones though, sorry.
Some sort of mass update (powershell?) to the rdl definition files (xml)? With scripted upload to report server (rs.exe)?
Wouldn't fancy it myself!
Unless there's 1000's of reports I'd do it manually 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply