Create and scan bar codes

Note: The optional Bar Code Module must be installed.

To create a bar code that you can scan into the application with a wedge:

Step 1. Open the Queries/Reports -> Query/Report Generator screen.

Step 2. Create a new report using the specifications listed in the following steps. (See also report design.)

Step 3. On the Data Items tab, select the table and column that contain the information for the bar code. For this example, we will create an equipment ID bar code by selecting the EQ_MAIN table and the EQ_EQUIP_NO column.

Step 4. On the User Defined tab, to the left of the New Field button, type eq_barcode and click the button.

FASuite adds Eq_barcode to the list of data items.

Step 5. Click Eq_barcode to highlight it.

Step 6. In the large box at the top of the tab, type the expressions shown in boldface. Each expression begins with a one-character identifier specific to the item. Because this example creates an equipment ID bar code, the expressions are preceded with Q. For additional one-character identifiers, refer to Data item concatenation identifiers.
Oracle ‘Q’ || EQ_MAIN.EQ_EQUIP_NO
MS SQL ‘Q’ + EQ_MAIN.EQ_EQUIP_NO

Step 7. On the Restrictions tab, in the box at the top of the tab, type the following:
EQ_MAIN.EQ_EQUIP_NO = '<PROMPT: ENTER EQUIPMENT UNIT>'

Step 8. On the Layout tab, right-click directly under --- Report Body --- and select Default Layout from the menu that appears.

A mask of x's displays under --- Report Body ---.

Step 9. Click to the right of the x mask.

A menu appears.

Step 10. Select Insert Data Items from the menu and eq_barcode from its sub-menu.

A new group of x's appears.

Step 11. Right-click the new group of x's and select Edit Item from the pop-up menu.

An Edit box for eq_barcode appears.

Step 12. In the eq_barcode Edit box, insert a check (ü) in the Print as barcode field.

Step 13. Click OK.

Step 14. Click the Manage tab.

Step 15. Name and save the report. (See also How to save a report.)

Step 16. Print the report.

Step 17. Use a wedge to scan the bar code into the application.

_______________

Create and scan bar codes

See Also