Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Page Breaks Within A Band?
Message
From
01/05/1998 08:59:14
 
 
To
30/04/1998 17:19:38
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00096120
Message ID:
00096243
Views:
12
>>>>>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?

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

You could bind fields to the top of the band.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform