SQLTeam.com | Weblogs | Forums

Dynamic Grouping in SSRS

Hi all,

Just wondering if anyone can help with the query below please? I am working on a report, and would like grouping to be dynamic rather than fixed fields. Here is what my reports looks like at the moment:

There are five levels of org structure in hierarchy, and we take manager as a parameter. So what i want is if a manager logs in who let say at level 3, he/she could only see columns from level 3, and grouping is also based from level 3.

There could also be scenarios where manager can only see level 2, 3 (all derived from data). In that case grouping based on level 2, 3, and could only see column 2, and 3.

Is that possible, and how can we achieve that? Any help would be highly appreciated.

Thanks