Multiple Parallel Independent DrillDowns in SSRS - by prudhvi75

Status : 


Sign in
to vote
ID 808347 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 11/12/2013 6:44:28 AM
Access Restriction Public


Morning People,
I have so many reports waiting to be created  based on this layout(I guess other's too).Here is the requirement .

Fiscal Year                   Group                  Category                            Details
+ All Level              + All Level                   + All Level                     100,245,854

As per  my requirement, in here I want to expand Category without Expanding the remaining two hierarchies first, But with SSRS, I am not able to expand Category without expanding the remaining 2 hierarchies(Fiscal Year, Group)
The design of the report consists of three hierarchies. The requirement is to keep both the Fiscal Year and Group hierarchies at the "All" level of the hierarchy, while being able to drill to the child levels of the Category hierarchy or ViceVersa.  Reporting Services will only expand on the Category hierarchy if I have both the Fiscal Year and Group hierarchies expanded.
Likewise, if I want to drill to the child level of the Group hierarchy, Reporting services will not show that level unless I expand the Fiscal Year hierarchy. If can be able to attach files to this, I will attach my requirement that I acheived in EXCEL with adventure works database. I hope the issue is understood. Can you assist?
Sign in to post a comment.