Skip Headers

Oracle Reports Building Reports 10g (9.0.4) Part Number B10602-01 |
Home | Contents

# 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-1
  administering Reports Builder, 3-184
  after form escape, 2-17
  After Form Value property, 1-47
  after page escape, 2-16
  AFTER PARAMETER FORM trigger
    using with SRW.SET_FORMAT_ORDER, 34-8, 35-6
  After Parameter Form trigger, 2-65
  after report escape, 2-16
  After Report trigger, 2-65
  aggregating data report, 29-1
  aligning objects, 3-123
  alternate pages, displaying object, 3-86
  alternating row colors, 3-103, 41-9
  anchors
    about, 2-37
    collapsing, 2-40
    explicit, 2-38
    implicit, 2-38
    working with, 3-94
  application command line link, 3-34
    about, 2-16
    using PL/SQL, 3-46
  application program interface (API), 3-4
  archiving report, 3-13
  ASCII report, 2-95, 3-6, 3-23
  attached library
    about, 2-53
    attaching, 3-166
    removing program unit, 3-166
  attributes
    template, 3-144, 3-145, 3-147

## B

  B_OR$REPORT_TITLE, 2-2, 3-147
  barcode
    creating using barcode font, 3-84
    creating using barcode JavaBean, 40-1
    in a paper report, 40-6
    in Web report, 40-16
    JavaBean, initializing, 40-22
  batch mode
    about, 2-76
    passing parameters, 3-138
  before form escape, 2-16
  Before Form Value property, 1-47
  before page escape, 2-16
  Before Parameter Form trigger, 2-65
  before report escape, 2-16
  Before Report trigger, 2-65
  Between Pages trigger, 2-65
  bind reference
    about, 2-21
    vs. lexical, 2-27
  blank lines
    between groups of rows, 3-128
  body
    template, 3-148
  boilerplate
    about, 1-41
    creating for HTML tags, 3-38
    creating for text, 3-86
    Parameter Form, about, 1-45
  bookmark, 3-35
    on break columns, 3-36
    using PL/SQL, 3-46
  borders
    adjusting when moving objects, 3-121
    resizing, 3-125
    working with, 3-92
  break column
    multiple in group report, 10-11
    single in group report, 10-2
  break group
    about, 1-33
    adding column, 10-12
    creating, 3-75
    data model, 10-3
    in nested matrix report, 26-1
    multiple in group report, 10-14
  break report, 10-2
    across, 12-1
    wrapped, 15-1
  breakpoints
    about, 2-103
    setting, 3-172
  built-in package
    about, 2-61
    SRW, 2-62
    Tools, 2-62
    using, 3-150
  bursting
    about, 36-1
    report, 36-3

## C

  call interface, 2-99
  cash amounts, spelled out, 4-23, 30-1
  cell group, 3-76
  cell wrapper, 3-56
  Change View, 3-18
  character-mode report, 2-95, 3-6, 3-23
  check printing report, 4-23, 30-1
  child object
    anchoring, 2-37
    moving outside parent, 3-121
  client-side
    moving program unit to, 3-161
    program unit, creating, 3-159
  color
    row in report, 3-103
  color palette
    importing or exporting, 3-100
    modifying, 3-99
    preferences, 3-8
  colors
    about changing, 2-44
    alternating row colors, 41-9
    changing, 3-96
    changing using PL/SQL, 3-98
    color palette, 3-8
    in templates, 2-45
    using in report, 18-2
    working with, 3-96
  column
    adding to break group, 10-12
    changing labels or widths, 3-126
    database, 1-34
    formula, 3-77
    linking, 3-77
    moving, 3-122
    placeholder, 3-80
    referencing, about, 2-20
    summary, 3-79
  Column Mode property, 2-33
  command file, 3-50
  command line, 3-50
  compiling
    program units, 3-167
  conditional form letter report, 22-1
  conditional formatting
    about, 2-6
    applying to object, 3-85
  conditional highlighting report, 23-1
  Confine mode, 3-93, 3-121, 3-123
  connecting to database, 3-11
  converting
    report, format, 3-185
  COPIES system parameter, 1-44
  copying report, 3-12
  cross product group, 25-1
  cross-product group
    creating, 3-76
  cross-product groups
    about, 1-33
  cross-product report
    about, 1-10
  csv, 2-90
  CURRENCY system parameter, 1-44
  currency, spelled out, 4-23, 30-1
  custom format mask, 3-110

