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?