Steve,

The usual principle with weird data combinations is to make a cursor like:
RecordType, Fields from table1, fields from table2, fields from table3

Then append your data records in the order you want them, setting the value of RecordType to say which table they came from. Then put all of the report controls on top of each other with Print When to determine which one prints. Then run the report.


>My report starts with one row of detailed information from my record in my table. But after the first row, all bets are off.
>
>My next report section contains a group of 3 rows of detail information from another table and the 3 records in that table.
>I can have up to 7 groups of 3 records each.
>
>Here is my report visually -
>
>Row 1 xxxxxxxxxx xxxxxxxxxx xxxxxxxxx xxxxxxxxx
>
>Row 2 111111 111111 111111
>Row 3 222222 222222 222222
>Row 4 333333 333333 333333
>
>Row 5 444444 444444 444444
>Row 6 555555 555555 555555
>Row 7 666666 666666 666666
>
>and so on... up to row 22. But if I don't have data after a certain row I want to move the next detail line up so I don't waste paper.
>
>Do I have to put the groups of 3 detail records in a group level and repeat the group level multiple times depending upon how many groups of 3 I have that match the Row 1 detail record on one field? Or what is the best way to do this?
>
>This is also complicated by the fact that I have to translate most of the codes in the fields from codes to text/verbage using LEFT JOINs in my SELECTs that build my CURSORs.
>
>Thanks for your suggestions.