How to Pass multiple parameter for drill through report

• Pvm_25

  Ten Centuries

  Points: 1073

  More actions

  October 23, 2009 at 7:56 am

  #205909

  I am having a problem with passing the parameters for drill through report in MATRIX.

  I have three row groups - store type, year and locations and one column group category sales (it has three categories).

  There are many locations per year (more than 50), so i have set visibility for locations toggled on year so report doesn't look messy.

  Now when i click on any value field from any category then it is going to another report "Sales

  Details" and i am passing store type, year and location as a parameter. Location is a multivalue parameter in drill through report.

  So my problem is i want to pass all locations for particular year for particular store type when location group is 'NOT-expanded' and when it is expanded then it will pass individual location. Drill through report is working properly when locations are expanded.

  So can any one please suggest me how to dynamically pass multiple field values through parameter?.....

• merlinjnr

  Newbie

  Points: 3

  More actions

  November 23, 2009 at 7:42 am

  #1082936

  This thread may be of help...

  http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/0bde66d7-b0e4-40da-9a0c-838663e66119