Browser Detection Script checks if Internet Explorer 5.5 is being used and adjusts the font size if it is.
Help Contents

SQL-based Reports: Column Formatting

| Field Descriptions | Related Help Topics | Additional Information |

Use this page to choose options that control report column formatting on a column-by-column basis.

Go to topField Descriptions

 

Field Description
Column Displays the table or view columns you specified in the SQL Query step.
Column Heading Text Enter the heading name you want to use to identify the column in the report. For example, instead of displaying the table column named EMPNO in the report, you could specify the more descriptive Employee ID Number as column heading text.
Sum Select to sum values within the column and display the results in the report.
Note: This option is valid only for columns containing numeric data.
Type Displays the datatype of the data in the selected column.
Align Choose whether to align data to the left, center, or right margin of a report column. By default, numeric data align to the right, and alphabetical data align to the left.
Display as

Choose Text, HTML or Hidden:

  • Text--Displays the value in the report without interpreting any associated HTML tags. For example, the value <i>Name</i> is displayed as <i>Name</i>.
  • HTML--Displays the value in the report using associated HTML tags. For example, the value <i>Name</i> is displayed as Name.
  • Hidden--Does not display the value in the report. For example, choose Hidden for columns whose values are for link parameters that you do not want displayed in the report.
Format Mask

Enter an Oracle display format for columns containing date and numeric datatypes.

Examples:

Sample Date Format Date Displayed
MM/DD/RR 03/04/85
Mon. DD, RRRR Mar. 4, 1985
Day Month DD fmHH:MI AM Monday March 4 11:35 PM
Dy Mon ddth fmHH24:MI:SS Mon Mar 4th 23:35:22
Day "the" ddthsp "of" Month Monday the fourth of March

Sample Number Format Number Number Displayed
-0000 7934
-7934		 "7934"
"-7934"
-00000 7934 "07934"
-NNNN 7639
535		 "7639"
"535"
+NNNN 100
-99		 "100"
"-99"
-%NN 10 "%10"
 $<NNNNN.00> 120014 " $1200.14"
+KKNNNNN.00 1950 "+ 1950.00"
$<NNNNN.00> 1200
400		 "$ 1200.00"
"$ 400.00"

The quotation marks in the above table will not appear in your output. They are used here to make it clear where there are leading or trailing spaces.

See the Oracle Application Server documentation for additional information about using format masks.

Note: You cannot use format masks in reports generated in Excel format.
Link

Choose a link for the column to another OracleAS Portal portlet. Values in the column will appear as hypertext in the report.

Note: You can specify a link only if one has been created for this column and stored in the database.
Edit Link Click to display the Set Link Parameters window, where you can set the values of the link parameters to pass to the target portlet. You can enter a static value (for example; 10, KING), or select from the LOV of columns you selected in the Table or View Columns step. If you need the value of a column for the link parameter but do not want the column displayed in the report, you can set the value of Display as to Hidden.
Column Width Enter the numeric value for the width type.
Width Type

Specify Char, Pixel, or Percent:

  • Char--Displays the output in the specified number of characters per line. For example, if you enter 20 in Width, the report displays 20 characters of the column data in each line. If the number of characters per line exceeds the specified number, the remaining characters are wrapped to the next line.

    Note: If the output is ASCII format, Char is based on the column width.

  • Pixel--Displays the output in the specified number of pixels per row. For example, if you enter 10 in Width, the column data displays 10 pixels of data per line of the displayed table.
  • Percent--Displays the output in the specified percentage of the table. For example, if you enter 25 in Width, the column data displays in 25% of the displayed table.

Notes

Go to topRelated Help Topics

Next Steps:

Go to topAdditional Information

On Portal Center:

Oracle Logo
Copyright © 2004, Oracle. All rights reserved.