To Configure a Report Table
Before you place a report table on a design sheet, you can customize it. Tables that contain a large amount of data are placed in sections called Pages.
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 headers and footers for the report pages. Headers and footers can contain functions that provide report information such as date and time.
◦ Click Detail to set headers and footers for individual columns of the report. The default headers are the report column names. Footers can contain functions that are performed on data in the column.
4. Click
to group report results. The groups appear as pages in the report table and as tabs in the
Report Engine dialog box. The
Report Engine – Group criteria dialog box opens. To add a group:
◦ 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 – 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 to view in a browser. 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 table to a
*.fmt file.