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 Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.