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