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?.....