SSRS - Go To Report Action on Text Box Properties

• tahopewell

  SSC Veteran

  Points: 229

  More actions

  May 10, 2012 at 1:26 am

  #261267

  I need to know how to pass through 2 hard coded values in one parameter value. Basically, I have 7 values available (1,2,3,4,5,6,9) and when i click on a certain field on the report, I want it to drillthrough to another report with 2 of these values (1,3) selected. I cannot get this to work. I have 'Multiple Values' selected in the drillthrough report and I have tried using both the 'And' and the 'Or' operators. When I use the 'And' operator, the first of the 2 values is selected and when I use the 'Or' operator, only the second value is selected. Any ideas?

• christina-518819

  SSC Enthusiast

  Points: 121

  More actions

  May 29, 2012 at 8:17 am

  #1494194

  Have you tried using IN in the drillthrough report and passing them through using the Join command?

  Syntax is =Join(Parameters!<yourParameterName>.Value, ",").