date format on SSRS 2008 R2 reports

  • 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

  • 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

  • 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