I'm trying to mimic this on a report:



The first thing I did was create one subreport with the three groups you see (yellow, gray, white). I set the format with multiple columns option and got the width and everything set how it should be. The problem is that I can't get each new group change (yellow) to start a new column. Second, I messed with all the keep together settings I could find, but couldn't get what I needed. Third, it almost looks like there is a page break after the last row but instead of paging vertically, it pages horizontally right next to it. Is this even possible?

In an ideal world, each column is created dynamically based on a field, similar to the top of a crosstab. However, I don't think that's the case here. Each column looks like a subreport based on the thicker lines in the middle between columns and the thin lines out the outside. If that's true, then how would I sort the subreports left to right by freq desc?

I've been working at solving this for so long and looked everywhere online but can't find anything. It's driving me nuts!

Thanks