all groups > sql server reporting services > november 2006 >
You're in the

sql server reporting services

group:

Datepicker date invalid for type


Datepicker date invalid for type BlackDuck
11/26/2006 7:29:01 PM
sql server reporting services:
Hi,
I'm working on a report within the development environment. A couple of the
parameters are Date/Time parameters for which RS provides a Date Picker.

The Date Picker returns dates consistent with my regional settings i.e. in
dd/mm/yyyy format, however, once I've selected a date from the date picker
with a day greater than 12, the message "An error occurred during local
report processing. The value provided for the report parameter "From_Date"
is not valid for its type." Which one would assume is because somewhere
within .NET or RS its expecting dates in mm/dd/yyyy format.

I can certainly type in a date in either mm/dd/yyyy, mmm/dd/yyyy,
dd/mmm/yyyy or even yyyy/mm/dd or yyyy/mmm/dd but once I move out of the date
parameter, RS reformats the date in dd/mm/yyyy format.

Of course we can surive without a date picker, but its a nice feature and a
shame not to use it. I will persevere without it for now and hope that
someone has a resolution to this problem.

How do I get the datepicker and .NET/RS to agree on which format the dates
are in?

thanks

Re: Datepicker date invalid for type RBot
11/27/2006 3:26:07 AM
I have RS2005. I found installing SP1 fixed the problems I was having
with this.
The correct behaviour is for the datepicker to display the date in the
format according to the browser regional settings.
Prior to SP1 I had to make my date parameters Strings or pick them from
a database list.

[quoted text, click to view]
AddThis Social Bookmark Button