General information
Category:
Reports & Report designer
Steve,
It seems to me that you should be able to use grouping's and have the fields in the groupings set to "Stretch with overflow"
-Isaac
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only