## D

  data
    filtering, 41-13
  data link, 11-2
    about, 1-35
    creating, 3-77
    non-linkable query, 2-28
    vs. groups, 2-28
  data model
    break group, 10-3
    objects, about, 1-29, 2-19
    working with, 3-69
  Data Model view
    about, 1-24
  data sources, IV-xxi
    about XML, 41-1
    non-Oracle, accessing, 3-182
  data within ranges report, 29-1
  Data Wizard
    about, 1-19
    creating query, 3-70
  database
    connecting, 3-11
    selecting HTML tags, 3-40
    selecting image, 3-114
    trigger, creating, 3-163
  database column, 1-34
  Database Objects node, 2-50
  database role
    about, 2-97
    setting, 3-184
  database trigger
    about, 2-68
    creating, 3-163
  database values
    in header, 3-117, 17-1
  date format masks, 3-103
  date/time stamps, 3-90
  DDE built-in package, 2-62
  debug actions
    about, 2-103
    working with, 3-173
  DEBUG built-in package, 2-62
  debug level
    about, 2-105
  debug mode, 3-171
  debug trigger
    about, 2-103
  debug trigger, setting, 3-172
  debugging report, 3-170
  debugging tools, 2-100
  DECIMAL system parameter, 1-44
  default format masks, 3-110
  default layout
    creating, 3-20
    section, 3-131
  default layout spacing, 3-127
  Default node, 2-71
  default Parameter Form, 3-136
  deleting
    program unit, 3-161
  deleting object, 3-16
  deleting report, 3-13
  delimited output
    about, 2-89
    generating, 3-55
  deploying report, 3-58
  deprecated functionality, 3-3
  DESFORMAT system parameter, 1-44
  DESNAME system parameter, 1-44
  DESTINATION keyword, 2-79
  destinations, 2-80
  DESTYPE system parameter, 1-44
  dimensions, report, 2-4
  direction
    for reading text, changing, 3-89
  dispatching report, 3-48, 3-50, 3-51
  DISPLAY dependency, 3-66
  DISPLAY environment variable, 3-66
  distributing
    report, 3-57
  distribution
    about, 2-77, 36-1
    DESTINATION keyword, 2-79
    DST file, 2-79
    editing XML definition, 36-5
    example report, 36-1
    report, tracing, 3-180
  docroot, 2-12
  document root directory, 2-12
  dollar amounts, spelled out, 4-23, 30-1
  drawing
    importing, 3-114
  drawing object, 3-111
  DST file
    about, 2-79
  dynamic graphics report, 24-1

## E

  editing
    program unit, 3-152
  e-mailing report, 3-67
  embedded macros, 2-90
  escape
    before and after, 2-16
  event-driven publishing
    about, 2-81
  examples and demos, 3-4
  Excel, 2-90
  EXEC_SQL built-in package, 2-62
  executablesr
    about, 1-53
  execution
    report, tracing, 3-179
  execution location
    current, about, 2-104
  explicit anchors, 2-38
  Express
    building report with, 43-1
  Express Server, 43-3
  Express Server Query tool, 3-73
  external PL/SQL library
    about, 2-53
    adding program unit, 3-166
    attaching, 3-166
    converting, 3-167
    creating, 3-165
    editing program unit, 3-166
    removing program unit, 3-166
    working with, 3-165

## F

  field
    about, 1-40
    changing format mask, 3-110
    creating, 3-82
    Parameter Form, about, 1-45
    referencing, 3-87
  fields
    intermixed in report, 20-1
  file
    linking from HTML object, 3-39
  Fill Color tool, 2-44
  filter
    about, 1-33
    group, creating or editing, 3-164
  Flex mode, 3-94, 3-121, 3-122
  font
    changing, 3-89
  fonts
    about, 2-6
    applying different, 18-1
    barcode, 3-84
    changing, 3-89
  footer
    group, 3-119
  footer and header report, 16-1
  footer, document
    HTML, 2-14, 3-30, 3-41
  footer, page
    HTML, 2-14, 3-31, 3-43
  footer, Parameter Form
    HTML, 2-14, 3-32, 3-44
  footers, 3-117
  foreign key, 11-2
  form
    report on pre-printed, 31-1
  form letter report, 7-1
    about, 1-9
    conditional, 22-1
  format exceptions, 2-6
  format masks
    working with, 3-103
  format order, 2-75
  Format Order property, 2-75, 3-22
  format trigger
    about, 2-66
    creating, 3-164, 34-8, 35-6
    layout objects, 2-33
  form-like report
    about, 1-9
  formula column, 14-1
    about, 2-20, 2-54
    creating or editing, 3-77
    formula for, 2-54
    vs. summary column, 14-2
  formula report, 14-1
  frame
    about, 1-38
    creating, 3-82
    sizing, 1-39
  frequency
    layout object, 2-33
  functionality
    , 3-3

## G

  Global Variables node, 3-179
  graph
    paper report, 3-112
    Web report, 3-113
  Graph Wizard, 3-112
    about, 1-20
  graphic objects, 3-111
  graphics
    adding to report, 18-1
    dynamic, 24-1
  group
    creating break, 3-75
    creating matrix, 3-76
    header or footer, 3-119
    linking, 3-77
    vs. data link, 2-28
  group above report, 11-1
    about, 1-8
    building, 11-3
    with matrix, 27-1
  group filter
    about, 1-33, 2-56
    creating or editing, 3-164
    vs. Maximum Rows to Fetch property, 2-56
  group left report, 10-2
    about, 1-8
    with database values in header, 17-1
    with header and footer, 16-1
  group left summary report, 13-1
  group report
    grouped in middle, 20-1
    offsetting detail fields, 3-122
    single-query, 10-1
    two-query, 11-1
  groups
    about, 1-33

## H

  header
    group, 3-119
    page and group, working with, 3-117
    report, 3-117
  header and footer report, 16-1
  header page
    creating object in, 3-120
  Header Section, 3-131
  header with database values report, 3-117, 17-1
  header, document
    HTML, 2-14, 3-30, 3-41
  header, page
    HTML, 2-14, 3-31, 3-42
  header, Parameter Form
    HTML, 2-14, 3-32, 3-43
  heading, 17-6
    report, 3-117
  Height property, 2-4
  hiding or showing components, 3-16
  hierarchy
    in Object Navigator, 3-18
  highlighting
    boilerplate, 18-2
    conditional, 23-1
    row in report, 3-101
    value in report, 3-100
  Horizontal Gap, 3-127
  Horizontal Interfield, 3-127
  Horizontal Panels per Page property, 2-5
  HTML
    font sizes, 2-83
    in boilerplate text, 3-38
    in Reports Builder, about, 2-83
    including image URL, 3-115
    linking object to file, 3-39
    output, 2-82, 3-51
    paginating output, 2-86, 3-47, 3-62
    pagination, 2-84
    Parameter Form extensions, 2-48
    selecting tags from database, 3-40
    style sheets, 2-17
  HTML document footer, 2-14, 3-30
    using PL/SQL, 3-41
  HTML document header, 2-14, 3-30
    using PL/SQL, 3-41
  HTML page footer, 2-14, 3-31
    using PL/SQL, 3-43
  HTML page header, 2-14, 3-31
    using PL/SQL, 3-42
  HTML page-streamed output, 3-36
  HTML Parameter Form
    changing input to uppercase, 3-141
    creating field with events, 3-138
  HTML Parameter Form footer, 2-14, 3-32
    using PL/SQL, 3-44
  HTML Parameter Form header, 2-14, 3-32
    using PL/SQL, 3-43
  HTMLCSS
    output, 3-51
  Human Resources schema, IV-xxi
  hyperlink, 3-33
    about, 2-15
    using PL/SQL, 3-44
  hyperlink destination, 3-34
    about, 2-15
    PL/SQL, 3-45

## I

  image
    about, 2-36
    adding to report, 18-1
    importing, 3-114
    linking to URL, 3-37
    selecting from database, 3-114, 3-115
  image objects, 3-111
  implicit anchors, 2-38, 3-95
    algorithm, 2-41
  importing
    drawing or image, 3-114
    SQL query, 3-71
  index
    creating, 3-23
    creating for a report, 34-15
  intermixed fields report, 20-1

## J

  Java classes
    importing, 40-6
  Java Database Connectivity (JDBC), 3-182
  Java importer, 40-6
  JavaBean
    importing, 40-6
    using for a Web report, 40-16
    using in a paper report, 40-6
  JavaServer Pages (JSPs)
    about, 2-9
  JDBC, 3-182
  JDBC Query tool, 3-72
  JDBC-ODBC bridge, 3-182
  JNI built-in package, 2-64
  join, 11-2
  JSP
    about, 2-9
  JSP Parameter Form, 39-1
  JSP-based Web report, IV-xxii, 39-1
  justification
    changing, 3-89

## K

  Keep With Anchoring Object property, 2-33

## L

  label
    changing, 3-126
  labels
    suppressing, 21-1
  landscape, 3-58
  layering objects, 3-123
    about, 2-46
  layout
    additional, 3-21
    default spacing, 3-127
    default, creating, 3-20
    default, section
      section

default layout, 3-131

  modifying, 3-129
  multiple, 13-8
  objects, about, 1-38, 2-33
  working with, 3-81

  layouts
    merging, 13-11
  lexical reference
    about, 2-23
    vs. bind, 2-27
  library
    adding program unit, 3-166
    attached, 2-53
    attaching, 3-166
    converting, 3-167
    creating, 3-165
    editing program unit, 3-166
    external PL/SQL, 2-53
    removing program unit, 3-166
  Line Color tool, 2-44
  link
    about, 1-35
    creating, 3-77
  Link File tool, 3-37, 3-39
  linking
    boilerplate text object to file, 3-88
    data links vs. groups, 2-28
    image object, 3-116
    query, non-linkable, 2-28
  linking tables, 11-2
  links
    creating between ref cursor queries, 38-11
  LIST built-in package, 2-62
  list of values (LOV)
    creating for parameter, 3-135
  logical page, 2-4
  LONG column, 1-34
  LONG RAW column, 1-34

## M

  macros, 2-90
  magnifying output, 3-63
  mailing label report, 6-1
    about, 1-9
  Main Section, 3-131
  margin
    adjusting, 3-129
    creating object in, 3-119
    template, 3-148
  master/detail query
    creating, 35-8
  master/detail report, 10-2
  master/detail/summary report, 13-2
  master/master report, 8-1
  matrix, 2-7
    layout, 1-16
  matrix data model
    considerations, 1-10
  matrix group
    creating, 3-76
  matrix object, 1-17
    about, 2-30
    creating in layout, 3-83
  matrix report, 25-1
    about, 1-10
    nested, 26-1
    with group, 2-7, 27-1
  matrix with group report, 27-1
    about, 2-7
  Maximum Rows to Fetch property, 2-56
  Microsoft Excel, 2-90
  mode
    Confine or Flex, 3-93
  MODE system parameter, 1-44
  moving objects, 3-120
    about, 2-46
  multiple destinations
    distributing to, 36-1
    report output, 3-57
  multiple layouts, 13-8
  multiple objects
    making same size, 3-125
    moving, 3-121
  multiple platforms, 3-24
  multiple queries, 11-1
    about, 1-31
    linking, 11-2
    linking, about, 1-35
    master/master report, 8-1
  multi-query reports, 1-31

## N

  National Language Support (NLS), 3-24
  navigation controls
    about, 2-86
    using PL/SQL, 3-47
    using properties, 3-36
  nested matrix report, 26-1
    about, 2-7
  Net8, 2-98
  new features, 3-3
  node
    in Object Navigator, 3-18
  non-linkable query
    about, 2-28
  non-Oracle data sources
    accessing, 3-182
  number format masks, 3-105
  numbering pages
    renumbering by repeating frame, 4-26, 32-1

## O

  Object Navigator
    about, 1-22
    changing views, 3-18
    hiding or showing components, 3-16
    preferences, 3-6
    working with, 3-17
  Object Type View, 1-23, 3-18
  objects
    common tasks, 3-11
  obsolete functionality, 3-3
  OC4J, 2-11
  OCA, 3-182
  ODBC, 3-182
  online help, IV-xxii, 3-2
  Open Database Connectivity (ODBC), 3-182
  opening report, 3-12
  ORA_DE built-in package, 2-64
  ORA_FFI built-in package, 2-63
  ORA_JAVA built-in package, 2-63
  ORA_NLS built-in package, 2-63
  ORA_PROF built-in package, 2-63
  Oracle Net Services, 2-98
  Oracle Open Client Adapter (OCA), 3-182
  Oracle Reports
    about this release, 1-3
    and JSPs, 2-10
  Oracle Reports Services, 3-4
  Oracle Technology Network, IV-xxi
  OracleAS Portal, 3-183
  Order Entry schema, IV-xxi
  orientation, 3-58
  ORIENTATION system parameter, 1-44
  outer join, 11-2
  output
    about, 2-75
    delimited, 2-89, 3-55
    displaying in Paper Design view, 3-60
    displaying in Previewer, 3-61
    displaying in Web browser, 3-61
    format order, 2-75
    HTML and HTMLCSS, about, 2-82
    HTML, HTMLCSS, 3-51
    magnifying or reducing, 3-63
    PDF, 2-87, 3-52
    RTF, 2-88, 3-55
    splitting view, 3-63
    text, 2-95, 3-56
    viewing, 3-59
    XML, 2-82, 3-53
  Override node, 2-71
  overview
    functionality, 3-3
    new features, 3-3
    Oracle Reports, 3-3
  Ownership View, 1-22, 3-18

## P

  package
    creating, 40-7
    moving a SELECT statement into, 38-17
    moving into a library, 38-19
    using built-in, 3-150
  page break, adding, 3-129
  page layout, modifying, 3-129
  page numbers, 3-90
  Page Protect property, 2-33
  pages
    renumbering by repeating frame, 4-26, 32-1
  page-streamed output, 3-36
  paginating HTML output
    page-streamed HTML output, 2-86, 3-47, 3-62
  pagination
    in HTML, 2-84
  paging, 3-62
  Paper Design view
    about, 1-25
    displaying report output, 3-60
  Paper Layout view
    about, 1-25
  paper-based report
    HTML output, 2-13
    PDF output, 2-14
    preparing for Web, 3-28
    vs. JSP-based report, 3-29
  parameter
    about, 1-43
    creating LOV, 3-135
  Parameter Form, 39-1
    adding pages, 3-137
    default, 3-136
    displaying at runtime, 3-137
    footer, 3-32
    HTML extensions, 2-48
    HTML, changing input to uppercase, 3-141
    HTML, creating field with events, 3-138
    in Web reports, 1-46, 3-137
    objects, about, 1-43, 2-48
    selecting parameters for, 3-137
    suppressing, 3-59
    working with, 3-133
  Parameter Form footer, 2-14
    HTML, 3-44
  Parameter Form header, 2-14, 3-32
    HTML, 3-43
  Parameter Form view
    about, 1-26
  parameters
    creating user, 3-134
    in Runtime Parameter Form, 3-137
    passing to batch reports, 3-138
    referencing, about, 2-20
    using system, 3-134
    validating at runtime, 3-136
    working with, 3-133
  parent object
    moving child outside, 3-121
  patterns
    about changing, 2-44
    changing, 3-97
    changing using PL/SQL, 3-98
    in templates, 2-45
    using in report, 18-2
    working with, 3-96
  PDF
    output, 2-87, 3-52
    Web links for paper-based reports, 2-14
  performance
    improving, 3-185
  physical page, 2-4
  placeholder column
    about, 2-20
    creating, 3-80
    formula for, 2-54
  platforms, running on multiple, 3-24
  PL/SQL
    adding Web links to paper-based report, 3-40
    changing colors and patterns, 3-98
    changing text attributes, 3-89
    defining, 3-151
    in formulas, 3-78
    using in report or template, 3-150
  PL/SQL Editor
    about, 2-49
    working with, 3-150
  PL/SQL Interpreter
    about, 2-100
    working with, 3-174
  PL/SQL library
    about, 2-53
    adding program unit, 3-166
    attaching, 3-166
    converting, 3-167
    creating, 3-165
    editing program unit, 3-166
    removing program unit, 3-166
  PL/SQL report, 37-1
  pluggable data source (PDS)
    accessing, 3-182
    using XML, 41-1
  pluggable destinations, 2-80
  Portal, 3-183
  portrait, 3-58
  preferences
    color palette, 3-8, 3-96
    Object Navigator, 3-6
    report, 3-6
    setting, 3-5
  pre-printed form
    printing
      pre-printed form, 3-66
  pre-printed form report, 31-1
  Previewer
    about, 1-51
    displaying report output, 3-61
    printing report, 3-64
  primary key, 11-2
  Print Object On property, 2-33
  printable area, 3-60
  printer dependency, 3-66
  printer tray
    switching, 2-81, 3-66
  printing
    format order, 2-75
    report, 3-63
    UNIX, 3-66
  PRINTJOB system parameter, 1-44
  program unit
    about, 2-50
    compiling and running, 3-167
    controlling execution, 3-176
    creating, 3-159
    debugging, 3-176
    deleting, 3-161
    editing, 3-152
    moving between client and server, 3-161
    searching and replacing in, 3-151
  properties
    comparing, 3-10
    multiple objects, 3-9
    report, 3-6
    setting, 3-5
    templates, 2-73
  Property Inspector
    about, 1-48
    displaying, 3-5

## Q

  query
    about, 1-29
    building an XML query, 41-6
    creating, 3-69
    importing, 3-71
    modifying, 3-74
    non-linkable, about, 2-28
  Query Builder, 3-71, 3-75
    about, 1-37

## R

  range of data
    aggregating, 29-1
  ranking report, 33-1
  reading direction
    changing, 3-89
  reducing output, 3-63
  ref cursor
    creating links between queries, 38-11
    query, creating, 38-7
    type, defining, 38-5
  ref cursor query
    about, 2-57
  Ref Cursor Query tool, 3-73
  Referenced By node, 3-179
  References node, 3-179
  referencing columns and parameters
    about, 2-20
  referencing field, 3-87
  renaming report, 3-12
  renumbering pages by repeating frame, 4-26, 32-1
  repeating frame
    about, 1-39
    creating, 3-82
    renumbering pages by, 4-26, 32-1
    sizing, 1-39
  report
    about creating, 1-4
    about Web, 1-5
    across break, 12-1
    aggregating data within ranges, 29-1
    ASCII, 2-95, 3-6, 3-23
    bursting, 36-3
    check printing, 4-23, 30-1
    common tasks, 3-11
    conditional form letter, 22-1
    conditional highlighting, 23-1
    converting, 3-185
    creating, 3-19
    creating a multi-level table of contents, 35-2
    creating a table of contents, 34-5
    creating an index, 34-15
    debugging, 3-170
    definition, 1-4
    deploying, 3-58
    dimensions, 2-4
    distributing, 3-57
    distributing to multiple destinations, 36-1
    dynamic graphics, 24-1
    e-mailing, 3-67
    form letter, 7-1
    form letter, conditional, 22-1
    formula, 14-1
    graphics, text, and color, 18-1
    group above, 11-1
    group in middle, 20-1
    group left, 10-2
    group left summary, 13-1
    header and footer, 16-1
    header with database values, 3-117, 17-1
    intermixed fields, 20-1
    JSP-based, 39-1
    layout, 3-81
    mailing label, 6-1
    master/master, 8-1
    matrix, 25-1
    matrix with group, 27-1
    modifying page layout, 3-129
    nested matrix, 26-1
    PL/SQL, 37-1
    preferences, 3-6
    pre-printed form, 31-1
    printing, 3-63
    properties, 3-6
    ranked data, 33-1
    renumbering pages by repeating frame, 4-26, 32-1
    running, 3-48, 3-50, 3-51
    running and dispatching, 3-48
    running in batch mode, 3-138
    sections, 2-3, 3-131
    summary, 9-1
    suppressing labels, 21-1
    tabular, 5-1
    template, working with, 3-143
    time series calculations, 28-1
    title, 2-2, 3-22
    tracing distribution, 3-180
    tracing execution, 3-179
    trigger, creating, 3-162
    trigger, deleting, 3-162
    unit of measurement, 2-4
    using PL/SQL, 3-150
    wrapped break, 15-1
  Report Block Wizard
    about, 1-18
  Report Editor
    about, 1-24
    displaying view, 3-17
    hiding or showing components, 3-16
  report trigger
    about, 2-65
    creating, 3-162
    deleting, 3-162
  Report Wizard
    about, 1-18
    creating query, 3-70
    creating report, 1-4
    Express report, 43-4
  Reports Builder
    about, 1-2
    executables, 1-53
  Reports Server, 1-53, 3-4, 3-51
  REPORTS_CLASSPATH, updating, 40-4
  REPORTS_TMP environment variable, 2-12
  resizing objects, 3-124
    about, 2-46
  role
    database, setting, 3-184
  rotating objects, 3-124
  row
    alternating colors, 3-103
    highlighting, 3-101
  row colors
    applying alternating row colors, 41-9
  rows
    blank lines between groups, 3-128
    spacing between, 3-127
  RTF
    output, 2-88, 3-55
  RUNDEBUG, 3-171
  running
    program units, 3-167
    report, 3-48, 3-50, 3-51
  runtime
    modifying code, 2-106, 3-177
  Runtime Parameter Form
    adding pages, 3-137
    displaying, 3-137
    selecting parameters for, 3-137
    with HTML, 2-48
  Runtime Parameter Formr
    about, 1-50
  rwbuilder, 1-53
  rwcgi, 1-53
  rwclient, 1-53
  rwconverter, 1-53
  rwrun, 1-53
  rwserver, 1-53
  rwservlet, 1-53

