To Configure a Report Table
1. In an open design, generate a report.
2. In the
Report Results dialog box, click
. The
Report Engine and the
Report Engine – Field Selector dialog boxes open.
3. In the Report Engine dialog box, define the report headers and footers:
◦ Click Report Table to set the table header and footer.
◦ Click Detail to set headers and footers for individual columns of the report.
4. Click
to add report fields as tabs in the
Report Engine dialog box. The
Report Engine – Group criteria dialog box opens. To add a tab:
◦ Select a report field from the Group on list.
◦ Select the sort order from the Sort order list.
◦ Click OK. The field is added as a tab in the Report Engine dialog box.
| • To change the sort order of the added tabs, click . The Report Engine – Group Editor dialog box opens. Select a field and double-click, or right-click and choose Change sort order from the shortcut menu. • To remove an added tab, select it and click . • The Report Table and Detail tabs cannot be deleted. |
5. Use the following tools to define the report layout:
◦ —Opens the
Report File dialog box to display the original CSV file raw data.
◦ —Opens the
Report Engine – Style Editor dialog box to set report styles.
◦ —Opens the
Report Engine – Field Selector dialog box. Drag a field in the
Report Engine – Field Selector dialog box into the
Detail box on the
Detail tab of the
Report Engine dialog box. Click
in the
Report Engine – Field Selector dialog box to include all fields.
◦ —Opens the
Report Engine – Function Selector dialog box. Drag the functions listed in the dialog box into the
Header,
Detail, and
Footer boxes of the
Report Engine dialog box.
6. Click
. The
Destination dialog box opens. Select one of the following options:
◦ Sheet (default)—Place the table on the design sheet.
◦ XHTML File—Create an XHTML file. Click Browse to specify the location and file name.
◦ CSV File—Create a CSV file. Click Browse to specify the location and file name.
7. Click
to save the format of the report to a
.fmt file.