I need some help on producing this report -

The data:

Users Clients Run ID Solutions Update Solutions
Brenda Walmart 1234 aaaa System Generated
Brenda Walmart 1234 bbbb System Generated
Brenda Walmart 1234 cccc Reject
Brenda Walmart 4567 aaaa Accept
Brenda Walmart 4567 eeee Deferred
Brenda Target 7890 ffff System Generated
Brenda Target 7890 gggg System Generated
John ShopKo 8901 cccc System Generated
John ShopKo 8901 ffff System Generated
John ShopKo 9012 dddd System Generated
Eric Giant 1012 aaaa Reject
Eric Giant 1023 mmmm Accept
Eric Subway 1458 nnnn System Generated
Eric Cisco 6548 eeee System Generated

The report:

Users Clients Clients Update Total Runs Runs Update
Solutions Solutions Update
Brenda 2 1 3 2
7 3
John 1 0 2 0 3 0
Eric 3 1 4 2 4 2

Brenda:
There are two clients: Walmart and Target
There are three runs: 2-Walmart (1234 and 4567) and 1-Target (7890)
There are seven runs: 3-Walmart (1234), 2-Walmart(4567) and 2-Target
(7890)

Updates: Any updates beside System Generated status consider as update
been done.

Brenda:
Out of Seven solutions: There are 3 updates done
3 Update solutions are from 2 runs out of 3 total runs
2 runs which solutions are updates are both from 1 clients out of 2.

So over all result is Brenda has two clients in which only one is
updated. She requests three runs in those two clients in which only
two are updated. Those three runs have seven solutions in which only
three are updated.

Please help me how to generate this report. I am running out of
ideas.

Thank you,
Saz