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

Or... you could just lay out the form so the the group header contains the letter, then continue on with the invoice. I am sure there is some type of ascii escape code you can use to force the printer to do a new page.

BOb