A group inside de Detail
Manel
Barcelona, Catalonia
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