Understanding Tabular Rows
In tabular sections, rows consist of information that is presented horizontally. Typically, rows contain data that is read from individual database records; however, you can add rows to include details in the report section such as:
Underlines
Blank lines
Special calculations
Tabular sections are the only detail sections for which you can define rows. In all cases, after you create a row, you can drag it to a new location or delete it by selecting Delete from the Edit menu.
Rows can be defined manually or through automatic row generation. Automatic row generation is used primarily in financial reports. A report that displays a chart of accounts is an example of data that can be generated using the automatic row generation feature.
Rows that are defined manually are defined individually and each data row includes its own data selection.
By using RDA, you can manually add these types of rows:
Row Type |
Description |
---|---|
Data rows |
Fetch data from Oracle's JD Edwards EnterpriseOne tables. You must define the rows and identify the data using the business view that is attached to the tabular section. Data rows represent groups of data fields that are associated with the columnar amounts. For example, you can have a data row that displays revenue (column) for a range of items. In addition, you can add a row that displays the direct costs (column) for another range of fields. |
Calculation rows |
Display amounts that are calculated from other rows. For example, you can calculate the gross margin of the revenue and direct costs rows. |
Sum rows |
Define a special type of calculation. The calculation performs totaling for all numeric columns in a range of rows. The total can include or exclude rows within the sum range that are themselves row calculations. |
Underline rows |
Enable you to create underlines to separate various rows in the report. |
Constant rows |
Contain only text. Enables you to describe or label information in the tabular section, such as identification information for a group of rows. |
Automatically generated rows |
In tabular sections, the system automatically generates rows that define a chart of accounts for a business unit or represent the merging of accounts from several business units. After the generation, you can insert rows that calculate account roll-up totals at various levels of detail. For example, you might want the system to automatically generate rows to create a balance sheet report that is based on the current month and the prior year's account balance. |
The system optimizes rows with two or less logical expressions (nodes) that are joined by an AND operator. The optimization accelerates report processing speed. If you include a cover page with the report, you can review which rows the system is optimizing. In the Optimized Row column of the cover page, the system prints a Y next to the rows that are optimized and an N next to the rows that are not. The cover page also includes the total number of rows that are optimized, Number of Optimized Inclusion Rows, and the total number that are not, Number of Non Optimized Inclusion Rows. You can also find the total number of optimized rows in the UBE log file, Tabular Optimization.
The row optimization feature is enabled by default. As a troubleshooting measure, you can disable row optimization by adding this line to the UBE section of the jde.ini:
[UBE] UBETabOpt=0
To again enable row optimization, set the variable to 1, or delete the row from the jde.ini file.