Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 6 Composition of a Report : Elements of a Report

Elements of a Report
List of Elements
A report defined in TIBCO Object Service Broker can contain a number of structural elements:
Illustration of Sample Report
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.

 
DEVELOPMENT CORPORATION Page 12
 
04/MAR/2007 Employee Expense Report by Month
Month of DEC
Employee Last Name ID # Monthly Exp
---------------------- ------ -----------
BARALDI 98895 89.00
BOIVIN 71866 0.00
CANNON 51121 0.00
CLARK 44789 0.00
CROFTON 41001 0.00
DHILLON 61385 1010.80
GLADWELL 32189 0.00
HARTIG 43456 0.00
HOEGSON 30058 0.00
HRODEK 51111 0.00
. . .
Monthly Total 9730.00
Accounting Department
Internal Confidential

 
Title Report Tables
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.
Title Element

 
DEVELOPMENT CORPORATION Page 12

 
Footer Element

 
Accounting Department
Internal Confidential

 
Body Report Table
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.
MONTHLY_EXPENSE Report Table

 
|
| Employee Last Name ID # Monthly Exp
| ---------------------- ------ -----------
|
| BARALDI 98895 89.00
| BOIVIN 71866 0.00
| CANNON 51121 0.00
| CLARK 44789 0.00
| CROFTON 41001 0.00
| DHILLON 61385 1010.80
| DRABEK 22001 2321.00
| GLADWELL 32189 0.00
| HARTIG 43456 0.00
| HOEGSON 30058 0.00
| HRODEK 51111 0.00
| . . .

 
Break Tables
Break tables are used to visually group related information rows within a report table. In the example, the information is grouped within individual months.
MONTH_BREAK Break Table
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:

 
| Month of DEC |
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
| Monthly Total 9730.00 |

 
Report Fields
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.
Literal Fields
Literal fields contain the text of your report. They contain no data. ‘Month of’ is an example of literal text.
Control Fields
Control fields determine how the data should appear. There are four types of control fields:
Determine how the data is sorted. In the above body report table, the employees are sorted by month and last name.
Determine where a control break occurs in a report. When a different value is encountered for a break field, a new grouping of values is printed. For example, the above sample report breaks on a new month.
Summary fields
Summarize data. A report line is printed for every change in value of a summary field or field combination. The above sample report contains no summary information.
Sort across by fields
Determine the data columns printed on an across report. When a new value is encountered for an across by field, a new data column is printed. The above sample report is not an across report so it contains no across by fields.
Title and Heading Rows
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
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.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved