?
Solved

Wrong @ExecutionTime format in SSRS 2012

Posted on 2012-03-16
7
Medium Priority
?
1,707 Views
Last Modified: 2012-06-21
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
0
Comment
Question by:dsmgrp
  • 4
  • 3
7 Comments
 
LVL 37

Expert Comment

by:ValentinoV
ID: 37729769
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).
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 1500 total points
ID: 37729855
There are a couple of other places that I can think of:
  o the site settings
  o the user settings (on Sharepoint)

BTW: what exactly did you modify for your point 2?
0
 

Author Comment

by:dsmgrp
ID: 37730999
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'
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 37

Expert Comment

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

Author Comment

by:dsmgrp
ID: 37731106
I'm referring to localization field on the report builder. I' ve attached a screenshot.
reportbuilder.png
0
 

Author Comment

by:dsmgrp
ID: 37731399
I have also changed the SQL Server regional settings which holds the report server databases.
0
 

Author Comment

by:dsmgrp
ID: 37798504
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
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
Suggested Courses
Course of the Month6 days, 16 hours left to enroll

594 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question