Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Page Breaks Within A Band?
Message
From
30/04/1998 16:57:45
 
 
To
30/04/1998 16:50:48
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00096120
Message ID:
00096126
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
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform