asked on

Wrong @ExecutionTime format in SSRS 2012

We have just installed SQL Server Reporting Services Service 2012(RTM) on SharePoint Server 2010 SP1 according to these instructions http://msdn.microsoft.com/en-us/library/hh231687(SQL.110).aspx SSRS services are running as a SharePoint service and it works like a charm except;

The problem is SSRS shows the @ExecutionTime and date format as MM/DD/YYYY although it should be DD/MM/YYYY

I have tried some troubleshooting steps;
1) Set regional settings of the Windows Server 2008 R2(SharePoint) to DD/MM/YYYY format.
2) Set the default language of the report to en-GB language.

Unfortunately they didn't work!

Is there any way to change reporting services to DD/MM/YYYY format?

Cheers

ValentinoV

The default value for the Language property in the SSRS reports is "en-US". That's why the dates are shown in US format. To change this, you need to modify that property to your preferences. In my case that could be "nl-BE" (stands for Dutch-Belgium), then I get DD/MM/YYYY.

But apparently you tried that already (sorry, was a bit too fast).

ASKER CERTIFIED SOLUTION

ValentinoV

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dsmgrp

ASKER

Thanks ValentinoV, I' ve tried to change the regional settings on user settings and site settings but it's the same...

In second step I set the default language of reports to 'en-GB'

ValentinoV

What do you mean with "default language of reports"? Are you referring to the Language property in the report itself, or something differently?

dsmgrp

ASKER

I'm referring to localization field on the report builder. I' ve attached a screenshot.
reportbuilder.png

dsmgrp

ASKER

I have also changed the SQL Server regional settings which holds the report server databases.

dsmgrp

ASKER

Hi ValentinoV,

sorry I've missed the site settings point, just created a new site which is default language is my local language, after that it works! Cheers