How to customize the layout of a query or report |
You can customize the layout of any query or report section. Use the column ruler (number bar) at the top of the layout section to place your items.
Data items (including user-defined items and summary items) are represented on the Layout menu by masks. A mask is a row of x characters equal to the maximum length of the item.
The default mask for data items that display dates from the database is only long enough to display the date.
To display the time associated with a date, add more x characters to the mask.
Data items (other than items identified in the application database as numeric type) are aligned to begin at the left-most position of the item.
Data items of numeric type are aligned to end at the right-most position of the item, and are padded with spaces on the left.
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.
To add, change, or remove items or features in a section of the query or report:
Step 1. Position the pointer either where you want to insert an item or on the item you want to modify, move, or delete.
Step 2. Click
the right mouse button
The Layout menu appears.
Step 3. Position the cursor on the Layout menu and select the appropriate item: