Go to primary content
Oracle® Application Express Application Builder User's Guide
Release 5.0
E39147-04
  Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
 
Next
Next
 

10.7 Editing Classic Reports in Page Designer

This section describes how developers can edit classic reports. Using the Report Attributes page, developers can control report layout, pagination, column sorting, error messages, export links, and column break of Classic reports.


Tip:

With the addition of interactive reports in Oracle Application Express release 3.1, all previous report types are referred to as classic reports.

10.7.1 Editing Classic Report Attributes in Page Designer

This section describes how to customize a classic report by editing report attributes in Page Designer.

To edit report attributes:

  1. View the page containing the classic report in Page Designer. "Viewing a Page in Page Designer."

    Page Designer appears.

  2. In the Rendering tree, expand the region containing the report and select the Attributes node.

    Description of pd_cl_rpt_att.png follows
    Description of the illustration pd_cl_rpt_att.png

    The Property Editor displays the report attributes.

    Attributes are organized into functional groups. Required attributes display a red triangle in the upper left corner next above attribute label.

  3. Edit the appropriate attributes.


    Tip:

    To control the amount of information that displays, click the Show Common, Show All, Collapse All, and Expand All buttons.

  4. To view Help, select the attribute and click the Help tab. Once you activate the Help pane, the content that displays changes every time you select another attribute.

  5. To save your changes click Save. To save and run the page, click Save and Run Page.

10.7.2 Altering Classic Report Layout in Page Designer

You can use the Column Attributes section of the Report Attributes page to precisely control the report layout. For example, you can use these attributes to alter column heading text, change column positioning, hide a column, create a sum of a column, or select a sort sequence.

To edit the Column Attributes:

  1. View the page in Page Designer. See "Viewing a Page in Page Designer."

    Page Designer appears.

  2. In the Rendering tree, locate the region and expand the Columns node.

    The columns appear in the Rendering tree.

  3. Select a column to edit.

    The Property Editor displays the attributes for that column.

  4. Edit the appropriate attributes.


    Tip:

    To control the amount of information that displays, click the Show Common, Show All, Collapse All, and Expand All buttons.

    Table 10-10 describes common report column edits.

    Table 10-10 Common Report Column Edits for Classic Reports

    Description Developer Action

    Hide a column.

    Under Type, select Hidden Column.

    Edit the column heading text.

    Under Heading, edit Heading and Alignment.

    Change the column heading text alignment.

    Under Heading, make a new selection from Alignment.

    Alter the column display sequence.

    Under Layout, edit Sequence.

    Enable a unique sort sequence.

    Under Sorting, for Sortable click Yes and select a Default Sequence.

    Any number of columns can be sort enabled. However, at least one column must have a Sort Sequence defined.

    Enable the sum of a column.

    Under Advanced, for Compute Sum select Yes.


  5. To view Help, select the attribute and click the Help tab. Once you activate the Help pane, the content that displays changes every time you select another attribute.

  6. To save your changes click Save. To save and run the page, click Save and Run Page.

10.7.3 Controlling Classic Report Pagination in Page Designer

This section describes how to control pagination in a classic report.

10.7.3.1 About Controlling Pagination in a Classic Report

For a classic report, you control report pagination by:

  • Including a pagination substitution string in the report template

  • Making selections from the Layout and Pagination section on the Report Attributes page

You control how pagination displays by making selections from the Pagination attributes on the Report Attributes page.

10.7.3.2 Editing Classic Report Pagination Attributes

To control classic report pagination:

  1. Access the Classic Report Attributes page. See "Editing Classic Report Attributes in Page Designer."

    The Property Editor displays the report attributes in the right column.

  2. Locate and expand Pagination.

  3. Under Pagination, edit the following attributes:

    1. Type - Select the pagination type for this report. Generally only a subset of the results are currently displayed in the report. Pagination provides the user with information about the number of rows and the current position within the result set. Pagination also defines the style of links or buttons that are used to navigate to the next or previous page.

    2. Display Position - Select where the report pagination displays.

    3. Partial Page Refresh - Specify whether to use Partial Page Refresh (PPR) to update the report display.

  4. To view Help, select the attribute and click the Help tab. Once you activate the Help pane, the content that displays changes every time you select another attribute.

  5. To save your changes click Save. To save and run the page, click Save and Run Page.

10.7.4 Enabling Column Sorting in a Classic Report in Page Designer

You enable column sorting on the Report Attributes page.

To enable column sorting:

  1. View the page in Page Designer. See "Viewing a Page in Page Designer."

    Page Designer appears.

  2. In the Rendering tree, locate the region and expand the Columns node.

    The columns appear in the Rendering tree.

  3. Select a column to edit

    The Property Editor displays the attributes for that column.


    Tip:

    To control the amount of information that displays, click the Show Common, Show All, Collapse All, and Expand All buttons.

  4. Locate and expand Sorting. Edit the following attributes:

    1. Default Sequence - Select the sort sequence for this column. Each column should have a unique sequence to correctly order the report output.

    2. Sortable -To enable sorting, select Yes. Selecting Yes enables the end user to sort this column in the report.

  5. Specify ascending and descending image attributes or click set defaults.

  6. To save your changes click Save. To save and run the page, click Save and Run Page.


Tip:

Column sorting must be enabled if you want columns with null values to display at the top or end of the report. To learn more about the Sort Nulls attribute, see "Controlling Classic Report Pagination".

10.7.5 Adding a Download Link to a Classic Report in Page Designer

You can create a link within a report that enables users to export the report as a comma-delimited file (.csv) file. To add a CSV link to a report you must enable the CSV output option. When using the CSV output option, the report template is not important. You can include a CSV link with any report template that has the CSV export substitution string defined.

10.7.6 Enabling Classic Report CSV Output Option in Page Designer

To use the enable the CSV output option:

  1. Access the Classic Report Attributes page. See "Editing Classic Report Attributes in Page Designer."

    The Property Editor displays the report attributes in the right column.

  2. Locate and expand Download.


    Tip:

    To control the amount of information that displays, click the Show Common, Show All, Collapse All, and Expand All buttons.

  3. Under Download, edit the following attributes:

    1. CSV Export Enabled - Specify whether end users can download the report contents to a CSV file. To enable CSV Downloads, you must use a report template with a #CSV_LINK# substitution string and set this option to Yes.

    2. CSV Separator - Enter a column separator. If no value is entered, a comma or semicolon is used depending on your current NLS settings.

    3. CSV Enclosed By - Enter a delimiter character to delineate the starting and ending boundary of a data value. The default delimiter is double quotation marks.

    4. Link Text - Specify the text for the link to invoke the CSV download.

    5. Filename - Specify a name for the CSV download file. If no name is specified, the region name is used followed by the extension *.csv.

  4. To save your changes click Save. To save and run the page, click Save and Run Page.

10.7.7 Adding Support for XML File or a CSV File Export in Page Designer

You can add support for exporting a report as an XML or CSV by selecting a report template.

To export a report as a file:

  1. Access the Classic Report Attributes page. See "Editing Classic Report Attributes in Page Designer."

    The Property Editor displays the report attributes in the right column.

  2. Locate and expand Appearance.


    Tip:

    To control the amount of information that displays, click the Show Common, Show All, Collapse All, and Expand All buttons.

  3. Under Appearance, edit the following:

    1. Template Type - Select Predefined.

    2. Template - Select XML or CSV.

      Selecting XML prevents the Application Express engine from rendering the page and dumps the content to an XML file.

  4. To save your changes click Save. To save and run the page, click Save and Run Page.

10.7.8 Creating a Column Link in a Classic Report in Page Designer

Use the Column Link attributes to create a link from a report to another page in your application or to a URL.

To create a column link to another page:

  1. View the page in Page Designer. See "Viewing a Page in Page Designer."

    Page Designer appears.

  2. In the Rendering tree, locate the region and expand the Columns node.

    The columns appear in the Rendering tree.

  3. Select a column to edit

    The Property Editor displays the attributes for that column.

  4. Locate and expand Identification. From Type, select Link.

  5. Locate and expand Link and click No Link Defined.

    The Link Builder - Target dialog appears.

  6. To create a link to another page, in the Link Builder - Target dialog:

    1. Type - Select Page in this Application.

    2. Page - Specify the target page number.

    3. Set Items - Select a Name and Value to specify session state for an item.

    4. Clear Session State, Clear Cache - Specify the page numbers on which to clear cache. To specify multiple page, enter a comma-delimited list of page numbers.

    5. Rest Pagination - Select Yes to reset pagination for this page.

    6. Advanced, Request - Specify the request to be used.

    7. Click OK.

  7. To create a link to a URL, in the Link Builder - Target dialog:

    1. Type - Select URL.

    2. URL - Enter the URL address.

    3. Click OK.

  8. To save your changes click Save. To save and run the page, click Save and Run Page.

10.7.9 Defining an Updatable Column in a Classic Report in Page Designer

You can make a column updatable by editing Tabular Form Element attributes on the Column Attributes page. Note that the Application Express engine can only perform updates if:

  • A multirow update is defined.

  • A PL/SQL process is implemented to process updated data.

  • When using the built-in tabular form elements and display types, then the report has to be defined using the type SQL Query (updatable report).

To define updatable column attributes:

  1. View the page in Page Designer. See "Viewing a Page in Page Designer."

    Page Designer appears.

  2. In the Rendering tree:

    1. Locate the region containing the report or tabular form.

    2. Expand the Columns node.

    3. Select the column to be updated.

  3. In the Property Editor, expand Identification and edit the Type attribute.

    To learn more, see field-level Help.

  4. To save your changes click Save. To save and run the page, click Save and Run Page.

10.7.10 Defining a Column as a List of Values in a Classic Report in Page Designer

A column can be rendered as Radio Group or a static, named, or query-based LOV. For example, a column can be rendered using a select list or a popup list of values. Or, a column can be rendered as read-only text based on a list of values.

This last approach is an effective strategy when creating display lookup values and is particularly useful in regular, nonupdatable reports. This approach enables you to display the value of a column without having to write a SQL JOIN statement.

To render a report column as a list of values:

  1. View the page in Page Designer. See "Viewing a Page in Page Designer."

    Page Designer appears.

  2. In the Rendering tree:

    1. Locate the region containing the report or tabular form.

    2. Expand the Columns node.

    3. Select the column to be updated.

  3. In the Property Editor, expand Identification and change the Type to Plain Text (based on List of Values.

  4. Expand List of Values and select a Type and fill in the appropriate fields.

    To learn more, see field-level Help.

  5. To save your changes click Save. To save and run the page, click Save and Run Page.

10.7.11 Controlling When Classic Report Columns Display in Page Designer

You can use the Authorization and Condition attributes to control when a column displays.

Authorization enables you to control access to resources (such as a report column) based on predefined user privileges. For example, you could create an authorization scheme in which only managers can view a specific report column. Before you can select an authorization scheme, you must first create it.

A condition is a small unit of logic that enables you to control the display of a column based on a predefined condition type. The condition evaluates to true or false based on the values you enter in the Expressions fields.

To specify Authorization and Condition attributes:

  1. View the page in Page Designer. See "Viewing a Page in Page Designer."

    Page Designer appears.

  2. In the Rendering tree, locate and select the region containing the report.

    The region attributes display in the Property Editor.

  3. If controlling a column with an authorization scheme, select an authorization scheme:

    1. Locate and expand Security.

    2. Authorization Scheme - Make a selection.

  4. If controlling the column with a condition define a condition, define a condition:

    1. Locate and expand Conditions.

    2. Type - Make a selection.

    3. Depending upon your selection, enter an expression or value in the fields provided.

    If the authorization is successful and the condition type display evaluates to true, the column displays.

  5. To save your changes click Save. To save and run the page, click Save and Run Page.

10.7.12 Controlling Classic Report Column Breaks in Page Designer

You can control if a specific column repeats and how column breaks appear when printed using Break Formatting attributes. For example, suppose your report displays employee information by department number. If multiple employees are members of the same department, you can increase the readability by specifying that the department number only appears once.

To create this type of column break:

  1. View the page in Page Designer. See "Viewing a Page in Page Designer."

    Page Designer appears.

  2. In the Rendering tree, locate the region and expand the Columns node.

    The columns appear in the Rendering tree.

  3. Select a column to edit.

    The Property Editor displays the attributes for that column.

  4. Specify Break Formatting:

    1. Locate and expand Break Formatting.

    2. For Break Columns, select how many report columns are incorporated into the break formatting. The columns must be consecutive columns, starting from the first column displayed in the report.

  5. To save your changes click Save. To save and run the page, click Save and Run Page.