Passing multiple values from one SSRS report to another

• bicky1980

  SSCrazy

  Points: 2079

  More actions

  October 19, 2015 at 4:04 am

  #305528

  Hello Guys

  Can you help? I have a report which calls another report passing a parameter as an in command. This works fine when passing one value however when I pass more than 1 value the report does not work.

  The actual line of the report is:

  b.dept in (@team)

  I want to pass Team 1, Team 2, Team 3

  Please advise on the easiest and best method to do this.

  Thanks in advance

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  October 19, 2015 at 4:22 am

  #1834016

  Going to need to split the string based on a delimiter.

  Take a look in my signature for the string splitter function, will just need to add that to your query and join the result set into your queries