Information générale
Catégorie:
Gestionnaire de rapports & Rapports
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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement