A group inside de Detail
                    Hi all,
I need to put a group inside the detail. Graphically, it must be like this:
The data of MasterBand comes from a query, and the data of GroupHeader and DetailBand, from another one.
How can I do this?
tks.
                
                            I need to put a group inside the detail. Graphically, it must be like this:
  Master 1
     Group 1.1
        Detail 1.1.1
        Detail 1.1.2
     Group 1.2
        Detail 1.2.1
        Detail 1.2.2
  Master 2
     Group 2.1
        Detail 2.1.1
        Detail 2.1.2
     Group 2.2
        Detail 2.2.1
        Detail 2.2.2
...
The data of MasterBand comes from a query, and the data of GroupHeader and DetailBand, from another one.
How can I do this?
tks.
Comments
look at how your 2 queries are connected or run one query on joined tables with an orderby clause to get all the data into one result set then apply grouping as necessary.
regards