Layout |
The Layout tab enables you to control and display the entire format of a query or report, including the lineup of columns, indents, and placement of sections. To access this tab, users must be authorized to use the Query/Report Generator.
A layout for the query or report is generated automatically, but you can change it.
To display or create a graph report, refer to graph reports.
To specify that one or more data items generate subtotals for each individual value, or specify that certain data that match a specific value begin on a new page, go to the Groups tab.
To activate printing of summary items for a group, refer to the Group Header (#) and Group Footer (#) fields.
The list box in the top section of the screen specifies the name of the report. If a query or report is selected, the layout for that query or report appears in the center area in the bottom section of the tab.
To customize the query or report layout, see How to Customize the Layout.
In addition to the Query/Report Generator, you can 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 bottom section of the tab reflects the exact arrangement of all data items, labels, and titles in the report. You can define and edit up to 50 rows of information in each section of a report. The sections of the report are as follows:
Report Header
Appears once at the top of the first page of the report. This section is normally empty. You can use it to generate a title page for the report.
Page Header
Appears at the top of each page of the report. This section normally contains items such as the report title, run date and time, page number, and headings for columns of data. In the automatically generated layout for each query and report, this section contains the column name (or other name you specify) for each data item included in the query or report. The names are left-aligned to correspond with the automatic placement of the data items in the report body.
Report Body
Contains the actual values of the data items included in the report, as retrieved from the database or computed as directed. You can arrange the report body to place all data items for one row of data on a single line of the report, or on as many lines as you want. The report body can contain field labels (fixed text) as well as data items. In the automatically generated layout for each query and report, this section contains each data item included in the query or report. The data items are arranged in a single row with one space between 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.
Page Footer
Appears at the bottom of each page of the report. This section normally contains items, like those listed under Page Header, above, that you wish to place at the bottom of each page rather than at the top.
Report Footer
Appears once at the bottom of the last page of the report. This section is normally empty.
If you define one or more groups, see the Groups tab. The following information displays for each group.
Group Header (#)
Appears before the first row of data that belongs to the particular group.
If you define a group on the data item DEPT_dept_code, the Group Header for this data item will appear before each row of data that contains a value for DEPT_dept_code that is different from the value in the previous row.
If a row of data contains values for data items comprising more than one group that are different from the values of such data items in the next row, a group header appears for each such group.
Note: If you place summary items in a Group Header, two data passes are required: one to compute the summary values and a second to generate that data. Reports with summary items in Group Headers take twice as long to generate as reports with the same summary items in Group Footers.
Note: The application currently does not support summary items placed in a Group Header. This restriction will be removed in a future release.
Group Footer (#)
Appears after the last row of data that belongs to the particular group.
If you define a group on the data item DEPT_dept_code, the Group Footer for this data item appears after the last row of data for each value for DEPT_dept_code that is different from the value in the next row.
If a row of data contains values for data items comprising more than one group that are different from the values of such data items in the previous row, a group footer appears for each such group.
The typical use for a Group Header is to display a total of the values for the group at the top of a page on which a group begins. The typical use for a Group Footer is to display a total of the values for the group at the bottom of the last page that contains data for the group. To insert a command to generate a new page in a Group Header or Group Footer, see Insert Function (Form Feed).