Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSRS Question -- Multi-group rollups -- recursive heirarchy

Status
Not open for further replies.

hwkranger

MIS
Nov 6, 2002
717
US
Anyone know how to do multi-group roll-ups?

Example:

Events Happen daily.
Events Happen During Morning, Noon, Night
People Do the events
People Report to people.

I have a drill down that shows: People reporting to people, the bottom person's events grouped and drilled to the day.

I want to have a sum of the events throughout the hierarchy.

Example data would look like:

Bob
Did Something - 150 Times
Did Something Else 300 Times

Carol (who reports to bob)
Did something 75 times
Did something else 200 times

John (who also reports to bob)
Did something 75 times
Did smeothing else 100 times

Bob gets Carol and John's sums.

underlying data looks something like:

Bob (all nulls)
Carol (Listing of data) (parent Id of bob)
John (listing of data) (parent Id of bob)

I'm able to get counts recursively, at each level, but not sub grouped (events)

Any help is appreciated

Cheers
 
You might get more responses to your question in this forum:

forum1462

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top