asked on

SQL Reporting Services - UK Date Format and Parameters

I have a report that I've developed that accepts several datetime parameters.
In the Report properties, I've set the report Language to English (United
Kingdom).

I am calling my report via the Web Service from an ASP.Net application. The
ASP.Net application Culture and UICulture are set for en-GB.

What is happening is that when a date is passed to one of the report
parameters (gEndDate) as "14/12/2004" (December 14), I get the following
error:

The value provided for the report parameter 'gEndDate' is not valid for its
type

If it helps any, my Visual Studio .Net environment where I am developing the report and Asp.Net application are on my laptop in the en_US language setting. The test machine where I am having the error is en-GB.

ASKER CERTIFIED SOLUTION

simon_kirk

membership

This solution is only available to members.

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

Start Free Trial

ABaruh

ASKER

I did something similar to what you suggested.

In the dataset, under the Parameters tab, rather than make my data fieldd = parameter, I change it to

=Parameters!gEndDate.Value

And I made this parameter data type String

ABaruh

ASKER

Woops, I meant to say:

In the dataset, under the Parameters tab, rather than make my data field = parameter, I change it to

=FormatDateTime(Parameters!gEndDate.Value, vbShortDate) & " " & FormatDateTime(Parameters!gEndDate.Value, vbShortTime)

And I made this parameter data type String