Home Dashboard Directory Help

Multiple Parallel Independent DrillDowns in SSRS by prudhvi75



Sign in
to vote
Type: Suggestion
ID: 808347
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.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
parallel.xlsx 11/12/2013 26 KB
parallel.xlsx 11/12/2013 26 KB