subtotals; totals

["Stuy, H.C." <H.C.Stuy@BOSKALIS.NL>]

Hi,

I've made a workorder hierachy report which shows  a tree with "top"- and
"child" workorders. Each top got a couple of  childs, vary from 1 till a
±100.
An array is filled with totals of the "childs" and now i'm trying to print a
subtotal at the end of the last child, to totalise the particular top
workorder
Thats where I get stuck, when i print the subtotal, it prints on the the
same line as the next "top" workorder, instead of 1 line above this.

The output should look something like this:

10067.10001 Repair of Vessel
        |_ 10067.10020 Top General
                |_ child 1                      0,00    0,00    0,00
                |_ child 2                      0,00    0,00    0,00
                |_ etc                          0,00    0,00    0,00
                                        sum     0,00    0,00    0,00
        |_ 10067.10030 Top Engines
                |_ child 1                      0,00    0,00    0,00
                |_ child 2                      0,00    0,00    0,00
                |_ etc                          0,00    0,00    0,00
                                        sum     0,00    0,00    0,00
        |_ 10067.10040 Top Electrical
        |_ 10067.10050 Top Nautical


what happens now is:    |_ 10067.10030 Top Engines      sum     0,00    0,00
0,00 (sum of top general)

any help would gratefully be appreciated!

Rgds

Erik

I'm using SQR 4.1.1, with the PSDI Maximo application, on an ORACLE 8.0.2
dbase.