Hello,

I am having real problems with reporting services 2005.

I've already stopped using the report designer and report model as I found numerous bugs and limitations.

I have returned to simply using stored procedures to provide the information for each of my reports.

However I have now encountered another issue regarding date formats.

In my report i am trying to select data between to dates however reporting services 2005 only seems to want to see my date in American format  (MM/DD/YYYY) not uk (DD/MM/YYYY).

I have already set the report language to English (United Kingdom) but this seems to make no difference. Also my local machine and database are set for the UK.

An example of my problem is:

Initially as my report auto renders for the first time the data is between 01/02/2006 and 07/02/2006  (1st Feb 2006 to 7th Feb 2006)

If I click on the datetime pickers at this point they correctly display the dates as being in February.

However if I click on the view report button.

The date time pickers seems to interperate this as american date format and my dates magically become  02/01/2006 and 02/07/2006  (2nd Jan 2006 to 2nd July 2006).

This leads to other errors as if I choose 13/07/2006 (13th of July to us Brits) reporting services breaks and returns the error:

An error occurred during local report processing.

The value provided for the report parameter X is not valid for its type.

Obviously it is trying to use 13/07/2006 in america date format.

So to cut a long post short.

How on earth do I make my reporting services reports stay in UK date format?

PLEASE HELP!

Thanks

Mark

Hi Mark,

 I have this same (or very similar) problem - when I deploy my entirely british report (set in parameters, set on the db, set on the server), the report parameter date time picker that is shown to the user is in american format. My client has complained about it but there doesn't seem to be anything i can do with it - if i format it then it is a string type and therefore errors, but if i just leave it CDate'd then it comes out in american format. It doesnt seem like there is an choice in this!

 Did you, or anyone else, find a solution to this?

Kind Regards,

Dominic

 Hi Dominic,

I also have the same problem,

and recently i gone through the following link

http://www.ssw.com.au/Ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx

in this they mentioned that this is because of the following issue.

     - The Parameter Bar in the Reporting Service 2005 is always decided by the Language settings of client browser regardless of the Language property of your report.

 
After adding "English United Kingdom" the Language Setting of the Client Browser, it is displaying date format in UK Format.

Regards,

Santosh
 

Ah that's great, thank you very much - that explains why it works on some computers and not others.

 Thanks for taking the time to reply :)

Dom

You have to format the date before sending it to the stored procedure. See the following article :

Hi

Change the Culture in Report.aspx to

<%@ Page language="c#" Codebehind="Report.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.ReportWrapperPage" EnableEventValidation="false"  Culture="en-GB"%>

Regards

N.Madhusudhana Reddy

We change Change the Date format of Reprting Services to any format, change the culture in the IIS to "en-GB" to get the date in "dd/mm/yy".

   IIS-->Properties-->AsP.NET(taB)-->Application(Tab)-->Globalettings(Culture)

Regards

N. Madhusudhana Reddy