Data Printing

Previous Next

The print facility will print all columns that are retrieved by a query. To limit the number of columns to print, you can either use the Windows Designer to rewrite the underlying query, or you can set the column to non-displayed. All columns retrieved by a query will be printed in table orientation.

Note the following:

· If all columns do not fit on one row (i.e. the width of the paper), the labels and each record are printed on multiple lines. When multiple lines are used, each column will start at the nearest tab stop, which are set each 15 character positions. The records will be separated by a blank line. When all columns do fit on one line, these tab stops and blank lines will not be used.


· Only "ordinary" data columns are printed. This does not include OLE Containers, Bitmap Images, etc., these cannot be printed directly.


· The data in LONG and CLOB fields is truncated. If you print data from a spreadsheet (grid box), the data will be truncated to the width of the column. If you print data from a non-spreadsheet window, the data will be truncated to the line width.


· The print-related actions can be used in decisions, SqlScript() etc. but you cannot pass parameters to them. For this reason, the only relevant use in decisions should be to have a decision check whether the window contains records at all, and then either to print the records, or to disable the print options/buttons.


· To be able to print data, you must put focus on a window, and the window must contain data. You cannot work the other way round.


· By default, all QUERIED records are printed. To limit the number of records to print, perform a relevant query first, and then use the Print option.