>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.
Steve,
IOW you mean you can't create an SQL for this ?
If visual layout here fit with structures as well you might create a simple SQL with unions :
select a.*, b.f1, b.f2, b.f3 ;
from myParent a left join myChild2 b on ... ;
union all ;
select a.*, b.f1, b.f2, b.f3 ;
from myParent a left join myChild2 b on ... ;
....
Another one is to select each row into a new cursor and use relations (each child would have a max reccount() of parent).
Another possibilty is scattering data to an array and get from there.
Hope helps.
Cetin