The sample report EMP_EXPENSE, illustrated below, contains employee expenses by month. It is composed of a body report table, two title report tables, and one break table within a report table. A description of each element follows, using examples from this sample report.
Title report tables are used to define title and footer elements that can be used by other reports, independently of the body report table. The title report tables in the sample report contain the corporation name, the page number, and footer text.
The body report table is the primary table of the report. The data from your data tables is inserted into the body report table. You define only one body report table for each report definition. In the following example, the body report table contains the employee expenses.
The following illustrates the break table MONTH_BREAK. This break table contains two break fields, MONTH_NAME and MONTHLY_TOTAL, and displays report table values from the data table:
Report fields are the placeholders that contain the data for your report. The data can be inserted directly from a data table or can be derived dynamically at runtime based on a specified rule, field, or report function. In the example, the values for the employee name, ID, and monthly expense come directly from an employee table. The values for the month, total expenses, date, and page number are based on derived values.
Title and heading rows can be defined within report tables and title rows can be defined within break tables. They can contain both literal fields and report fields. Title rows print only once per page (although break titles can appear more than once on a page). Heading rows can be defined to print for each break within a report table or only once per page.
Employee Expense Report by Month is an example of a title row.
Employee Last Name ID# Monthly Exp is an example of a heading row.
Title columns and final columns can be defined within report tables of an across report. Title columns are printed only once at the beginning of each page and the beginning of each panel of an across report. Final columns are printed only at the end of the final panel of the report. Since the sample report is not an across report, it has no title columns or final columns.