## S

  saving report, 3-12
  schemas, IV-xxi
  scope location
    about, 2-105
    displaying, 3-178
  SCOTT schema, IV-xxi
  screenprinter.ppd, 3-66
  scrolling, 3-62
  searching
    in Object Navigator, 3-18
    program unit, 3-151
  sections
    about, 2-3
    working with, 3-131
  SELECT statement
    moving into a package, 38-17
  selecting objects, 3-14
  server
    moving program unit to, 3-161
  server-side
    program unit, creating, 3-160
  servlets, 2-9
  showing or hiding components, 3-16
  single vs. multiple query group report, 11-2
  single-query reports, 1-29
  sizing
    frame or repeating frame, 1-39
    objects, 3-125
  Snap to Grid, 3-127
  Software Configuration Manager (SCM), 3-13
  source control, 3-13
  Source pane
    about, 2-101
  spacing
    changing, 3-126, 3-127
    changing text, 3-89
    default layout, 3-127
    text, changing, 3-89
  splitting viewing region, 3-63
  SQL Query tool, 3-71
  SQL*Net, 2-98
  SRW built-in package, 2-62
  SRW.GET_PAGE_NUM, 34-17
  SRW.SET_AFTER_FORM_HTML, 1-47, 3-44
  SRW.SET_AFTER_PAGE_HTML, 2-84, 3-43
  SRW.SET_AFTER_REPORT_HTML, 3-42
  SRW.SET_BACKGROUND_BORDER_COLOR, 2-45, 3-98
  SRW.SET_BACKGROUND_FILL_COLOR, 2-45, 3-98
  SRW.SET_BEFORE_FORM_HTML, 1-47, 3-44
  SRW.SET_BEFORE_PAGE_HTML, 3-42
  SRW.SET_BEFORE_REPORT_HTML, 3-41
  SRW.SET_BOOKMARK, 3-47
  SRW.SET_BORDER_PATTERN, 2-45, 3-98
  SRW.SET_CHARMODE_TEXT, 3-90
  SRW.SET_FILL_PATTERN, 2-45
  SRW.SET_FONT_FACE, 3-90
  SRW.SET_FONT_SIZE, 3-90
  SRW.SET_FONT_STYLE, 3-90
  SRW.SET_FONT_WEIGHT, 3-90
  SRW.SET_FOREGROUND_BORDER_COLOR, 2-45, 3-98
  SRW.SET_FOREGROUND_FILL_COLOR, 2-45, 3-98
  SRW.SET_FORMAT_ORDER, 2-75, 3-22, 34-2, 34-8, 35-6
  SRW.SET_HYPERLINK_ATTRS, 3-45
  SRW.SET_JUSTIFICATION, 3-90
  SRW.SET_LINKTAG, 3-45
  SRW.SET_PAGE_NAVIGATION_HTML, 3-47
  SRW.SET_PDF_ACTION, 3-46
  SRW.SET_PRINTER_TRAY, 2-81
  SRW.SET_TEXT_COLOR, 2-45, 3-98
  SRW.TRACE_ADD_OPTIONS, 3-180
  SRW.TRACE_END, 3-180
  SRW.TRACE_REM_OPTIONS, 3-180
  SRW.TRACE_START, 3-180
  Stack node, 3-178
  Stored PL/SQL Editor
    about, 2-50
    copying syntax into, 3-158
  stored program unit
    about, 2-52
    creating, 3-160
  STPROC built-in package, 2-64
  style sheets
    about, 2-17
  subprogram references, viewing, 3-179
  summary
    in matrix report, 25-1
  summary column
    about, 2-19
    creating, 3-79, 35-8
    for header, 17-5
    vs. formula column, 14-2
  summary report, 9-1
  SUMMIT schema, IV-xxi
  suppressing labels report, 21-1
  suppressing Parameter Form, 3-59
  Syntax Palette
    about, 2-50
    using to copy syntax, 3-158
  system parameter
    about, 1-44
    referencing, about, 2-20
    using, 3-134

