data format on SSRS

  • 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

  • Why don't you convert the date in the SQL/MDX query and bring the formatted date to report?

    Raunak J

  • What locale does your server use? (SQL Server as well as the physical server itself)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • can't you use/force the 'language' setting on the report properties ?

    :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply