Groups | Blog | Home
all groups > sql server reporting services > july 2006 >

sql server reporting services : Date Parameter used in filter



Are friends electric?
7/18/2006 8:44:02 AM
Hi sorry if trolling through the other postings that I have not found a
solution to this and it is repetition.

I am trying to set a filter for my table that compares a date from my data
to a date parameter.

I have no problem getting the date parameter with the new funky date picker,
but when I select a date it returns in US format mm/dd/yyyy but my data is in
dd/mm/yyyy. This then causes the report to fall over "value for the report
parameter is not valid".

I would like to maintain the date in the format dd/mm/yyyy for the users
benefit (UK users) but would also like to keep the date picker.

When I pick a date that is the same month and date eg 10/10/2005 all works
fine.

BlackDuck
11/26/2006 6:40:01 PM
Hi,

did you get any resolution for this? I'm having the same issue

thanks

Matt

[quoted text, click to view]
Are friends electric?
11/27/2006 2:50:02 AM
Hi Matt

I did not find a solution on the report designer but when I deploy the
report and run it in explorer it works fine. I suppose this is a solution,
just a pain when trying to work on the design of the report.

Not that I am a fundi in any shape or form but if you need help on this I
can let you know how I set it up.

Steve

[quoted text, click to view]
BlackDuck
11/27/2006 10:04:02 PM
Yep, I found the same thing. It's a pain. It seems odd that the date picker
obeys your regional settings but the target textbox doesn't.



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