Data Items

The Data Items tab enables you to specify which data to display on a query or report. To access this tab, you must be authorized to use the Query/Report Generator.

For step-by-step instructions on how to design a report, refer to query/report design. You can also use FA Web Modules or any other reporting tool sold separately (such as Microsoft Access) that can attach to the database. Refer to the related documentation for these products.

The Data Items tab is divided into four sections:

The grid (top) section displays a list box of existing queries or reports.
The column in the lower right section lists the data included in the query or report currently selected at the top of the screen or that you are defining. To view an data item's characteristics, click the + to the left of the data item name. Up to four characteristics for the data items are listed: field name, type (alpha, numeric, variable characters), length, and number of decimal places.
The column in the lower center section displays the names of the tables included in the query/report. To view the names of the data items available for inclusion in the query/report, click the + to the left of the table name.
The column in the lower left section displays all the tables and views that are defined in the database and available for inclusion in the query or report. The tables contain all fields on the application screens.

Note: This help text uses the word "table" to refer to both tables and views.

To specify data items to appear in a new report or to update data items in a defined report, see how to select data items.

Location ID and Equipment ID Columns Expanded in the Database: Effective with Release 6.0.x, location ID columns were expanded from 6 to 10 characters and equipment ID columns were expanded from 12 characters to 20 characters.

Although the location ID and equipment ID fields throughout the GUI were expanded, standard reports in the Query/Report Generator were not changed to accommodate the expansion. If you use more than 6 characters for a location ID or 12 characters for an equipment ID, you will need to modify your reports to ensure that they display the full number of characters.

Note: Using a longer location ID may increase the size of part bar codes. If a part bar code is too long, it may run off the right side of the label and become unusable.
Tip: Before you run the conversion against your production data, make sure that you run a test conversion from your current version to 6.0.x. The conversion could take a long time to complete as these expansions affect several large tables. You will need to plan how much time to set aside for your production conversion.

_______________

Data Items

See Also