Overview - Queries and Reports |
The Query/Report Generator enables you to run standard, predefined reports and design custom reports. If you only want to run standard reports, you can use the Reports list box in the standard toolbar as an alternative to the Query/Report Generator screen. See also Standard reports.
You can run reports created on this screen by issuing a command. You can also assign them to specific screens from which you can run them. To assign reports created on this screen to specific screens, go to the System Mgmt -> Access Rights -> Setup -> Report Groups screen.
You can also use 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.
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.
The Queries/Reports menu provides access to the following screens:
Create and execute quick view queries and simple and complex reports. For step-by-step instructions on how to use this screen, go to query/report design
Associate SQL stored procedures with queries and reports
Specify contents of the Facility Summary report
_______________
See Also: