Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Page Breaks Within A Band?
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00096120
Message ID:
00096150
Views:
13
>>>>>Is it possible to print two pages within a band?
>>>>>
>>>>>advTHANKSance
>>>>>
>>>>> ...kt
>>>>
>>>>Do you have a problem that band is too big, bigger than page? There is >workaround here too.
>>>
>>>I shudda known. Lay it on me Ed! The situation is that I have
>>>a report (same report) that when I get a break on the primary key
>>>(provider id), I need to print two separate pages -- a letter of
>>>intoduction (mostly prepared text, some data from my table) and
>>>an invoice.
>>>
>>>What say U?
>>>
>>> ...kt
>>
>>The genric way to print the same record on two pages is following:
>>1. Inflate your data making two record from each one.
>>Select recno() as Recno, 1 as Lstorder, * From Table1 Order by 1,2 ;
>> Union Select recno() as Recno, 2 as Lstorder, * From Table1
>>2. Group your report form by Recno,Lstorder providing 'Start Each Group on a New Page'.
>>3. All detail band fields should use 'Print When' clause evaluated by Lstorder, i.e. some fields will be printed for Lstorder=1 and others for Lstorder=2
>
>So then in the band I will pro'ly have fields displaying on
>top of each other, but when I actually print(preview) only one
>will print, correct?
>
>What about the fact that the band sizes will be different? Won't this
>throw of any lines bound to the bottom of the band?
>
> ...kt

I usually try to avoid binding to bottom of band and stick with binding to top. Then I use the trick I gave in other post on putting in a field that only contains ' ' (space). Also, I've given up on the ASCII codes - they aren't as reliable with all the different printers out there like they use to be. Instead, do like Ed suggested and set the option for a group to 'Print on New Page'. HTH
Roxanne M. Seibert
Independent Consultant, VFP MCP

Code Monkey Like Fritos
Previous
Reply
Map
View

Click here to load this message in the networking platform