Skip Headers

Oracle® Reports Building Reports 10g Release 2 (10.1.2) B13895-01 |
| Library | Product | Contents

Previous |

# Index

A B C D E F G H I J K L M N O P Q R S T U V W X

## A

  across break report, 12
  administering Reports Builder, 3.16
  after form escape, 2.2.10
  After Form Value property, 1.9.4
  after page escape, 2.2.10
  AFTER PARAMETER FORM trigger
    using with SRW.SET_FORMAT_ORDER, 35.2.3, 36.3
  After Parameter Form trigger, 2.6.13.1
  after report escape, 2.2.10
  After Report trigger, 2.6.13.1
  aggregating data report, 30
  aligning objects, 3.9.11.6
  alternate pages, displaying object, 3.9.2.2
  alternating row colors, 3.9.6.9, 44.2.5
  anchors
    about, 2.4.4
    collapsing, 2.4.4
    explicit, 2.4.4
    implicit, 2.4.4
    working with, 3.9.5
  application command line link, 3.6.10.1.9
    about, 2.2.9
    using PL/SQL, 3.6.10.2.9
  application program interface (API), 3.1.2
  archiving report, 3.3.7
  ASCII report, 2.8.15, 3.2.5, 3.5.9
  attached library
    about, 2.6.7
    attaching, 3.13.5.5
    removing program unit, 3.13.5.4
  attributes
    template, 3.12.2, 3.12.3, 3.12.5

## B

  B_OR$REPORT_TITLE, 2.1.1, 3.12.5
  barcode
    creating using barcode font, 3.9.1.4
    in a paper report, 42.2
    in Web report, 42.3
    JavaBean, initializing, 42.3.3
  batch mode
    about, 2.8.2
    passing parameters, 3.11.9
  before form escape, 2.2.10
  Before Form Value property, 1.9.4
  before page escape, 2.2.10
  Before Parameter Form trigger, 2.6.13.1
  before report escape, 2.2.10
  Before Report trigger, 2.6.13.1
  Between Pages trigger, 2.6.13.1
  bind reference
    about, 2.3.4.1
    vs. lexical, 2.3.4.3
  blank lines
    between groups of rows, 3.9.13.5
  body
    template, 3.12.8
  boilerplate
    about, 1.8.5
    creating for HTML tags, 3.9.2.3
    creating for text, 3.9.2.1, 3.9.2.2
    Parameter Form, about, 1.9.3
  bookmark, 3.6.10.1.10
    on break columns, 3.6.10.1.11
    using PL/SQL, 3.6.10.2.10
  borders
    adjusting when moving objects, 3.9.11.3
    resizing, 3.9.12.3
    working with, 3.9.4
  break column
    multiple in group report, 10.3
    single in group report, 10.2
  break group
    about, 1.7.2
    adding column, 10.3.1
    creating, 3.8.7
    data model, 10.2.1
    in nested matrix report, 26
    multiple in group report, 10.4
  break report, 10
    across, 12
    wrapped, 15
  breakpoints
    about, 2.10.5
    setting, 3.14.3
  built-in package
    about, 2.6.12
    SRW, 2.6.12.1
    Tools, 2.6.12.2
    using, 3.13.1
  bursting
    about, 37
    report, 37.2

## C

  call interface, 2.9.4
  cascading style sheets, 2.2.11
  cash amounts, spelled out, 4.5.4
  cell group, 3.8.8
  cell wrapper, 3.7.10
  Change View, 3.4.4
  character-mode report, 2.8.15, 3.2.5, 3.5.9
  check printing report, 4.5.4
  child object
    anchoring, 2.4.4
    moving outside parent, 3.9.11.2
  client-side
    moving program unit to, 3.13.3.4
    program unit, creating, 3.13.3.1
  color
    row in report, 3.9.6.9
  color palette, 3.2.6
    importing or exporting, 3.9.6.6
    modifying, 3.9.6.5
    preferences, 3.2.6
  colors
    about changing, 2.4.5
    alternating row colors, 44.2.5
    changing, 3.9.6.2
    changing using PL/SQL, 3.9.6.4
    color palette, 3.2.6
    in templates, 2.4.5
    using in report, 18
    working with, 3.9.6
  column
    adding to break group, 10.3.1
    changing labels or widths, 3.9.13.1
    database, 1.7.3
    formula, 3.8.10
    linking, 3.8.9
    moving, 3.9.11.4
    placeholder, 3.8.12
    referencing, about, 2.3.4
    summary, 3.8.11
  Column Mode property, 2.4.1
  columns
    graphics and images, 1.7.3, 3.8.5, 3.8.6, 3.9.8.1.1
  command file, 3.7.3
  command line, 3.7.2
  compiling
    program units, 3.13.6
  conditional form letter report, 22, 22, 22
  conditional formatting
    about, 2.1.6
    applying to object, 3.9.1.5
  Confine mode, 3.9.4.3, 3.9.11.2, 3.9.11.7
  connecting to database, 3.3.1
  converting
    report, format, 3.16.2
  COPIES system parameter, 1.9.1
  copying report, 3.3.4
  cross product group, 25
  cross-product group
    creating, 3.8.8
  cross-product groups
    about, 1.7.2
  cross-product report
    about, 1.3.7
  currency, spelled out, 4.5.4
  custom format mask, 3.9.7.5

## D

  data
    filtering, 44.2.6
  Data Definition Language, 2.6.11
  data link, 11
    about, 1.7.4
    creating, 3.8.9
    non-linkable query, 2.3.5
    vs. groups, 2.3.6
  Data Manipulation Language, 2.6.11
  data model
    break group, 10.2.1
    objects, about, 1.7, 2.3
    working with, 3.8
  Data Model view
    about, 1.6.2
  data sources, Preface
    non-Oracle, accessing, 3.15.2
  data within ranges report, 30
  Data Wizard
    about, 1.4.3
    creating query, 3.8.1.2
    glossary, Glossary
  database
    connecting, 3.3.1
    selecting HTML tags, 3.8.4
    selecting image, 3.8.5
    trigger, creating, 3.13.3.7
  database column, 1.7.3
  Database Objects node, 2.6.2
  database role
    about, 2.9.1
    setting, 3.16.1
  database trigger
    about, 2.6.13.4
    creating, 3.13.3.7
  database values
    in header, 3.9.9.2, 17
  date format masks, 3.9.7.1
  date format, in graphs, 1.4.4
  date/time stamps, 3.9.3
  DDE built-in package, 2.6.12.2
  DDL, 2.6.11
  debug actions
    about, 2.10.5
    working with, 3.14.5
  DEBUG built-in package, 2.6.12.2
  debug level
    about, 2.10.8
  debug mode, 3.14.2
  debug trigger
    about, 2.10.5
  debug trigger, setting, 3.14.4
  debugging report, 3.14
  debugging tools, 2.10
  default format masks, 3.9.7.5
  default layout
    creating, 3.5.4
    section, 3.10.2
  default layout spacing, 3.9.13.3
  Default node, 2.7.2
  default Parameter Form, 3.11.5
  define
    defining an OLAP connection, 46.2.2
  deleting
    program unit, 3.13.3.3
  deleting object, 3.3.9
  deleting report, 3.3.6
  delimited output
    about, 2.8.12
    generating, 3.7.10, 3.7.11
  deploying report, 3.7.13
  deprecated functionality, 3.1.2
  DESFORMAT system parameter, 1.9.1
  DESNAME system parameter, 1.9.1
  DESTINATION keyword, 2.8.3.1
  destinations, 2.8.4
  DESTYPE system parameter, 1.9.1
  dimensions, report, 2.1.4
  direction
    for reading text, changing, 3.9.2.9
  dispatching report, 3.7, 3.7.1, 3.7.2, 3.7.3, 3.7.4
  DISPLAY dependency, 3.7.17.6
  DISPLAY environment variable, 3.7.17.6
  distributing
    report, 3.7.12
  distribution
    about, 2.8.3, 37
    DESTINATION keyword, 2.8.3.1
    DST file, 2.8.3.1
    editing XML definition, 37.3
    example report, 37
    report, tracing, 3.14.19
  DML, 2.6.11
  docroot, 2.2.2
  document root directory, 2.2.2
  dollar amounts, spelled out, 4.5.4
  drawing
    importing, 3.9.8.1.1
  drawing object, 3.9.8.5
  DST file
    about, 2.8.3.1

## E

  editing
    program unit, 3.13.2.3
  e-mailing report, 3.7.18
  escape
    before and after, 2.2.10
  event-driven publishing
    about, 2.8.5
  examples and demos, 3.1.2
  EXEC_SQL built-in package, 2.6.12.2
  executablesr
    about, 1.12
  execution
    report, tracing, 3.14.18
  execution location
    current, about, 2.10.6
  explicit anchors, 2.4.4
  Express Server, 47.1
    integrating with Express PDS, 3.15.3
  Express Server Query tool, 3.8.1.7
  external PL/SQL library
    about, 2.6.6
    adding program unit, 3.13.5.2
    attaching, 3.13.5.5
    converting, 3.13.5.6
    creating, 3.13.5.1
    editing program unit, 3.13.5.3
    removing program unit, 3.13.5.4
    working with, 3.13.5

## F

  field
    about, 1.8.4
    changing format mask, 3.9.7.6
    creating, 3.9.1.1
    Parameter Form, about, 1.9.2
    referencing, 3.9.2.5
  fields
    intermixed in report, 20
  file
    linking from HTML object, 3.9.2.7
  File Link tool, 3.9.2.6, 3.9.2.7
  Fill Color tool, 2.4.5
  filter
    about, 1.7.2
    group, creating or editing, 3.13.4.2
  Flex mode, 3.9.4.3, 3.9.11.3, 3.9.11.4, 3.9.11.5
  font
    changing, 3.9.2.9
  fonts
    about, 2.1.5
    applying different, 18
    barcode, 3.9.1.4
    changing, 3.9.2.9
  footer
    group, 3.9.9.3
  footer and header report, 16
  footer, document
    HTML, 2.2.3, 3.6.10.1.2, 3.6.10.2.2
  footer, page
    HTML, 2.2.3, 3.6.10.1.4, 3.6.10.2.4
  footer, Parameter Form
    HTML, 2.2.3, 3.6.10.1.6, 3.6.10.2.6
  footers, 3.9.9
  foreign key, 11
  form
    report on preprinted, 32
  form letter report
    about, 1.3.5
    conditional, 22, 22, 22
  format exceptions, 2.1.6
  format masks
    working with, 3.9.7
  format order, 2.8.1
  Format Order property, 2.8.1, 3.5.7
  format trigger
    about, 2.6.13.2
    creating, 3.13.4.1, 35.2.3, 36.3
    layout objects, 2.4.1
  formatting, HTML, 2.8.8, 2.8.9
  form-like report
    about, 1.3.4
  formula column, 14
    about, 2.3.2, 2.6.8
    creating or editing, 3.8.10
    formula for, 2.6.8
    vs. summary column, 14
  formula report, 14
  frame
    about, 1.8.1
    creating, 3.9.1.2
    sizing, 1.8.3
  frequency
    layout object, 2.4.1
  functionality

## G

  Global Variables node, 3.14.16
  graph
    date fomat, 1.4.4
    graph hyperlink, 2.2.3, 2.2.4, 2.2.6, 3.9.8.4
    paper report, 3.9.8.2.1, 3.9.8.3.1
    Web report, 3.9.8.2.2, 3.9.8.3.2
  graph hyperlink
    about, 2.2.6
    adding, 3.9.8.4
  Graph Wizard, 3.9.8.2.1
    about, 1.4.4
    glossary, Glossary
  graphic objects, 3.9.8
  graphics
    adding to report, 18
  group
    creating break, 3.8.7
    creating matrix, 3.8.8
    header or footer, 3.9.9.3
    linking, 3.8.9
    vs. data link, 2.3.6
  group above report, 11
    about, 1.3.2
    building, 11
    with matrix, 27
  group filter
    about, 1.7.2, 2.6.9
    creating or editing, 3.13.4.2
    vs. Maximum Rows to Fetch property, 2.6.9
  group left report, 10
    about, 1.3.3
    with header and footer, 16
  group left summary report, 13
  group report
    grouped in middle, 20
    offsetting detail fields, 3.9.11.5
    single-query, 10
    two-query, 11
  groups
    about, 1.7.2

## H

  header
    group, 3.9.9.3
    page and group, working with, 3.9.9
    report, 3.9.9.1
  header and footer report, 16
  header page
    creating object in, 3.9.10.2
  Header Section, 3.10.1
  header with database values report, 3.9.9.2, 17
  header, document
    HTML, 2.2.3, 3.6.10.1.1, 3.6.10.2.1
  header, page
    HTML, 2.2.3, 3.6.10.1.3, 3.6.10.2.3
  header, Parameter Form
    HTML, 2.2.3, 3.6.10.1.5, 3.6.10.2.5
  heading, 17.4, 17.4
    report, 3.9.9.1
  Height property, 2.1.4
  hierarchy
    in Object Navigator, 3.4.4
  highlighting
    boilerplate, 18
    row in report, 3.9.6.8
    value in report, 3.9.6.7
  Horizontal Gap, 3.9.13.3
  Horizontal Interfield, 3.9.13.3
  Horizontal Panels per Page property, 2.1.4
  HTML
    font sizes, 2.8.8
    formatting, 2.8.8, 2.8.9
    in boilerplate text, 3.9.2.3
    in Reports Builder, about, 2.8.8
    including image URL, 3.8.6
    linking object to file, 3.9.2.7
    output, 2.8.8, 3.7.5
    paginating output, 2.8.8.1, 3.6.10.2.11, 3.7.16.5
    pagination, 2.8.8
    Parameter Form extensions, 2.5.1
    selecting tags from database, 3.8.4
    style sheets, 2.2.11
  HTML document footer, 2.2.3, 3.6.10.1.2
    using PL/SQL, 3.6.10.2.2
  HTML document header, 2.2.3, 3.6.10.1.1
    using PL/SQL, 3.6.10.2.1
  HTML page footer, 2.2.3, 3.6.10.1.4
    using PL/SQL, 3.6.10.2.4
  HTML page header, 2.2.3, 3.6.10.1.3
    using PL/SQL, 3.6.10.2.3
  HTML page-streamed output, 3.6.10.1.12
  HTML Parameter Form
    changing input to uppercase, 3.11.13
    creating field with events, 3.11.12
  HTML Parameter Form footer, 2.2.3, 3.6.10.1.6
    using PL/SQL, 3.6.10.2.6
  HTML Parameter Form header, 2.2.3, 3.6.10.1.5
    using PL/SQL, 3.6.10.2.5
  HTMLCSS
    output, 3.7.5
  Human Resources schema, Preface
  hyperlink, 3.6.10.1.8
    about, 2.2.5
    graph, 2.2.3, 2.2.4, 2.2.6, 3.9.8.4
    using PL/SQL, 3.6.10.2.7
  hyperlink destination, 3.6.10.1.7
    about, 2.2.7
    PL/SQL, 3.6.10.2.8

## I

  image
    about, 2.4.3
    adding to report, 18
    image column, 3.8.5, 3.8.6
    importing, 3.9.8.1.1
    in JSP-based Web report, 3.8.5, 3.8.6
    selecting from database, 3.8.5, 3.8.6
  image objects, 3.9.8
  images
    image column, 1.7.3, 3.9.8.1.1
  implicit anchors, 2.4.4, 3.9.5.2
    algorithm, 2.4.4.1
  importing
    drawing or image, 3.9.8.1.1
    SQL query, 3.8.1.3
  index
    creating, 3.5.8
    creating for a report, 35.3
  intermixed fields report, 20

## J

  Java classes
    importing, 42.2.1
  Java Database Connectivity (JDBC), 3.15.2
  Java importer, 42.2.1
  JavaBean
    importing, 42.2.1
    using for a Web report, 42.3
    using in a paper report, 42.2
  JavaServer Pages (JSPs)
    about, 2.2.1
  JDBC, 3.15.2
  JDBC Query tool, 3.8.1.5
  JDBC-ODBC bridge, 3.15.2
  JNI built-in package, 2.6.12.2
  join, 11
  JSP
    about, 2.2.1
  JSP Parameter Form, 41
  JSP-based Web report, 41
  justification
    changing, 3.9.2.9

## K

  Keep With Anchoring Object property, 2.4.1

## L

  label
    changing, 3.9.13.1
  landscape orientation, 3.7.14
  layering objects, 3.9.11.7
    about, 2.4.7
  layout
    additional, 3.5.5
    default spacing, 3.9.13.3
    default, creating, 3.5.4
    default, section
      section, 3.10.2
    modifying, 3.9.14
    multiple, 13.4
    objects, about, 1.8, 2.4
    working with, 3.9
  layouts
    merging, 13.5
  lexical reference
    about, 2.3.4.2
    vs. bind, 2.3.4.3
  library
    adding program unit, 3.13.5.2
    attached, 2.6.7
    attaching, 3.13.5.5
    converting, 3.13.5.6
    creating, 3.13.5.1
    editing program unit, 3.13.5.3
    external PL/SQL, 2.6.6
    removing program unit, 3.13.5.4
  Line Color tool, 2.4.5
  link
    about, 1.7.4
    creating, 3.8.9
  linking
    boilerplate text object to file, 3.9.2.6
    data links vs. groups, 2.3.6
    image object, 3.9.8.1.3
    query, non-linkable, 2.3.5
  linking tables, 11
  links
    creating between ref cursor queries, 40.5
  LIST built-in package, 2.6.12.2
  list of values (LOV)
    creating for parameter, 3.11.3
  logical page, 2.1.4
  LONG column, 1.7.3
  LONG RAW column, 1.7.3

## M

  magnifying output, 3.7.16.8
  mailing label report, 6
    about, 1.3.6
  Main Section, 3.10.1
  margin
    adjusting, 3.9.14.1
    creating object in, 3.9.10.1
    template, 3.12.7
  master/detail query
    creating, 36.4
  master/detail report, 10
  master/detail/summary report, 13
  master/master report, 8
  matrix
    layout, 1.3.7.2
  matrix data model
    considerations, 1.3.7.1
  matrix group
    creating, 3.8.8
  matrix object, 1.3.7.2.1
    about, 2.3.7
    creating in layout, 3.9.1.3
  matrix report, 25
    about, 1.3.7
    nested, 26
    with group, 2.1.8, 27
  matrix with group report, 27
    about, 2.1.8
  Maximum Rows to Fetch property, 2.6.9
  mode
    Confine or Flex, 3.9.4.3
  MODE system parameter, 1.9.1
  moving objects, 3.9.11
    about, 2.4.7
  multiple destinations
    distributing to, 37
    report output, 3.7.12
  multiple layouts, 13.4
  multiple objects
    making same size, 3.9.12.2
    moving, 3.9.11.1
  multiple platforms, 3.5.10
  multiple queries, 11
    about, 1.7.1
    linking, 11
    linking, about, 1.7.4
    master/master report, 8
  multiquery reports, 1.7.1

## N

  National Language Support (NLS), 3.5.11
  navigation controls
    about, 2.8.8.1
    using PL/SQL, 3.6.10.2.11
    using properties, 3.6.10.1.12
  nested matrix report
    about, 2.1.7
  Net8, 2.9.2
  new features, 3.1.2
  node
    in Object Navigator, 3.4.2
  non-linkable query
    about, 2.3.5
  non-Oracle data sources
    accessing, 3.15.2
  number format masks, 3.9.7.2
  numbering pages
    renumbering by repeating frame, 4.5.6

## O

  OALP query
    defining the connection using Connection Editor, 46.2.2
  Object Navigator
    about, 1.5.1
    changing views, 3.4.4
    preferences, 3.2.4
    working with, 3.4
  Object Type View, 1.5.2, 3.4.4
  objects
    common tasks, 3.3
  obsolete functionality, 3.1.2
  OC4J, 2.2.2
  OCA, 3.15.2
  ODBC, 3.15.2
  OLAP data source
    building an OLAP query, 46.2.2
  online Help, 3.1.1
  Open Database Connectivity (ODBC), 3.15.2
  opening report, 3.3.2
  ORA_DE built-in package, 2.6.12.2
  ORA_FFI built-in package, 2.6.12.2
  ORA_JAVA built-in package, 2.6.12.2
  ORA_NLS built-in package, 2.6.12.2
  ORA_PROF built-in package, 2.6.12.2
  Oracle Express
    PDS, 3.15.3
  Oracle Net Services, 2.9.2
  Oracle Open Client Adapter (OCA), 3.15.2
  Oracle Reports
    about this release, 1.1.2
    and JSPs, 2.2.1.1
  Oracle Reports Services, 3.1.2
  OracleAS Portal, 3.12.10, 3.15.1
  Order Entry schema, Preface
  orientation, 3.7.14
  ORIENTATION system parameter, 1.9.1
  outer join, 11
  output
    about, 2.8
    delimited, 2.8.12, 3.7.10, 3.7.11
    displaying in Paper Design view, 3.7.16.2
    displaying in Previewer, 3.7.16.3
    displaying in Web browser, 3.7.16.4
    format order, 2.8.1
    HTML and HTMLCSS, about, 2.8.8
    HTML, HTMLCSS, 3.7.5
    magnifying or reducing, 3.7.16.8
    PDF, 2.8.10, 3.7.6
    RTF, 2.8.11, 3.7.8
    splitting view, 3.7.16.7
    spreadsheet, 3.7.11
    text, 2.8.14, 3.7.9
    viewing, 3.7.16
    XML, 2.8.7, 3.7.7
  Override node, 2.7.2
  overview
    functionality, 3.1.2
    new features, 3.1.2
    Oracle Reports, 3.1.2
  Ownership View, 1.5.2, 3.4.4

## P

  package
    creating, 42.2.2
    moving a SELECT statement into, 40.8
    moving into a library, 40.9
    using built-in, 3.13.1
  page break, adding, 3.9.14.2
  page layout, modifying, 3.9.14
  page numbers, 3.9.3
  Page Protect property, 2.4.1
  pages
    renumbering by repeating frame, 4.5.6
  page-streamed output, 3.6.10.1.12
  paginating HTML output
    page-streamed HTML output, 2.8.8.1, 3.6.10.2.11, 3.7.16.5
  pagination
    in HTML, 2.8.8
  paging, 3.7.16.6
  Paper Design view
    about, 1.6.4
    displaying report output, 3.7.16.2
  Paper Layout view
    about, 1.6.3
  paper-based report
    HTML output, 2.2.3
    PDF output, 2.2.4
    preparing for Web, 3.6.9
    vs. JSP-based report, 3.6.10
  parameter
    about, 1.9.1
    creating LOV, 3.11.3
  Parameter Form, 41
    adding pages, 3.11.8
    default, 3.11.5
    displaying at runtime, 3.11.7
    footer, 3.6.10.1.6
    HTML extensions, 2.5.1
    HTML, changing input to uppercase, 3.11.13
    HTML, creating field with events, 3.11.12
    in Web reports, 3.11.7
    objects, about, 1.9, 2.5
    selecting parameters for, 3.11.6
    suppressing, 3.7.15
    working with, 3.11
  Parameter Form footer, 2.2.3
    HTML, 3.6.10.2.6
  Parameter Form header, 2.2.3, 3.6.10.1.5
    HTML, 3.6.10.2.5
  Parameter Form view
    about, 1.6.5
  parameters
    creating user, 3.11.2
    in Runtime Parameter Form, 3.11.6
    passing to batch reports, 3.11.9
    referencing, about, 2.3.4
    using system, 3.11.1
    validating at runtime, 3.11.4
    working with, 3.11
  parent object
    moving child outside, 3.9.11.2
  patterns
    about changing, 2.4.5
    changing, 3.9.6.3
    changing using PL/SQL, 3.9.6.4
    in templates, 2.4.5
    using in report, 18
    working with, 3.9.6
  PDF
    output, 2.8.10, 3.7.6
    Web links for paper-based reports, 2.2.4
  performance
    improving, 3.16.3, 3.16.4
  physical page, 2.1.4
  placeholder column
    about, 2.3.3
    creating, 3.8.12
    formula for, 2.6.8
  platforms, running on multiple, 3.5.10
  PL/SQL
    adding Web links to paper-based report, 3.6.10.2
    changing colors and patterns, 3.9.6.4
    changing text attributes, 3.9.2.10
    defining, 3.13.2.1
    in formulas, 3.8.10
    using in report or template, 3.13
  PL/SQL Editor
    about, 2.6.1
    working with, 3.13.2
  PL/SQL Interpreter
    about, 2.10.2
    working with, 3.14.9
  PL/SQL library
    about, 2.6.6
    adding program unit, 3.13.5.2
    attaching, 3.13.5.5
    converting, 3.13.5.6
    creating, 3.13.5.1
    editing program unit, 3.13.5.3
    removing program unit, 3.13.5.4
  pluggable data source (PDS)
    accessing, 3.15.2
    integrating with Oracle Express, 3.15.3
  pluggable destinations, 2.8.4
  Portal, 3.12.10, 3.15.1
  portlet, 3.12.10
  portrait orientation, 3.7.14
  PostScript, 3.7.17.2, 3.7.17.6
  preferences
    color palette, 3.2.6, 3.9.6.1
    Object Navigator, 3.2.4
    report, 3.2.3
    setting, 3.2
  preprinted form
    printing, 3.7.17.4
    report, 32
  Previewer, 3.7.17.2
    about, 1.11.2
    displaying report output, 3.7.16.3
    printing report, 3.7.17.2
  primary key, 11
  Print Object On property, 2.4.1
  printable area, 3.7.16.1
  printer dependency, 3.7.17.6
  printer tray
    switching, 2.8.6, 3.7.17.5
  printing
    format order, 2.8.1
    preprinted form, 3.7.17.4
    report, 3.7.17
    UNIX, 3.7.17.6
  PRINTJOB system parameter, 1.9.1
  program unit
    about, 2.6.4
    compiling and running, 3.13.6
    controlling execution, 3.14.11
    creating, 3.13.3.1
    debugging, 3.14.11
    deleting, 3.13.3.3
    editing, 3.13.2.3
    moving between client and server, 3.13.3.4
    searching and replacing in, 3.13.2.2
  properties
    comparing, 3.2.8
    multiple objects, 3.2.7
    report, 3.2.2, 3.2.5
    setting, 3.2
    templates, 2.7.4
  Property Inspector
    about, 1.10.1
    displaying, 3.2.1

## Q

  query
    about, 1.7.1
    building an XML query, 44.2.2
    creating, 3.8.1
    importing, 3.8.1.3
    modifying, 3.8.2
    non-linkable, about, 2.3.5
  Query Builder, 3.8.1.3, 3.8.3
    about, 1.7.5

## R

  range of data
    aggregating, 30
  ranking report, 34
  reading direction
    changing, 3.9.2.9
  reducing output, 3.7.16.8
  REF CURSOR, 2.6.10
  ref cursor
    creating links between queries, 40.5
    query, creating, 40.3
    type, defining, 40.2
  REF CURSOR query
    about, 2.6.10
  Ref Cursor Query tool, 3.8.1.9
  Referenced By node, 3.14.17
  References node, 3.14.17
  referencing columns and parameters
    about, 2.3.4
  referencing field, 3.9.2.5
  renaming report, 3.3.5
  renumbering pages by repeating frame, 4.5.6
  repeating frame
    about, 1.8.2
    creating, 3.9.1.2
    renumbering pages by, 4.5.6
    sizing, 1.8.3
  report
    about creating, 1.2.1.1
    about Web, 1.2.2
    across break, 12
    aggregating data within ranges, 30
    ASCII, 2.8.15, 3.2.5, 3.5.9
    bursting, 37.2
    check printing, 4.5.4
    common tasks, 3.3
    conditional form letter, 22, 22, 22
    converting, 3.16.2
    creating, 3.5.1
    creating a table of contents, 35.2
    creating an index, 35.3
    creating multilevel TOC, 36
    debugging, 3.14
    definition, 1.2.1
    deploying, 3.7.13
    dimensions, 2.1.4
    distributing, 3.7.12
    distributing to multiple destinations, 37
    e-mailing, 3.7.18
    form letter, conditional, 22, 22, 22
    formula, 14
    graphics, text, and color, 18
    group above, 11
    group in middle, 20
    group left, 10
    group left summary, 13
    header and footer, 16
    header with database values, 3.9.9.2, 17
    intermixed fields, 20
    JSP-based, 41
    layout, 3.9
    mailing label, 6
    master/master, 8
    matrix, 25
    matrix with group, 27
    modifying page layout, 3.9.14
    preferences, 3.2.3
    preprinted form, 32
    printing, 3.7.17
    properties, 3.2.2, 3.2.5
    ranked data, 34
    renumbering pages by repeating frame, 4.5.6
    running, 3.7.1, 3.7.2, 3.7.3, 3.7.4
    running and dispatching, 3.7
    running in batch mode, 3.11.9
    sections, 2.1.2, 3.10
    summary, 9
    tabular, 5
    template, working with, 3.12
    time series calculations, 28
    title, 2.1.1, 3.5.6
    tracing distribution, 3.14.19
    tracing execution, 3.14.18
    trigger, creating, 3.13.3.5
    trigger, deleting, 3.13.3.6
    unit of measurement, 2.1.3
    using PL/SQL, 3.13
    wrapped break, 15
  Report Block Wizard
    about, 1.4.2
    glossary, Glossary
  Report Editor
    about, 1.6.1
    displaying view, 3.4.1
  report trigger
    about, 2.6.13.1
    creating, 3.13.3.5
    deleting, 3.13.3.6
  Report Wizard
    about, 1.4.1
    creating query, 3.8.1.1
    creating report, 1.2.1.1
    glossary, Glossary
  Reports Builder
    about, 1.1.1
    executables, 1.12
  Reports Server, 1.12, 3.1.2, 3.7.4
  REPORTS_CLASSPATH, updating, 42.1.1
  REPORTS_TMP environment variable, 2.2.2
  resizing objects, 3.9.12
    about, 2.4.6
  role
    database, setting, 3.16.1
  rotating objects, 3.9.11.8
  row
    alternating colors, 3.9.6.9
    highlighting, 3.9.6.8
  row colors
    applying alternating row colors, 44.2.5
  rows
    blank lines between groups, 3.9.13.5
    spacing between, 3.9.13.4
  RTF
    output, 2.8.11, 3.7.8
  RUNDEBUG, 3.14.2
  running
    program units, 3.13.6
    report, 3.7, 3.7.1, 3.7.2, 3.7.3, 3.7.4
  runtime
    modifying code, 2.10.9, 3.14.13
  Runtime Parameter Form
    adding pages, 3.11.8
    displaying, 3.11.7
    selecting parameters for, 3.11.6
    with HTML, 2.5.1
  Runtime Parameter Formr
    about, 1.11.1
  rwbuilder, 1.12
  rwcgi, 1.12
  rwclient, 1.12
  rwconverter, 1.12
  rwrun, 1.12
  rwserver, 1.12
  rwservlet, 1.12

## S

  saving report, 3.3.3
  schemas, Preface
  scope location
    about, 2.10.7
    displaying, 3.14.14
  SCOTT schema, Preface
  screenprinter.ppd, 3.7.17.6
  scrolling, 3.7.16.6
  searching
    in Object Navigator, 3.4.3
    program unit, 3.13.2.2
  sections
    about, 2.1.2
    working with, 3.10
  SELECT statement
    moving into a package, 40.8
  selecting objects, 3.3.8.1
  server
    moving program unit to, 3.13.3.4
  server-side
    program unit, creating, 3.13.3.2
  single vs. multiple query group report, 11
  single-query reports, 1.7.1
  sizing
    frame or repeating frame, 1.8.3
    objects, 3.9.12.2
  Snap to Grid, 3.9.13.3
  Software Configuration Manager (SCM), 3.3.7
  source control, 3.3.7
  Source pane
    about, 2.10.3
  spacing
    changing, 3.9.13, 3.9.13.3
    changing text, 3.9.2.9
    default layout, 3.9.13.3
    text, changing, 3.9.2.9
  splitting viewing region, 3.7.16.7
  spreadsheet output
    generating, 3.7.11
  SQL Query tool, 3.8.1.3
  SQL*Net, 2.9.2
  SRW built-in package, 2.6.12.1
  SRW.GET_PAGE_NUM, 35.3.2
  SRW.SET_AFTER_FORM_HTML, 1.9.4, 3.6.10.2.6
  SRW.SET_AFTER_PAGE_HTML, 2.8.8, 3.6.10.2.4
  SRW.SET_AFTER_REPORT_HTML, 3.6.10.2.2
  SRW.SET_BACKGROUND_BORDER_COLOR, 2.4.5, 3.9.6.4
  SRW.SET_BACKGROUND_FILL_COLOR, 2.4.5, 3.9.6.4
  SRW.SET_BEFORE_FORM_HTML, 1.9.4, 3.6.10.2.5
  SRW.SET_BEFORE_PAGE_HTML, 3.6.10.2.3
  SRW.SET_BEFORE_REPORT_HTML, 3.6.10.2.1
  SRW.SET_BOOKMARK, 3.6.10.2.10
  SRW.SET_BORDER_PATTERN, 2.4.5, 3.9.6.4
  SRW.SET_CHARMODE_TEXT, 3.9.2.10
  SRW.SET_FILL_PATTERN, 2.4.5
  SRW.SET_FONT_FACE, 3.9.2.10
  SRW.SET_FONT_SIZE, 3.9.2.10
  SRW.SET_FONT_STYLE, 3.9.2.10
  SRW.SET_FONT_WEIGHT, 3.9.2.10
  SRW.SET_FOREGROUND_BORDER_COLOR, 2.4.5, 3.9.6.4
  SRW.SET_FOREGROUND_FILL_COLOR, 2.4.5, 3.9.6.4
  SRW.SET_FORMAT_ORDER, 2.8.1, 3.5.7, 35, 35.2.3, 36.3
  SRW.SET_HYPERLINK_ATTRS, 3.6.10.2.7
  SRW.SET_JUSTIFICATION, 3.9.2.10
  SRW.SET_LINKTAG, 3.6.10.2.8
  SRW.SET_PAGE_NAVIGATION_HTML, 3.6.10.2.11
  SRW.SET_PDF_ACTION, 3.6.10.2.9
  SRW.SET_PRINTER_TRAY, 2.8.6
  SRW.SET_TEXT_COLOR, 2.4.5, 3.9.6.4
  Stack node, 3.14.14, 3.14.15
  Stored PL/SQL Editor
    about, 2.6.2
    copying syntax into, 3.13.2.4
  stored program unit
    about, 2.6.5
    creating, 3.13.3.2
  STPROC built-in package, 2.6.12.2
  style sheets
    about, 2.2.11
  subprogram references, viewing, 3.14.17
  summary
    in matrix report, 25
  summary column
    about, 2.3.1
    creating, 3.8.11, 36.4
    for header, 17.3
    vs. formula column, 14
  summary report, 9
  SUMMIT schema, Preface
  suppressing Parameter Form, 3.7.15
  Syntax Palette
    about, 2.6.3
    using to copy syntax, 3.13.2.4
  system parameter
    about, 1.9.1
    referencing, about, 2.3.4
    using, 3.11.1

