>Can you help me with the next issue on this report? It is regarding grouping in a multi-detail band report... The screenshot shows my current report that uses only one detail band with a complex "Print When" strategy to make it work.
>
>I currently simulate mutiple bands as a single query containing 3 sets of child records to the main parent. It needs grouping to occur on the second band, based on the Machine_Number of the child records.
>
>When I tried to convert the report to use actual multiple bands, and then added grouping definition, it applies as an outer wrapper to all the detail bands, but I only need it INSIDE of one of the bands.
>
>Do you know of any way to make this work. (See the screenshot for a marked up report to see what I mean)
That's the way the report writer works ... data groups are on the outside ... the detail bands are within the data groups. There isn't any way to change that behavior. Of course, there's always a way to manipulate everything with a report listener .. but it will take some ingenuity and creative thinking.