Hello all,
I've been using RS for a couple of years now, but I've run aground on a
new challenge for which I cannot think of a proper solution.
I've got to build a report that has two requirements:
1) Sales by week, dynamically growing, horizontally.
2) My company's proprietary hierarchy, with drilldown, vertically.
Requirement One lends itself beautifully to a Matrix, and Requirement
Two lends itself beautifully to a Table.
Here is my question: is there a good solution for building a Matrix
that incorporates Requirement Two? I'm fully aware of row groups, but
how exactly can I get them to stack directly on top of one another?
Has anyone got an example? Chris Hays, I'm looking in your sleazy-hack
direction.
Thanks in advance,
Shawn