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
Hi Joshua,
Thanks for the answer. I will investigate it, but it is every report that has been deployed.
Regards,
Geoff James
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (