parameter Issue

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  July 10, 2014 at 11:18 am

  #290875

  I have a main report with two parameters : Location and Department.

  Both of these are multi value parameter (Show multiple values to chose from)

  Main report shows the count for each department /location.

  and works perfectly fine

  The problem arises when I click on the counts to display the subreport

  Now if I have location as NY and Dept as HR and click on count - say 5 in the subreport I can see details of the 5 people

  But when I select NY and add another Dept say Finance now if I click on count - say 10 . The subreport treats it as two parameter for department and joins them and gives the results- 15.

  Here are the settings

  Main Report

  Actions

  Location =Split(Join(Parameters!Location.Value,”,”),”,”)

  Department = Split(Join(Parameters!Department .Value,”,”),”,”)

  Subreport

  parameter in Dataset :

  Location =Split(Join(Parameters!Location.Value,”,”),”,”)

  Department = Split(Join(Parameters!Department .Value,”,”),”,”)

  p.S : Both main report and subreport queries have "In" in them. If I only do = then it somehow only brings in the 1st value no matter how many different depts I click on.

  I understand why its doing so, but don't know how to get rid of this behavior. Help!