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 |
|
charles101
Starting Member
16 Posts |
 Posted - 2007-03-01 : 19:14:02
|
| Hi,Im creating a new report I have the following SQL Statementin a datasetSELECT [Outbound Samples].*, [Sample Results].*, [WP Sample Results].*FROM ([Sample Results] RIGHT JOIN [Outbound Samples] ON [Sample Results].[Sample Number] = [Outbound Samples].[Sample Number]) LEFT JOIN [WP Sample Results] ON [Sample Results].[Sample Number] = [WP Sample Results].[Sample Number]WHERE [Outbound Samples].[Scheduled Date] >= @startdate AND [Outbound Samples].[Scheduled Date] <= @enddate;I have the parameters startdate and enddate in my report off datatype - datetime - nonqueried In my SQL database the scheduled date is also datatype datetimeIm trying to get the above data in the SQL statement too display between the certain date ranges startdate and enddate i supply...simple report however Im getting the error The value provide for the report parameter 'Startdate' is not valid for its type when i view the reportIm not sure whats going on as the scheduled date is datetime and that what is using the parameter in the WHERE clause. Im missing something for SSRI to understand!Can someone please help? |
|
|
charles101
Starting Member
16 Posts |
Posted - 2007-03-01 : 20:19:41
|
| did a bit off reading and it is a bug in VS2005..i changed the date and time short date too mm/dd/yyyy and the report works....if anyone knows a different way please post it as im in Australia and we use dd/mm/yyyy. |
 |
|
|
|
|
|
Parameter not valid for its type