Edit Column attributes to precisely control the report layout.

To edit the Column attributes:

1. View the page in Page Designer:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
2. In the Rendering tab, locate the region and expand the Columns node.
   The columns appear in the Rendering tab.
3. Select a column to edit.
4. Edit the appropriate attributes in the Property Editor. Attributes are organized in groups.

   Tip:

   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.

   The following table describes common ways to edit report columns.

   Table 8-1 Common Report Column Edits for Classic Reports

   Description	Developer Action
   Hide a column.	Find Identification. For Type, select Hidden.
   Edit the column heading text.	Find Heading. Edit the Heading and Alignment attributes.
   Change the column heading text alignment.	Find Heading. Under Heading, make a new selection from Alignment.
   Alter the column display sequence.	Find Layout. Edit the Sequence attribute.
   Enable a unique sort sequence.	Find Sorting. For Sortable, select On 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.	Find Advanced. For Compute Sum, select On.

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

Learn how to enable column sorting.

To enable column sorting:

1. View the page in Page Designer:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
2. In the Rendering tab, locate the region and expand the Columns node.
   The columns appear in the Rendering tab.
3. Select a column to edit.
   The Property Editor displays the attributes for that column. Attributes are organized in groups.
4. Find Sorting.
5. Under Sorting, edit the following:
   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 On. Selecting On enables the end user to sort this column in the report.
6. To save your changes click Save. To save and run the page, click Save and Run Page.

Use 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:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
2. In the Rendering tab, locate the region and expand the Columns node.
   The columns appear in the Rendering tab.
3. Select a column to edit.
   The Property Editor displays the attributes for that column. Attributes are organized in groups.
4. Find Identification. From Type, select Link.
5. Find 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/Reset, Clear Cache - Specify the page numbers on which to clear cache. To specify multiple pages, enter a comma-delimited list of page numbers.
   5. Clear/Reset, Action - Select one of the following:

      • None - No clear or reset action when page loads.

      • Clear Regions - Clears all region settings on the page.

      • Reset Regions - Resets all regions on the page back to the default state, including sort orders, hidden columns and so on.

      • Reset Pagination - This option enables backwards compatibility.

   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.

Make a column updatable by editing column attributes.

To define updatable column attributes:

1. View the page in Page Designer:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
2. In the Rendering tab, locate the region and expand the Columns node.
   The columns appear in the Rendering tab.
3. Select a column to edit.
   The Property Editor displays the attributes for that column. Attributes are organized in groups.
4. In the Property Editor, find Identification and edit the Type attribute.
5. To save your changes click Save. To save and run the page, click Save and Run Page.

Render a report column as a list of values.

To render a report column as a list of values:

1. View the page in Page Designer:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
2. In the Rendering tab, locate the region and expand the Columns node.
   The columns appear in the Rendering tab.
3. Select a column to edit.
   The Property Editor displays the attributes for that column. Attributes are organized in groups.
4. Find Identification. From Type, select Plain Text (based on List of Values).
5. Find List of Values. Select a Type:
   • Shared Component - Creates a list of values based on a predefined list of values defined in Shared Components.
   • SQL Query - Creates a dynamic list of values based on the SQL Query you provide.
   • Static Values - Creates a static list of values is based on the text value you provide.
   • PL/SQL Function Body returning SQL Query - Creates a dynamic list of values is based on the SQL Query returned by the entered PL/SQL Function Body you provide.
6. The UI changes based on the List of Values, Type you select. Fill in all required attributes (identified in red).
7. To save your changes click Save. To save and run the page, click Save and Run Page.

Control when a column displays using an Authorization Scheme and Server-side Condition.

1. View the page in Page Designer:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
2. In the Rendering tab, locate the region and expand the Columns node.
3. Select a column to edit.
   The Property Editor displays the attributes for that column. Attributes are organized in groups.
4. If controlling a column with an authorization scheme, select an authorization scheme:
   1. Find Security.
   2. Authorization Scheme - Make a selection.
5. If controlling the column with a condition define a condition, define a condition:
   1. Find Server-side Condition.
   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.
6. To save your changes click Save. To save and run the page, click Save and Run Page.

Create a link within a report to enable users to export the report as a comma-delimited file (.csv) file.