To Apply Functions in a Report Table
You can use functions in report tables to do the following:
• To display column information in footers in the Data tab.
• To display general report information in headers and footers in the Report Table tab.
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. Drag a field from the
Report Engine – Field Selector dialog box into the
Detail box on the
Detail tab of the
Report Engine dialog box, or click
in the
Report Engine – Field Selector dialog box to include all fields.
4. In the
Report Engine dialog box, click
. The
Report Engine – Function Selector dialog box opens, displaying a list of available functions:
◦ =ave()—Calculates the average value of a column.
◦ =count()—Counts the items in a column.
◦ =date(dd/mm/yy)—Inserts the report generation date with the day (dd) first.
◦ =date(mm/dd/yy)—Inserts the report generation date with the month (mm) first..
◦ =max()—Inserts the maximum column value.
◦ =min()—Inserts the minimum column value.
◦ =numPages()—Counts the number of pages in a report.
◦ =page()—Inserts page numbers.
◦ =std_dev()—Calculates the standard deviation value of a column.
◦ =sum()—Calculates the sum value of a column.
◦ =time(HH:MM)—Inserts the report generation time.
◦ =time(HH:MM:SS)—Inserts the report generation time.
◦ =variance()—Calculates the variance value of a column.
◦ divider—Inserts a dividing line.
5. Drag the functions in the dialog box into the Header, Detail, and Footer boxes of the Report Engine dialog box.
| If a function requires a field as an argument, drag the appropriate field from the Report Engine – Field Selector dialog box into the respective function box. For example, to calculate the average value of a field, insert the function ave() then drag the field into the ave() box in the Report Engine. |
6. Click Generate Report to place the report table on the open sheet.