Printing tables, forms and labels |
To print tables, forms, letters or labels
In the Print dialog box, choose the desirable print mode clicking one of the tabs: Table, Form, Letter, Labels.
Depending on your selection, you will be able to specify several additional printing options for each print mode.
Table:
This is the default print mode. Use it to print selected records in plain tables.
Long Text, Image/File and Code fields are not printed in that mode.
To specify which of the text and numeric fields should be printed, click the Table tab.
Form:
GS-Base will print each record as a fixed-layout form. There are two form variants:
(1) one-page forms where the first Long Text, Image/File or Code field
and the remaining Text/Numer fields are printed "side by side" on a single page (thus the text can be truncated),
(2) multi-page forms where all Long Text, Image/File and Code
fields are printed on the subsequent pages after all Text/Number fields.
If the Continuous printing option is selected, GS-Base will continue printing
subsequent records/forms up to the bottom of the page. If this option is turned off, each new record/form starts
on a new page. This option is disabled if a given table contains Long Text,
Images/Files or Code fields.
To specify which field should be printed and to turn on/off printing one-page forms,
click the Form tab.
Letter:
GS-Base will print a user-defined *.rtf form containing any amount of text and graphics
with embedded references to text and numeric record fields and with embedded formulas performing calculations. A field reference
is specified by a field name in double-curly braces. A formula additionally must begin with "=".
One copy of such a document is printed for each record of the current record set.
Clicking the Edit in External Application command you can edit the form in the application associated with the *.rtf format.
Changes are saved automatically after choosing the Save command in that application.
Labels:
You must define the required label format. To do this, click the Labels tab, then click
the New Labels button and enter the name of your new label format.
Then specify the number of columns and rows of labels on one page, vertical and horizontal label spacing and insert data fields you want to print on each label.
Data fields can be simple database field names (references) or formulas (see: Entering formulas).
If the resulting text overflows the field rectangle:
If you want the formula data to span two or more lines, insert the char(13) or char(10) (new line/line feed) functions between field values
and/or strings in that formula, for example: =Name & char(13) & City .
When editing labels you can move or resize the fields. To select a group of fields press Shift and click subsequent fields
or press down the left mouse button and drag the mouse cursor.
To set the default height of the data field rectangle, right-click it.
To rename an existing label format, press Shift and click New Labels button.
Select the desirable Page Range option. You can print all found records, selected range of records or particular pages.
To print selected pages
Choose the Pages option in the Print > General
dialog box and specify the list of pages to print.
The list can contain single pages or page ranges separated by commas.
For example: 1,2,4-8,10
To print more than one page on a single paper sheet
Specify the number of printed pages in the Pages per sheet fields in the Print > Layout dialog box. For example, if you choose two columns and three rows, one sheet will contain (up to) six pages.
To include a table name, page number, date etc. in the printed pages headers and footers
In the Print > Layout dialog box, enter the header/footer text inserting the following special codes:
&p | Prints the current page number |
&p+number | Prints the current page number plus 'number' |
&p-number | Prints the current page number minus 'number' |
&n | Prints the total number of pages |
&m | Prints the current paper sheet number (different than &p when printing many pages on one sheet) |
&f | Prints the full file path |
&a | Prints the name of the printed table |
&d | Prints the current date |
&t | Prints the current time |
&g | Prints the file modification date |
&z | Prints the file modification time |
&& | Prints a single ampersand |
To format the header/footer text
In the Print > Layout dialog box, enter the header/footer text inserting the following special codes:
&l | Left-aligns the following text |
&c | Centers the following text |
&r | Right-aligns the following text |
To change the view scale in the print-preview window
Click the Zoom In button and pressing the right mouse button select a rectangle that should be zoom in.