>Hi all,
>
>Using the VFP Report Writer can I design a report where each record in my Employee Master occupies 2 pages and how to do this? Can FoxFire do this?
>
>Regards,
>Farouk Yew Abdullah
>Visual Solutions (M) Sdn. Bhd.

I don't know about FoxFire, but without it, you have to:

SELECT ALL keyfield, 1 AS listorder, page1field1, page1field2, ... , page1fieldlast , memofield, "" AS page2field1, "" AS page2field2, ... , " AS page2fieldlast FROM yourtable INTO CURSOR TmpReport WHERE &YourReportCriteria UNION SELECT ALL keyfield, 2 AS listorder, "" AS page1field1, "" AS page1field2, ... , "" AS page1fieldlast, memofield, page2field1, page2field2, ... , page2fieldlast FROM yourtable WHERE &YourReportCriteria AND NOT EMPTY(somepage2field)

The last NOT EMPTY is in case you want to print the second page only for records with something in somepage2field. Your report controls will have to be all over the top of each other in the detail band. Controls which print on page one get PRINT WHEN listorder = 1, and vice versa for page 2 controls. You'll notice that the memofield is included in both parts of the SELECT. That is necessary to make it UNION compatible. You may want to set a constant bandwidth for your detail band which fills your page. Be careful about putting controls under other controls that stretch. Often, the controls under them get bumped to the next page, even though they are at fixed height relative to the top of the band, and even though there is plenty of room. I have struggled a lot with this, and never got perfect results. It seems that VFP3 really doesn't want to be told where to put page breaks. I would like to hear about whether FoxFire! or any other product is effective for printing multiple-page reports. Eventually I may abandon the report writer alltogether and run everything into Word, if I can make that work better. The client would like to e-mail reports, and the report writer doesn't do a good job making files. (I've had truncation and sloppy results using REPORT FORM ... TO FILE filename ASCII).