Printing Multiple Page Records
If the data tile is made large enough to fill the entire page, Panorama will print only one record per page. In some cases, a single page is not enough. For example, you may need to print an invoice, statement or tax return with several pages per record. Panorama can print up to 9 pages for each record.

To print a multiple page form you will need to create multiple data tiles. The tiles for additional pages can be identified by the page number in the drag bar of the tile. When you create a data tile for an additional page it should be large enough to fill the entire sheet of paper, just like the first data tile. When a form contains data tiles for multiple records, Panorama will ignore any header or footer tiles. Only the margins and data tiles will be printed. This example shows a form for simultaneously printing an invoice and packing slip.

When you print this form, both pages will print automatically for each record printed. If you use File>Print One Record Panorama will automatically print the current invoice and packing slip. If you use the regular Print command, Panorama will print an invoice and packing slip for each selected record.

#### Selectively Printing Multiple Pages per Record

Panorama allows up to 9 pages to be printed per record using data tiles 1 through 9. However, you do not have to print all tiles for each record, you can print them selectively using a formula on the form. For example, you can easily ask Panorama to print pages 1, 2, and 5 for one record and 1 and 4 for another record (page one, the primary data tile, always prints). You could use this feature to selectively print an envelope, to print only selected portions of a tax return, to print one or two page invoices, etc. To control which extra data tiles get printed, you must use the extrapages( function. This function must be put in a formula in a Text Display object somewhere on the main data tile. For example if you want to print pages 1, 2, and 5 you would need to use the formula

    extrapages("25")

Usually you would use a field or variable to selectively control which pages print instead of a fixed string. To illustrate this let’s modify the invoice example from the previous section. This form would always print both an invoice and a packing slip. By adding an extrapages( function we can modify the form so that a packing slip is not printed if the shipping method is Will Call.

The extrapages( function may be placed anywhere on the primary Data tile. The function has no result, so it won’t cause anything to be printed. In this case if the shipping method is Priority Mail, FedEx, UPS, or anything except Will Call, the ?( function will produce `"2"` and the second page (the packing list) will print. If the shipping method is Will Call the ?( function will produce `""` and the packing list will not print.

See Also

- Automatic Mailing Label Construction -- creates a mailing label.
- Automatic Report Construction -- creates a tabular report with columns of data.
- Custom Report Headers and Footers -- setting up custom report headers and footers.
- Custom Report Margins -- specifying the top, left, right and bottom margins of a custom report.
- Printing Multiple Column Reports -- printing reports with two, three or more columns (for example mailing labels).
- Printing Summary Information -- printing a database that has been organized into categories with summary records.
- Report Tile Object -- component for assembling a custom report.
- Reports -- Panorama has a very flexible system for printing custom reports, labels and forms.
- setreportcolumns -- allows a procedure to control the number of columns of a report, and the direction (across or down).
- Tiles In Action -- basic rules for using tiles to print custom reports.
- Variable Height Records -- custom reports with different heights for each record.
- View-As-List Forms -- displaying a custom data layout as a continuous sheet.

History

Version | Status | Notes
10.0 | Updated | Carried over from Panorama 6.0, with some updates.