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:

&pPrints the current page number
&p+numberPrints the current page number plus 'number'
&p-numberPrints the current page number minus 'number'
&nPrints the total number of pages
&mPrints the current paper sheet number (different than &p when printing many pages on one sheet)
&fPrints the full file path
&aPrints the name of the printed table
&dPrints the current date
&tPrints the current time
&gPrints the file modification date
&zPrints 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:

&lLeft-aligns the following text
&cCenters the following text
&rRight-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.