Print Options

Set row and/or column ranges, which are required to print on every page in the Rows to Repeat and Columns to Repeat boxes.

NOTE. Pass-through rows or columns can be set only for the sheet, which contains the opened Page Settings dialog box.

On setting row and column ranges consider the following:

Ranges for pass-through rows or columns must include whole rows or columns.
On entering a compound range, ranges are separated with ";".
Selecting of a cell or a cell range selects all rows or columns that contain the selected cells.
To select a compound range of pass-through rows or columns, hold down the mouse key and the CTRL key.
If the range entered from the keyboard or selected by the mouse does not include whole rows or columns, it is replaced with a whole row/column range, which contain the selected cells. For example, if the pass-through rows were entered: A1:F1; A10:A12, they will be replaced with 1:1; 10:12.
If intersecting or adjacent ranges are set (for example, 0:0 and 1:1), they are merged into one range.
On setting several ranges, they are ordered in the Rows to Repeat and Columns to Repeat boxes in ascending order for rows, and from left to right for columns.

NOTE. Using Fore/Fore.NET macros, using the TitleRowsScope/TitleColumnsScope properties, it is possible to limit scope of pass-through rows and columns.

Select one of the radio buttons to set up page printing order:

Down then Right. Report pages are printed first down, then to the right.
Right then Down. Report pages are printed first to the right, then down.

On setting a compound range of pass-through rows or columns, consider the following output sequences:

If two or more ranges of pass-through rows were set, the data located between the first and the second range of pass-through rows are output first, then those between the second and the third range, and so on. If in this case the range of pass-through columns was set, it is interrupted with the ranges of pass-through rows.
If a report contains several tables that fit to width of one sheet, pass-through rows are set for the table, and there is still free space after the table is put to the page, the next table will be put to the same page considering the pass-through rows specified for this table and at least one data row.
On setting a pass-through row for several tables located one after another, consider that the range of pass-through rows is set for a whole row and not for a cell range.
If two or more ranges of pass-through columns were set, the data located between the first and the second range of pass-through columns is output first, then those between the second and the third range, and so on. If in this case the range of pass-through rows was set, it is interrupted with the ranges of pass-through columns.

If a report contains several tables that fit to height of one sheet, pass-through columns are set for the table, and there is still free space after the table is put to the page, the next table will be put to the same page considering the pass-through columns specified for this table and at least one data column.
On setting a pass-through column for several tables located one after another, consider that the range of pass-through columns is set for a whole column and not for a cell range.

To print report title, select the Print Title checkbox.

To print the current report sheet, select the Print Sheet with Report checkbox. The checkbox is selected by default. When the checkbox is deselected, the report sheet is not printed. Consider that:

On printing the entire book this sheet is not printed, but it can be printed individually.
When the report is exported to PDF or RTF, this sheet is not exported.
On previewing a sheet in the Preview window, the list of sheets contains only this available sheet.
On previewing other sheets in the Preview window, the list of sheets does not contain this sheet.
When only this sheet is printed, the Print drop-down list of the Print dialog box does not include the Entire Report item.

NOTE. The checkbox is automatically deselected on hiding the sheet and is not selected again if the sheet is displayed.

When the Print Header or Print Footer checkbox is deselected, header or footer is hidden.

If the Black-and-White Printing checkbox is selected, all color formatting is reset on preview and print: the whole text, headers and footers are printed in gray shades regardless of the specified colors, the background is white. The checkbox is deselected by default.

NOTE. If black-and-white printing is used, image quality can be worse on preview. This does not affect the printing quality.