## T

  table of contents
    creating, 2.8.1, 3.5.7
    creating for a report, 35
    creating multilevel, 36
  tabular report, 5
    about, 1.3.1
  .tdf file, 2.7.1
  template
    about, 2.7.1
    about colors and patterns, 2.4.5
    adding items and objects, 3.12.6
    applying to report, 2.7.3, 3.12.4
    attributes, about, 2.7.2
    creating, 3.12.1
    creating HTML for report portlet, 3.12.10
    defining default attributes, 3.12.2
    defining override attributes, 3.12.3
    inheritance, 2.7.4
    modifying body objects, 3.12.8
    modifying margin objects, 3.12.7
    properties, 2.7.4
    setting title attributes, 3.12.5
    using PL/SQL, 3.13
    working with, 3.12
  Template Editor
    about, 2.7.5
  text
    objects, 3.9.2
    output, 2.8.14, 3.7.9
    spacing, changing, 3.9.13.2
    wrapping, 3.9.2.8
  text attributes
    changing, 3.9.2.9
    changing using PL/SQL, 3.9.2.10
  Text Color tool, 2.4.5
  Text Query tool, 3.8.1.6
  TEXT_IO built-in package, 2.6.12.2
  time format masks, 3.9.7.1
  time series calculations report, 28
  time/date stamps, 3.9.3
  title
    adding to report, 3.5.6
    report, about, 2.1.1
    template, 3.12.5
  TOC
    creating a simple table of contents, 35.2
    creating multilevel, 36
  tool palette
    about, 1.6.7
  TOOL_ENV built-in package, 2.6.12.2
  TOOL_ERR built-in package, 2.6.12.2
  TOOL_RES built-in package, 2.6.12.2
  toolbar
    about, 1.6.7
  Tools built-in package, 2.6.12.2
  TRACE function, 3.14.20
  tracing
    report distribution, 3.14.19
    report execution, 3.14.18
    TRACE function, 3.14.20
  trailer page
    creating object in, 3.9.10.2
  Trailer Section, 3.10.1
  translating
    report to other languages, 3.5.11
  trigger
    about, 2.6.13
    database, creating, 3.13.3.7
    debug, setting, 3.14.4
    format, creating, 3.13.4.1
    report, creating, 3.13.3.5
    report, deleting, 3.13.3.6
  tutorial, 3.1.2

## U

  uiscreenprint.txt, 3.7.17.6
  unit of measurement, 2.1.3
  UNIX, 3.7.17.6
  uppercase
    Parameter Form input, 3.11.13
  URL
    for image, 3.8.6
    linking image to, 2.2.3, 3.9.8.1.3
  user exits, 2.9.3
  user parameter
    about, 1.9.1
    creating, 3.11.2

## V

  validating parameters at runtime, 3.11.4
  validation trigger
    about, 2.6.13.3
    using, 3.11.4
  variables
    examining or changing, 3.14.15
  Vertical Gap, 3.9.13.3
  Vertical Interfield, 3.9.13.3
  Vertical Panels per Page property, 2.1.4
  vertical spacing
    adding, 6.3
  viewing output, 3.7.16
  viewing region, splitting, 3.7.16.7

## W

  Web browser
    displaying report output, 3.7.16.4
    printing report, 3.7.17.3
  Web links
    adding to paper-based report, 3.6.10
  Web report, 41
    about, 1.2.2, 2.2
    Parameter Form, 1.9.4, 3.11.7, 3.11.7
    previewing, 2.2.2
    vs. paper-based, 2.8.8
  Web Source view
    about, 1.6.6
  WEBSERVER_DOCROOT, 2.2.2
  white space
    adding, 8.5, 10.2.3
  width
    column, changing, 3.9.13.1
  Width property, 2.1.4
  wizard
    glossary, Glossary
  wrapped break report, 15
  wrapping text, 3.9.2.8

## X

  XML, 3.9.8.3.1
    filtering data, 44.2.6
    output, 2.8.7, 3.7.7
  XML data source
    building an XML query, 44.2.2
  XML query
    building, 44.2.2
  XML Query tool, 3.8.1.4