I have a dataset with a parameter as which is passed to a query as shown below.
The issue here is DataSet parameter queryOptions
does not accept the value from the Report Parameter Date
If i hardcode any value e.g <CalendarDate> 08/11/2012 </CalendarDate>
instead of <CalendarDate> = Parameters!Date.Value </CalendarDate>
the report works fine.
What wrong am i doing while passing parameter.
I even created another Dataset Parameter named Date
and assigned Parameter Value [@Date]
even that did not work.Note
: Parameter Date is of type DateTime