First: thanks to everyone for their help. I've greatly appreciated it.
Here's my question. Hopefully it's simple.
I created a report which displays the parents and children. The Descendant function does this quite well. When the report is executed the output displays as follows:
Parent
Child1
Child2
Child3
Child4
What I want is to invert that output so the children are listed first and then the parent.
Child1
Child2
Child3
Child4
Parent
The ORDER function only seems to apply to the children of a particular parent or even arranging the parents themselves. But I can't find an option to invert.
Any ideas/suggestions?
Is this ReportNet or Cognos 8? The question seems to imply you are using dimensional data, but ReportNet works only with Relational data.
Assuming this is Cognos 8, are you referring to a list or crosstab report? If it is a crosstab, could you drag in a query calculation using the Parent() function based on one of the the existing children in your set, and place this below the clildren in the rows area?
MF.
Cognos 8, Crosstab Report.
The solution you offered is exactly what I'm trying to avoid. Building reports from the bottom up is not an option for us because our lower levels are constantly changing. What I'm trying to do is build a report from the top down that will easily incorporate those changes without breaking.
The Descendant function performs the top-down results wonderfully except the sum is at the top, not the bottom.
Do you know a way this can be inverted?