June 20, 2008 at 9:27 am
Hi,
I need to pass a parameter from a folder on the report server into the reports under that folder. can someone help with that? Any advice would be appreciated.
Thanks,
melissa
June 23, 2008 at 1:24 am
To do this, just pass the name/value pair, separated by the ampersand.
For Example: http://server/reportserver?/dir/Report&rs:Command=Render&Parm1=VALUE1&Parm1=VALUE2&Parm1=VALUE3
As long as the parameter Parm1 is set to multi value, and it contains those three values (VALUE1, VALUE2, VALUE3) all three will be selected.
The only exception to this rule is if one of the name/value pairs is a null (Parm1:IsNull=True)
That causes SSRS to ignore the rest of the values passed.
Remember to pass the Value, and not the Label.
Sandip
June 23, 2008 at 3:50 pm
Great, sounds pretty easy. Thanks so much!!
Melissa
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply