I have a recursive hierarchy showing managers and employee salary by department. The problem I have is that the manager can have a salary, but also have child employees reporting to them. How it's coming out in SSRS is like this:
Employee Salary
Manager 1 $350,000
Employee 1 $50,000
Employee 2 $50,000
Manager 2 $150,000
Employee 3 $50,000
Where the manager is eaing $100,000. So, basically SSRS is rolling up to the manager level, which I want, but it's not breaking out the manager to be a separate row as well, so the report is confusing.
Thanks so much!
Mike.