Pass a parameter value to a Dataset Parameter in SSRS 2008

xml reporting-services ssrs-2008 parameter-passing caml
Ishan picture Ishan · Nov 8, 2012 · Viewed 11.7k times · Source

I have a dataset with a parameter as which is passed to a query as shown below.

enter image description here

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

Answer

Aftab Ansari picture Aftab Ansari · Nov 8, 2012

You can try the dynamic expression under your parameter value. Something like following expression:

    =”<QueryOptions><CalendarDate> = “&Parameters!Date.Value.Tostring(“MM/dd/yyyy”) &”</CalendarDate></QueryOptions>”

Related questions

How do I comment out a block of tags in XML?

How do I comment out a block of tags in XML? I.e. How can I comment out <staticText> and everything inside it, in the code below? <detail> <band height="20"> <staticText> <…

Read More
Text editor to open big (giant, huge, large) text files

I mean 100+ MB big; such text files can push the envelope of editors. I need to look through a large XML file, but cannot if the editor is buggy. Any suggestions?

Read More
How do I parse XML in Python?

I have many rows in a database that contains XML and I'm trying to write a Python script to count instances of a particular node attribute. My tree looks like: <foo> <bar> <type foobar="1"/> &…

Read More