Hi to everyone,

I tried using MULTIPLE DETAIL BAND in my report and it resulted into double printing/listing/showing of the child table records and summing all of it. What did i do wrong or missed to do? below is the sample result it made (to illustrate).

Detail Band 1                     Detail Band 2
Parent Table (Invoices)           Child Table (Payments)
-------------------------         -----------------------

Inv.No.    Amount                 date paid        amount paid                  balance
-------   ---------               ------------    -------------------           --------
0001       5,000.00              
                                  01/20/2006      2,500.00 (record 1)
                                  01/21/2006      1,000.00 (record 2)
                                  01/20/2006      2,500.00 (record 1 again)
                                  01/21/2006      1,000.00 (record 2 again)
                                                  --------
                                  Total payments  7,000.00                       -2,000.00
                                                  ========                       =========

And also, is it possible to print start of detail band 2 records in the same line with the detail band 1 and not right after below detail band 1? something like this below.

(This is the result i wanted to make)

Inv.No.    Amount                 date paid        amount paid                  balance
-------   ---------               ------------    -------------------           --------
0001       5,000.00 <-same line-> 01/20/2006      2,500.00 (record 1)
                                  01/21/2006      1,000.00 (record 2)
                                                  --------
                                  Total payments  3,500.00                       1,500.00
                                                  ========                       =========

Thanks a lot guys,

Sonny