I have a query that has a hierarchy in the rows and runs perfectly in BEX. One is able to expand and work using the Hierarchy.
When i bring the query into Report Designer i get a warning that RD does not support the Hierarchy. The report builds and does display with the Hierarchy content but not in the form of a Hierarchy, just a list of fields.
I have read elsewhere in the forums that Hierarchies can be supported in RD but i can not find out how to do this.
We are running RD ver. 7, Support Package - 15 and Patch - 2.
Any help would be greatly appreciated.
Regards
Stephen