Kyle Abrahams, PMP
asked on
SSRS Multi Select Parameter Drill Through
Hi All,
I'm using SSRS 2008 and come across an issue:
Assume I have this mapping:
GROUP Members
A 1, 2, 3
B 3, 4, 5
Users in the main report can filter by group, or members. (Dataset for members is select distinct members from <table> where dbGroup in (select value dbo.fnSplit( @group)) . . . this way if Someone selects A they can only choose 1,2,3, but if A,B are both there they get 1,2,3,4,5).
Now lets say I want to drill through to B . . . so I'm passing B as the parameter, as well as them members of the main report (eg: 1,2,3,4,5).
in my Child Report, the only members available are 3,4,5 and SSRS doesn't select anything causing data not to show. Users have to click the check all box and then view report.
Is there a better way of doing this?
I'm using SSRS 2008 and come across an issue:
Assume I have this mapping:
GROUP Members
A 1, 2, 3
B 3, 4, 5
Users in the main report can filter by group, or members. (Dataset for members is select distinct members from <table> where dbGroup in (select value dbo.fnSplit( @group)) . . . this way if Someone selects A they can only choose 1,2,3, but if A,B are both there they get 1,2,3,4,5).
Now lets say I want to drill through to B . . . so I'm passing B as the parameter, as well as them members of the main report (eg: 1,2,3,4,5).
in my Child Report, the only members available are 3,4,5 and SSRS doesn't select anything causing data not to show. Users have to click the check all box and then view report.
Is there a better way of doing this?
ASKER
Hi Tim,
Because I need to replicate the data.
If they run it for the 3rd member only and they want to see the details of that grouped by the respective group, they don't want to see all of the members in the drill down.
Because I need to replicate the data.
If they run it for the 3rd member only and they want to see the details of that grouped by the respective group, they don't want to see all of the members in the drill down.
What do you have your default set to for the members paramter in the second report?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Found answer via a colleague at work.
Tim