SSRS reports International dates on reports

(0) Share

Report

Posted on by Community Member

Hi,

I have installed SSRS reports and deployed them, GP 2010 SP3, on SQL 2008 SP3.

The dates in the parameters are correct but the date displayed on the reports is in US format. How can I make them display in Australian (DD/MM/YYYY) format?

I have checked the Terminal Server and SQL Server Regional date settings and they are all Australian.

Thanks,

Geoff James

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Community Member on at

Like (0)

Report

RE: SSRS reports International dates on reports

Hi Joshua,

Thanks for the answer. I will investigate it, but it is every report that has been deployed.

Regards,

Geoff James

Was this reply helpful? Yes No
Verified answer

Josh P 2,895 on at

Like (0)

Report

RE: SSRS reports International dates on reports

Hi Geoff,

Load up Report Builder, highlight the date field you wish to have formatted. Right click and choose expression. You will wrap that date with a format expression.

Here is a screenshot of one of my French invoices used in SSRS with a date format that looks like:

"20 August 2013"

Here is a link to MSDN that will get you started on building expressions which are basically scripting inside your SSRS reports.

http://msdn.microsoft.com/en-us/library/ms157328(v=sql.105).aspx

Was this reply helpful? Yes No