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.