## T

  table of contents
    creating, 2-76, 3-22
    creating a multi-level, 35-2
    creating for a report, 34-2
  tabular report, 5-1
    about, 1-8
  .tdf file, 2-69
  template
    about, 2-69
    about colors and patterns, 2-45
    adding items and objects, 3-147
    applying to report, 2-72, 3-146
    attributes, about, 2-70
    creating, 3-143
    defining default attributes, 3-144
    defining override attributes, 3-145
    inheritance, 2-73
    modifying body objects, 3-148
    modifying margin objects, 3-148
    properties, 2-73
    setting title attributes, 3-147
    using PL/SQL, 3-150
    working with, 3-143
  Template Editor
    about, 2-73
  text
    configuring the textpds.conf file, 42-3
    objects, 3-85
    output, 2-95, 3-56
    spacing, changing, 3-126
    wrapping, 3-88
  text attributes
    changing, 3-89
    changing using PL/SQL, 3-89
  Text Color tool, 2-44
  text data source
    configuring, 42-3
  Text Query tool, 3-72
  TEXT_IO built-in package, 2-63
  textpds.conf
    editing, 42-3
  THOUSANDS system parameter, 1-44
  time format masks, 3-103
  time series calculations report, 28-1
  time/date stamps, 3-90
  title
    adding to report, 3-22
    report, about, 2-2
    template, 3-147
  TOC
    creating a multi-level table of contents, 35-2
    creating a simple table of contents, 34-5
  tool palette
    about, 1-28
  TOOL_ENV built-in package, 2-64
  TOOL_ERR built-in package, 2-64
  TOOL_RES built-in package, 2-64
  toolbar
    about, 1-28
  Tools built-in package, 2-62
  TRACE function, 3-180
  tracing
    report distribution, 3-180
    report execution, 3-179
    TRACE function, 3-180
  trailer page
    creating object in, 3-120
  Trailer Section, 3-131
  translating
    report to other languages, 3-24
  trigger
    about, 2-65
    database, creating, 3-163
    debug, setting, 3-172
    format, creating, 3-164
    report, creating, 3-162
    report, deleting, 3-162
  tutorial, IV-xxii, 3-3

## U

  uiscreenprint.txt, 3-66
  unit of measurement, 2-4
  UNIX, 3-66
  uppercase
    Parameter Form input, 3-141
  URL
    for image, 3-115
    linked from image, 3-37
    linking image to, 2-14, 3-116
  user exits, 2-98
  user parameter
    about, 1-45
    creating, 3-134

## V

  validating parameters at runtime, 3-136
  validation trigger
    about, 2-67
    using, 3-136
  variables
    examining or changing, 3-178
  Vertical Gap, 3-127
  Vertical Interfield, 3-127
  Vertical Panels per Page property, 2-5
  vertical spacing
    adding, 6-6
  viewing output, 3-59
  viewing region, splitting, 3-63

## W

  Web browser
    displaying report output, 3-61
    printing report, 3-65
  Web links
    adding to paper-based report, 3-29
  Web report, 39-1
    about, 1-5, 2-9
    Parameter Form, 1-46, 3-137
    previewing, 2-11
    vs. paper-based, 2-83
  Web Source view
    about, 1-27
  WEBSERVER_DOCROOT, 2-12
  white space
    adding, 8-6, 10-8
  width
    column, changing, 3-126
  Width property, 2-4
  wrapped break report, 15-1
  wrapping text, 3-88

## X

  XML, 3-112
    filtering data, 41-13
    output, 2-82, 3-53
  XML data source
    about, 41-1
    building an XML query, 41-6
  XML query
    building, 41-6
  XML Query tool, 3-72

| Copyright © 2002, 2003 Oracle Corporation. All Rights Reserved. |
Home | Contents