Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to create multi-page report
Message
 
To
14/11/2001 22:56:32
Eugene Kolmakov
Millennium Technologies
Vladivostok, Russia
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00581891
Message ID:
00582172
Views:
43
>I have an employee personal card wich consists of four pages. Is there any way to make such multi-page report using VFP report designer ?
>
>Each page represents separate data from several tables and I need them to be in one report form.

Start by creating a cursor with all the fields and a new field called RECTYPE. For each employee, add the record to the cursor four times ... setting the RECTYPE to "1", "2", "3" and "4" for each record respectively.

When you design the report, setup a group on RECTYPE and mark it start each group on a new page. Now expand the detail band to the size of a page (minus any header or footer allowances). Add all the fields you want on the first page, setting the "Print When" logic to RECTYPE = "1" for all fields. Next, add all the fields for the second page on top of the first set, and set their Print When logic to RECTYPE = "2" and keep going for all four pages.

To make it easier to layout, I usually add the fields for the first page then highlight them all and use the Format - Group option to link them all together. Then I open up a new report and add all the fields for the second page. Group them together. Then copy and paste them to the first report. Keep doing this until you have all the "chunks" on the main report. I find it's much easier to deal with the data this way instead of trying to design the report with fields on top of fields.

Cathy
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform