Skip Headers
JD Edwards EnterpriseOne Tools Development Tools: Report Design Aid Guide
Release 8.98 Update 4

Part Number E14708-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

9 Modifying the Appearance of Report Sections

This chapter contains the following topics:

9.1 Understanding the Appearance of Report Sections

Sections, column headings, column variables, runtime fields, and constants have their own set of properties.

Some properties affect the report section layout. For example, you can modify the format of the report by changing column and row spacing and object alignment.

Using the features of Oracle's JD Edwards EnterpriseOne Report Design Aid (RDA), you can change the appearance of report sections by:

9.2 Working with Section Descriptions

This section provides an overview of section descriptions, lists the prerequisites, and discusses how to change section descriptions.

9.2.1 Understanding Section Descriptions

The RDA workspace uses a grid to present all sections that are included in the report template. The exception might be a section that you set up as invisible. The grid is white and typically displays dots that aid you in positioning fields within a section. To the left of each section is a gray tone tile. This tile displays section descriptions that typically represent either the section type, such as page header, or the name of the attached business view.

A level break section is typically named after the level break field on which it is based. For example, On Search Type is the description for a level break header section that breaks on the Search Type field.

If you do not want to view these section tiles, you can hide them in User Options.

When you create a custom section and attach the same business view that you attached to the level one section, both sections have the same description. To tell the sections apart in Event Rules Design, rename one of the sections. You can change the section description on the appropriate section properties form. Adding a prefix to the custom section to indicate that it is the custom section is helpful.

A group section that is created to hold grand totals is untitled because it does not have a business view attached. On the appropriate section properties form, you can modify the section description to read Grand Totals.

9.2.2 Prerequisites

Before you begin changing section descriptions, ensure that you:

  • Create a batch application object.

  • Complete the design of the report template.

9.2.3 Changing Section Descriptions

Open a report template in RDA.

  1. Double-click the section that you want to change.

  2. On the appropriate section properties form, enter a new name (or modify the existing name) in the Description field on the General tab, and click OK.

9.3 Hiding Report Sections

This section provides an overview of how to hide report sections, lists the prerequisites, and discusses how to hide and display report sections unconditionally.

9.3.1 Understanding How to Hide Report Sections

You can hide a report section if the sole purpose of the section is to provide logic to be used by another section. The information that is contained in an invisible section does not print on the report. Hiding report sections in this manner is referred to as unconditional. The section is never meant to appear in the report.

You could open a report template that includes an invisible section and not know that the section exists. So that you can see invisible sections of reports in the RDA grid, select the Show Invisible Sections At Startup option in User Options.

You can also hide a report section based on specific criteria. Hiding report sections in this manner is referred to as conditional because the section appears only when the stated condition is met. You can create event rules that show the section only when a field value reaches a certain amount. Another condition might be when the user requests, through processing options, that the section be included in the report.

See Setting Up Custom Sections.

9.3.2 Prerequisites

Before you begin hiding report sections, ensure that you:

  • Create a batch application object.

  • Complete the design of the report template.

9.3.3 Hiding and Displaying Report Sections Unconditionally

Open a report template in RDA.

  1. Double-click the report section that you want to affect.

  2. On the appropriate section properties form, select the Advanced tab.

  3. Select the Visible option to display the report section, or clear the Visible option to hide the report section, and then click OK.

9.4 Aligning Fields and Columns

This section provides an overview of how to align fields and columns, lists the prerequisites, and discusses how to:

9.4.1 Understanding How to Align Fields and Columns

When you initially create a report section, fields and columns might not line up properly. RDA provides alignment options to enable you to precisely adjust the appearance of the report output. For example, you create a group section and need to align fields under other fields. Or you create a columnar report with a level break footer that calculates totals. You change the size of the columns in the columnar section, and the total in the level break footer no longer aligns with the column that it is totaling.

When you align fields, you are presented with options based on your selection to align objects within a section or across sections. On the Align Objects form, options are listed under these headings:

Alignment Options Description
Left to Right Available for aligning objects within sections and across sections.
Top to Bottom Available for aligning fields across sections only.

When you align data fields, use these guidelines:

  • Clear the focus of the cursor in all report sections before you select the objects for alignment.

    Click an empty portion of each report section to clear the focus of the cursor. You could have the cursor focused on a field in a section, such as the page header, and not realize it. When you align a field without clearing the focus, a field from another section, such as the page header, will be aligned with the selected field.

  • Designate one object as an anchor to which other objects are aligned.

    The anchor field is indicated by a black border; the objects to be aligned with it are indicated by a gray border. The anchor field is the last field that you select during the alignment process.

  • The black border indicates the currently selected field.

  • The entire object must be selected for alignment, not just the constant text or variable.

  • The anchor can be a disconnected constant or variable object.

  • The objects that are selected can be within the same section or across sections.

  • The fields are aligned rather than the text within the fields.

    This is especially noteworthy when you center-align fields. Objects are centered based on field length and not on the length of the text within the fields.

  • The alignment process cannot be used on tabular rows.

When you align columns from tabular and columnar sections, use these guidelines:

  • To align columns with group section objects, select the column in the tabular or columnar section that you want to use as the anchor for the alignment.

  • To align columns with columns in another columnar or tabular section, you can select only one column in each tabular or columnar section.

9.4.2 Prerequisites

Before you begin aligning fields and columns, ensure that you:

  • Create a batch application object.

  • Complete the design of the report template using a columnar section.

  • Include a level break footer with a label.

9.4.3 Aligning Fields Within Sections

Open a columnar report template in RDA that includes a level break footer.

  1. Click the aggregate label in the level break footer.

  2. Hold down the Ctrl key and click the total field.

    The rectangle around the aggregate label lightens in color while the rectangle around the total is dark in color.

  3. From the Layout menu, select Align.

  4. Select the Current Section option under the Apply to heading.

  5. Select one of these options under the Top to Bottom heading:

    • Top Edges

    • Middle

    • Bottom Edges

    • No Changes

  6. Click Apply to view the changes without leaving the form.

9.4.4 Aligning Fields and Columns Across Sections

Open a columnar report template in RDA that includes a level break footer.

  1. Click the total in the level break footer.

  2. Hold down the Ctrl key and, in the columnar section, click the column variable that is associated with the total.

  3. From the Layout menu, select Align.

  4. Select the All Sections option under the Apply to heading.

  5. On the Align Objects form, select one of these options under the Left to Right heading:

    • Left Edges

    • Center

    • Right Edges

      Typically, when aligning numeric values, you want to align by the right edges so that the decimal places line up properly.

    • No Changes.

  6. Click Apply to view the changes without leaving the form.

  7. When the alignment is complete, click OK.

9.5 Using Absolute Position for Text Wrapping

This section provides an overview of absolute position, lists the prerequisites, and discusses how to activate absolute position.

9.5.1 Understanding Absolute Position

The Absolute Position option enables you to wrap text that is fetched from the database, business view columns, and media object text. This option does not affect text that is supplied through event rules or entered into constant fields.

When you select the Absolute Position option, text is truncated in fields where the display length is too short. The system leaves the text in its absolute position. When you clear the Absolute Position option, the text is wrapped to the next line of the field.

Note:

You cannot define text wrapping for individual fields; you must apply text wrapping to an entire detail section.

9.5.2 Prerequisites

Before you begin activating absolute position, ensure that you:

  • Create a batch application object.

  • Complete the design of the report template.

9.5.3 Activating Absolute Position

Open a report template in RDA.

  1. Double-click the section in which you want to wrap text.

  2. On the appropriate section properties form, select the Advanced tab.

  3. Select the Absolute Position option to inactivate text wrapping or clear the option to activate text wrapping, and then click OK.

    If the Advanced tab does not include an Absolute Position option, you cannot affect text wrapping for the section.

    Note:

    The Absolute Position option is cleared by default.

9.6 Changing Column Spacing

This section provides an overview of column and row spacing, lists the prerequisites, and discusses how to:

9.6.1 Understanding Column and Row Spacing

You can modify the space between columns and the space between rows in columnar and tabular report sections.

In the Spacing menu option, which is available only for columnar and tabular sections, two tabs are available:

  • Column Spacing

  • Row Spacing

The Column Spacing options enable you to:

  • Center the report under the page header information.

  • Modify the spacing among all columns of the section.

  • Modify the spacing between individual columns.

  • Bring attention to the data in a specific column by adding spaces to set the column apart from the other columns.

On the Column Spacing tab, you can select all columns or indicate specific columns that you want to affect. You enter a value in the Space before selected columns field to indicate the amount of space that you want between the columns. Click Apply to view the new spacing before leaving the form to ensure that the new spacing meets your needs.

You can also change the spacing of rows to improve the appearance of a report. From the Row Spacing tab, you can modify the spacing between:

  • The page header and the detail section.

  • The rows in the detail section.

Your choices for the row spacing of a tabular or columnar section are:

  • Single

  • Single + Half

  • Double

Note:

Only single spacing is supported for CSV files. Only single and double spacing are supported for line printers.

In a tabular row report, you can change the space before a row. This is defined on the Options tab of the Row Properties form.

9.6.2 Prerequisites

Before you begin changing column spacing, ensure that you:

  • Create two batch application objects.

  • Complete the design of the first report template using a columnar section.

  • Complete the design of the second report template using tabular rows.

9.6.3 Modifying Column Spacing

Open a columnar section report in RDA.

  1. Click the columnar or tabular section in which you want to modify column spacing.

  2. From the Layout menu, select Spacing.

  3. On the Column Spacing tab, perform one of these actions to affect the column spacing:

    • Click the Select All Columns button to apply the spacing to all columns in the section.

    • Select specific columns from the list to which you want to apply the spacing.

  4. In the Space before selected columns field, enter the number of spaces that you want to appear before the selected columns, and click OK.

    The default value is set at five spaces.

9.6.4 Modifying Row Spacing in Columnar Sections

Open a columnar section report in RDA.

  1. Select the columnar section in which you want to modify row spacing.

  2. From the Layout menu, select Spacing.

  3. On the Columnar Section Spacing form, select the Row Spacing tab.

  4. Select a Header to Detail option and a Detail to Detail option.

    Note:

    Only single spacing is supported for CSV files. Only single and double spacing is supported for line printers.
  5. Click Apply, and then click OK.

9.6.5 Modifying Row Spacing in Tabular Row Sections

Open a tabular row section report in RDA.

  1. In the tabular section, double-click a row to create a space above it.

  2. On the appropriate row properties form, select the Options tab.

  3. Enter a value in the Space Before field, and click OK.

9.7 Reprinting Information After a Page Break

This section provides an overview of Reprint After Page Break, lists the prerequisites, and discusses how to reprint information on the succeeding page.

9.7.1 Understanding Reprint After Page Break

In some instances, you might need information from one page to appear on the succeeding page. You can define a detail section to reprint the last line of a page as the first line on the succeeding page. Use the Reprint After Page Break option on the Advanced tab of the appropriate section properties form to accomplish this.

Occasionally, the information for a specific level of data continues onto the succeeding page. If you have level break headers defined in the report, the level break header appears on the previous page. You can define the level break header to reprint on the succeeding page using the Reprint After Page Break option on the Advanced tab of the appropriate section properties form.

9.7.2 Prerequisites

Before you begin printing the last line of a page as the first line of the succeeding page, ensure that you:

  • Create a batch application object.

  • Complete the design of the report template using a group or columnar section.

  • Include a level break header in the report.

9.7.3 Reprinting Information on the Succeeding Page

Open a columnar or group section report template that includes a level break header in RDA.

  1. Double-click the group, columnar, or level break header section that you want to affect.

  2. On the appropriate section properties form, select the Advanced tab.

  3. Select the Reprint At Page Break option, and click OK.

9.8 Inserting Page Breaks

This section provides an overview of manual page breaks, lists the prerequisites, and discusses how to insert manual page breaks.

9.8.1 Understanding Manual Page Breaks

You can insert manual page breaks (that is, cause the report to stop printing on the current page and start printing on the next page) after report headers, detail sections, and level break footers. You cannot use the page break feature for all three section types in the same report. However, you can use the page break feature in the report header and level break footer simultaneously.

9.8.2 Prerequisites

Before you begin inserting manual page breaks, ensure that you:

  • Create a batch application object.

  • Complete the design of the report template.

9.8.3 Inserting Manual Page Breaks

Open a report template in RDA.

  1. Double-click the report header, detail section, or level break footer section that you want to affect.

  2. On the appropriate section properties form, select the Advanced tab.

  3. Select the Page Break After option, and click OK.