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 |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2008-08-13 : 21:06:32
|
| Hi Guys,I am having a stored proc with date parameter and datetime datatype.........something like this...Exec sp_report_temp @EndDateNow whenever I execute the above stored proc, I want in the 'preview' tab to be shown with a small calender button so that i can select whatever date i want from that calender. For this purpose, in the report parameters, I am using Datetime datatype instead of string datatype for EndDate.But for some reason, I am not able to get exactly what I want.....like....when i click the calender button and select 4th of Jan (4/01/2008), its showing the values for 1st of April (01/4/2008) and when i click and select 30th of Dec (12/30/2007), its showing the following error : "An error occured during local report processing.The value provided for the report parameter 'EndDate' is not valid for its type."Does anyone have a clue how to resolve this issue???Any help is really appreciated...Thanks.Raaj |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-14 : 15:15:21
|
| Its seems like either report language property or language property of your system is set to English US. Change it your English (UK) which will interpret date in dmy format. |
 |
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-08-14 : 21:21:08
|
| Hi Visakh,Thanks for your reply.I have checked both the report language property and the languaue property of my system. Both are set to English (Australia) only.i.e.dd/mm/yyyy format onlyAny other clues??? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-15 : 01:30:58
|
| Is this happening only in preview tab or also in server. i've heard of a know issue which causes this problem occuring only in preview tab but will work fine after deploying to server. |
|
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-08-18 : 22:00:41
|
| Hi Visakh,Thanks for u r reply....After seeing your reply post, I have deployed and checked it and its working fine.........I dont know the exact reason....but when I am viewing in the preview tab....its not working fine....when I am deploying it to the server...its working fine with correct results.....Thanks.....Raaj |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-19 : 02:06:41
|
quote:
Originally posted by raaj
Hi Visakh,Thanks for u r reply....After seeing your reply post, I have deployed and checked it and its working fine.........I dont know the exact reason....but when I am viewing in the preview tab....its not working fine....when I am deploying it to the server...its working fine with correct results.....Thanks.....Raaj
thats a known issue. we're told here to refrain from using datepicker control in preview tab as its has this problem. |
|
|
|
|
|
|
|
|
Help needed in resolving datetime datatype issue..