How to run a report |
Alert: Location ID and Equipment ID Columns Expanded in the Database: Location ID columns have a maximum of 10 characters, and equipment ID columns have a maximum of 20 characters. Although the location ID and equipment ID fields throughout the GUI were expanded to the previously mentioned limits, 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.
To run a report on the Queries/Reports -> Query/Report Generator screen:
Step 1. Select the report name in the list box in the top section of the screen.
The name displays in the Report name field on the Manage tab.
Step 2. In the Output destination field, select or type the name of the print queue or file to which you want to send the report.
Note: If this field
is blank, the output displays at the bottom of the tab.
If the output contains data printed as bar codes, you must specify
a valid print queue (not a printer name) that has been set up to print
bar codes. Go to the Bar Code Printers tab on the
System Mgmt -> Setup -> Printers
-> Standard
Printer Types screen. To use bar codes, the optional Bar
Code Module must be installed.
Step 3. Click the Run Report button.
Note: You cannot close the Query/Report Generator screen while data are retrieved.
The report is generated. If the run generates any database errors, they are displayed.
Note: You can also run
reports created on this screen from the Reports
list box in the standard toolbar
or by issuing a command from the command prompt or from the File -> Batch Process -> Execute screen.
The command consists of the Query/Report Generator screen ID (3005),
the report name, and the output destination.
Example: 3005,FTK_MAIN_REPORT,c:\equipment\report.txt
To learn how to issue a command from a command prompt, refer to How to create a command file.