Oracle Reports

Report:

      A report is a collection of objects that defines its data, layout and interface at runtime.

Oracle Reports Environment Variables:

      REPORTS60_PATH
      UI_ICON
      ORACLE_PATH

      Windows NT/95: modify in Registry

Parameters are Two Types:

  • System Parameters
  • User-Defined Parameters

System Parameters:

  1. Background
  2. Copies
  3. Currency
  4. Decimal
  5. Thousands
  6. Desformat
  7. Desname
  8. Destype
  9. Mode
  10. Orientation
  11. Printjob

System Parameters Purpose:

System Parameter PurposeDefault Value Value
COPIES Is the number of report copies that should be made when the report is printed. Taken from the Initial Value property of the COPIES parameter. Any valid integer from 1 through 9,999.
DECIMAL Is the symbol for the decimal indicator (e.g., "."). The default for ORACLE is determined by the ORACLE National Language Support facilities. You can also set a default in the Initial Value property for the DECIMAL parameter. Any valid alphanumeric character.
DESFORMAT Is the definition of the output deviceís format (e.g., landscape mode for a printer). This parameter is used when running a report in a character-mode environment, and when sending a bitmap report to a file (e.g. to create PDF or HTML output). Taken from the Initial Value property of the DESFORMAT parameter. For bit-mapped Report Builder, ifDESFORMAT is blank or dflt, then the current printer driver (specified in File Choose Printer) is used.If nothing has been selected in Choose Printer, then Postscript is used by default. PDF
HTML
HTMLCSS
HTMLCSSIE
RTF
DELIMITED
DESTYPE Is the type of device to which to send the report output (screen, file, mail, printer, or screen usingPostScript format). Taken from the Initial Value property of the DESTYPE parameter. FILE,
PRINTER,
SCREEN,
MAIL,
PERVIEW.
DESNAME Is the name of the output device (e.g., the file name, printerís name, mail userid). Taken from the Initial Value property of the DESNAME parameter. If DESTYPE=FILE and DESNAME is an empty string, it defaults to report name at runtime. Any valid filename, printer name, or email ID not to exceed 1K in length. For printer names, you can optionally specify a port. For example:
DESNAME=printer,LPT1:
DESNAME=printer, FILE:
MODE Is whether the report should run in character mode or bitmap.
ORIENTATTION Is the print direction for the report (landscape, portrait, default). Default Default Landscape,Portrait
THOUSANDS Is the symbol for the thousandís indicator (e.g., ","). The default for ORACLE is determined by the ORACLE National Language Support facilities. You can also set a default of up to four characters in the Initial Value property of the THOUSANDS parameter. Any valid alphanumeric character.
BACKGROUND Is whether the report should run in the foreground or the background.
CURRENCY Is the symbol for the currency indicator (e.g., "$").
PRINTJOB Is whether the Print Job dialog box should appear before the report is run.

Report Types:

  • Tabular
  • Form like
  • Form Letter
  • Mailing Label
  • Group Above
  • Group Left
  • Matrix
  • Matrix with Group

Tabular:

      It is most basic type of report where each column corresponds to a column selected from the database.

Form-like:

      It is a report one record per page. The field values are placed to the field labels.

Mailing Label:

      A Mailing label report prints mailing labels in multiple column on each page. The printing can be a Landscape or a Portrait.

Form Letter:

      A Form Letter reports contains database values embedded into any text that is entered or imported into the report editor.

Group Left:

      A Group Left report divides the rows of a table into sets, based on a common value in each of the columns. This style is used to restrict a column from repeating the same value several times while values of related columns change.

Group Above:

      A Group Above report contains two or more groups of data. For every value of the master group, the related values of the detail group(s) are fetched from the database.

                                                                                                                                                 Next