GS-Base Help > Printing Tables, Forms, Letters and Labels

To Print Tables, Forms, Letters or Labels

In the Print dialog box, choose the desired print mode by 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/Number 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 must additionally 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 the 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 and hold 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 the New Labels button.

Select the desired Page Range option. You can print all found records, a 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 from &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, then press and hold the right mouse button and drag to select the rectangle you want to zoom in on.