Passing multi-value parameter to sub report

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  March 29, 2010 at 8:06 am

  #219922

  Hey all,

  Been trying to find an answer online and not having much luck thus far. Basically I have a "dashboard" style report which allows the user to select multiple-values for a specific parameter. I then want that value to be passed to a support sub report by clicking a graph (via action). The problem is though, it's only passing the first value of the parameter: =Parameters!Step.Value(0)

  What can be done to support sending all values of the parameter to the sub report?

  Thanks

• danpintamo

  SSC Journeyman

  Points: 92

  More actions

  April 29, 2010 at 12:19 pm

  #1159968

  Use the JOIN function to combine all the values into a single string that you can pass.

  From Books Online...

  =Join(Parameters! <ParameterName> .Value,", ")

  An expression that concatenates all the values in the array of a multivalued parameter of type String into one string.

  =Split("Value1, Value2, Value3",",")

  Takes a string and creates an array of objects that can be used to pass to a subreport or drillthrough report expecting a multivalue parameter.

• Steven.Howes

  SSCertifiable

  Points: 6230

  More actions

  April 30, 2010 at 7:04 am

  #1160374

  I had this problem too. I believe if you make the subreport parameter multi-value then you can pass it. You'll have to remove the value(0) part. Just pass use =Parameters!Step.

  If it doesn't work reply and I'll try to find the report I did this in and double check how i did it. It's been awhile since I did it and I'm not quite awake yet.

• wq 92119

  SSC Rookie

  Points: 31

  More actions

  September 5, 2010 at 7:23 pm

  #1216736

  I have a sub report which has 5 graphs which should be filtered by the multi valued parameter passed by the main report. How can i do this. Thanks in advance.

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  October 18, 2016 at 2:03 pm

  #1907261

  Anyone was able to resolve this? I have a similar issue?

• Steven.Howes

  SSCertifiable

  Points: 6230

  More actions

  October 18, 2016 at 2:34 pm

  #1907268

  if the parameter is multi valued pass it to the subreport like this

  =JOIN(Parameters!Step.Value,",")

  i just noticed danpintamo said the same thing. Did passing the parameter like this work? the parameter in the sub report also has to be multi valued i believe.