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

I couldn't get the form feed (CHR(12)) to print. Something
intercepts the code and changes it to some kinda graphic symbol
that just prints as a square.

...kt