How to dynamically write data horizontally across a group header

I have a hierarchically grouped report. The report is based upon a business structure (i.e., business unit, division, segment, hub, etc...). I wanted to show the status of deployment for a project at each object asset (grouped hierarchically). The status will need to be placed horizontally across the group header of each unique assetId. An ad-hoc approach would be to create a database view for each status and then link that to each asset object unique node. This approach doesn't support dynamic data.

The question - how do I pull data from a table / view and lay it out horizontally across a group header. This data should not go in the details section...

Best regards......