UK Datetime Parameter Problem SQL 2005 RS

Hi,

I am having a problem with the DateTime parameter option in SQL 2005 reporting services.

Note that Server, workstation and database are set to British/English (UK) date/time localisation (dd/MM/yyyy) for example 25th December 2005=25/12/2005.

I create a simple query with a parameter on a datetime column and set the report parameter to Data type: DateTime in the report parameters dialog.

On preview or after deployment the following behaviour is observed.

Selecting 1st February 2006 in the datetime picker control populates the date parameter entry field with

01/02/2006 = 1st February 2006 (the correct UK format as expected)


When View Report is clicked the datetime parameter field magically changes to

02/01/2006

So forcing the datetime values to US format MM/dd/yyyy, the report runs OK but does not return data restricted to the required date.

If we select 25th February 2006 the datetime parameter field populates with

25/02/2006 = 25th February 2006 (the correct UK format as expected)


When View Report is clicked the datetime parameter changes to 02/01/2006 and an error is displayed

An error occurred during local report processing.

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

Is there a solution to this?

Thanks,

Neil