Pass a parameter value to a Dataset Parameter in SSRS 2008

• halarnkar.ishan

  Valued Member

  Points: 59

  More actions

  November 8, 2012 at 2:19 am

  #284540

  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

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  November 9, 2012 at 12:54 pm

  #1557782

  I believe your parameter expression is invalid.

  You should try.

  ="<XML><CalendarDate> " + = FormatDatetime(Parameters!Date.Value.ShortDate).ToString()+ "</CalendarDate> </XML>"