all groups > sql server reporting services > november 2005 >
You're in the

sql server reporting services

group:

Passing values to multivalued parameter - RS 2005 with AS



Passing values to multivalued parameter - RS 2005 with AS PeterG
11/30/2005 2:48:02 PM
sql server reporting services: I need to navigate to a drilldown report with multivalued parameters. I need
to deal with:
a) Passing a single value from "parent report" to a "child report"
multivalued parameter (mvpar):
I tried e.g. Fields!Division.Value and Fields!Division.Uniquename to no avail.

b) Passing multiple values from "parent report" mvpar to "child report" mvpar:
In this case, I get a partial result - when I pass mvpar to mvpar I get one
value checked - single value checked to single value checked or, if the
parent has more than one value checked, the first checked value.

Any suggestions are appreciated,
PeterG
RE: Passing values to multivalued parameter - RS 2005 with AS PeterG
12/28/2005 2:27:05 PM
I have since found useful posts about the use of Join and Split functions to
transform a comma delimited string into an object array and vice versa. For
OLAP, here are examples for a single value and a multivalued param:

Split(Fields!OrgUnitL2.UniqueName,",") for a single value
Split(Join(Paramaters!Roles.Value)) to pass through a multivalued parameter

[quoted text, click to view]
AddThis Social Bookmark Button