Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any suggestions on how to do this type of report?
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00402779
Message ID:
00402796
Views:
6
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
Map
View

Click here to load this message in the networking platform