Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
roy mm
Yak Posting Veteran
62 Posts |
 Posted - 2007-02-15 : 03:34:12
|
| Hello.I've just created a new report and I added a prameter of type "DateTime".I didn't even used it in the query.Whan I preview the report I have the small calendar Icon.after I pick a time from the picker And press "View Report"I get the error:"the value provided for the report parameter P1 is not valid for its type"I'm using RS 2005.Any body know whats the problem?Thanks in advance,Roy. |
|
|
jhermiz
3564 Posts |
Posted - 2007-02-15 : 13:50:29
|
quote:
Originally posted by roy mm
Hello.I've just created a new report and I added a prameter of type "DateTime".I didn't even used it in the query.Whan I preview the report I have the small calendar Icon.after I pick a time from the picker And press "View Report"I get the error:"the value provided for the report parameter P1 is not valid for its type"I'm using RS 2005.Any body know whats the problem?Thanks in advance,Roy.
Check the report parameters, make sure P1 matches the datatype as P1 in your stored procedure, is it date/datetime ?Also right click the report and goto view code. You'll see the XML view. Go to your dataset and make sure the parameters are correct in your dataset that calls your sproc.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
roy mm
Yak Posting Veteran
62 Posts |
Posted - 2007-02-18 : 01:01:10
|
| Hi,I think I know whats the problem.Whan I run it an my local Pc its take the date in a diffrent format.Whan I choose 1 in february i get in the box 2/1/2007.instead of 1/2/2007 since I'm with hebrew settings.So the problem is that if I choose 13 in february I get it as 2/13/2007 whice give the error since there is no 13 month!Any way, when I deploy it to the server It was Ok from some reason.Thank for the replay,Roy. |
|
|
|
|
|
|
problem with dateTime picker