Ian,
You may have to 'group' the data programatically in a cursor which is built before the report is run. In a similar situation I JOINed several tables (had to have a LOT of fields in the report cursor) and ordered them depending on the source table. Then just printed the cursor and the different data sources were in the right order.
Let me know if this is too confusing.
Barbara
>Is is possible to have multiple DATA GROUPs that are NOT nested? I just can not figure out how to un-nest the DATA GROUPING. This means that my report shows on one DETAIL section and as such nests information, which I do not want.
>
>I have 3 tables with data I need to print and I was looking for an output like:
>
>John Doe DATA FROM TABLE #1
>250 6th St
>Alberta, Canada
>
>-------------
>DISTANCE PRICE/K PRICE/M DATA FROM TABLE #2
>18 17 60
>20 255 1000
>
>-------------
>PARTNER TITLE ADDRESS DATE FROM TABLE #3
>Big Bob CEO 100 Somewhere Pl
>Little Joe CFO 200 There Lane
>
>
>Is it possible???