>>>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