Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1740
  • Last Modified:

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
0
dsmgrp
Asked:
dsmgrp
  • 4
  • 3
1 Solution
 
ValentinoVBI ConsultantCommented:
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
 
ValentinoVBI ConsultantCommented:
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
 
dsmgrpAuthor Commented:
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
ValentinoVBI ConsultantCommented:
What do you mean with "default language of reports"?  Are you referring to the Language property in the report itself, or something differently?
0
 
dsmgrpAuthor Commented:
I'm referring to localization field on the report builder. I' ve attached a screenshot.
reportbuilder.png
0
 
dsmgrpAuthor Commented:
I have also changed the SQL Server regional settings which holds the report server databases.
0
 
dsmgrpAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now