Printing the Database Records¶
To print the database records, click on the Print All Records icon or choose File | Print All Records from the Database Records Management screen.
Printing Records¶
If you are printing labels with a thermal/thermal transfer printer, you will need an ink-jet, laser or dot matrix printer to print a database.
Your printer should be turned on, in the ON-LINE/READY mode and loaded with paper. The database fields will be printed within the width of the paper.
After selecting to print all records, you will be presented with the Printing Options specification screen. Once you have entered all items correctly, the information will be sent to the printer or, as an alternative, the database records can also be printed to a file.
Each of the Database Print option items are described in the following section.
Destination¶
Please select the destination for the report. Select Printer to send the report to the printer, Printer Data File to create a file which includes printer control characters, or Text File to create a fixed-space ASCII1 text file.
Where¶
This should be a LOGICAL expression using the field names listed, along with constants, arithmetic operators, comparison operators and logical operators. String constants should be enclosed in single quotes. The LIKE comparison operator can be used to perform pattern matching. A % (percent sign) represents ANY STRING of characters and an _ (underscore) represents ANY SINGLE CHARACTER.
Examples: AISLENUM = 100; COLOR = ‘BLUE’; SERIALNUM >= 10001 AND SERIALNUM <= 10005; UPCCODE LIKE ‘12130_____7’ AND ITEMNUM <>1000
Printer Setup¶
Select No to use the current default printer options. Select Yes to change the printer options for this report. Modified printer settings are specific to the currently selected report.
Font Setup¶
Select No to use the default printer font, or Yes to select a different font for this report.
Top Margin¶
Enter the distance from the top of the paper to the beginning print position in hundredths of inches or tenths of millimeters.
Left Margin¶
Enter the HORIZONTAL OFFSET of the print image area from the left edge of the paper in hundredths of inches or tenths of millimeters.
Report Title¶
Enter the Report title that should appear on each page. For the default Report title, leave BLANK.
Include Fields¶
Indicate which fields are to be included in the report by choosing from the list shown. Fields are printed in the sequence that they were chosen.
- 1
ASCII: The character set and code described in American National Standard Code for Information Interchange. Each ASCII character is encoded with seven bits and consists of both control and printing characters.