Skip Headers
Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports
11g Release 1 (11.1.1)

Part Number B32122-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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, 4.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, 4.9.11.6
alternate pages, displaying object, 4.9.2.2
alternating row colors, 4.9.6.9, 45.2.5
anchors
about, 2.4.4
collapsing, 2.4.4
explicit, 2.4.4
implicit, 2.4.4
working with, 4.9.5
application command line link, 4.6.10.1.9
about, 2.2.9
using PL/SQL, 4.6.10.2.9
application program interface (API), 4.1.2
ASCII report, 2.8.15, 4.2.5, 4.5.9
attached library
about, 2.6.7
attaching, 4.13.5.5
removing program unit, 4.13.5.4
attributes
template, 4.12.2, 4.12.3, 4.12.5

B

B_OR$REPORT_TITLE, 2.1.1, 4.12.5
barcode
creating using barcode font, 4.9.1.4
in a paper report, 43.2
in Web report, 43.3
JavaBean, initializing, 43.3.3
batch mode
about, 2.8.2
passing parameters, 4.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, 4.9.13.5
body
template, 4.12.8
boilerplate
about, 1.8.5
creating for HTML tags, 4.9.2.3
creating for text, 4.9.2.1, 4.9.2.2
Parameter Form, about, 1.9.3
bookmark, 4.6.10.1.10
on break columns, 4.6.10.1.11
using PL/SQL, 4.6.10.2.10
borders
adjusting when moving objects, 4.9.11.3
resizing, 4.9.12.3
working with, 4.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, 4.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, 4.14.3
built-in package
about, 2.6.12
SRW, 2.6.12.1
Tools, 2.6.12.2
using, 4.13.1
bursting
about, 37
report, 37.2

C

call interface, 2.9.4
Cascading Style Sheet, 2.2.11
cash amounts, spelled out, 3.5.4
cell group, 4.8.8
cell wrapper, 4.7.10
Change View, 4.4.4
character-mode report, 2.8.15, 4.2.5, 4.5.9
check printing report, 3.5.4
child object
anchoring, 2.4.4
moving outside parent, 4.9.11.2
client-side
moving program unit to, 4.13.3.4
program unit, creating, 4.13.3.1
color
row in report, 4.9.6.9
color palette, 4.2.6
importing or exporting, 4.9.6.6
modifying, 4.9.6.5
preferences, 4.2.6
colors
about changing, 2.4.5
alternating row colors, 45.2.5
changing, 4.9.6.2
changing using PL/SQL, 4.9.6.4
color palette, 4.2.6
in templates, 2.4.5
using in report, 18
working with, 4.9.6
column
adding to break group, 10.3.1
changing labels or widths, 4.9.13.1
database, 1.7.3
formula, 4.8.10
linking, 4.8.9
moving, 4.9.11.4
placeholder, 4.8.12
referencing, about, 2.3.4
summary, 4.8.11
Column Mode property, 2.4.1
columns
graphics and images, 1.7.3, 4.8.5, 4.8.6, 4.9.8.1.1
command file, 4.7.3
command line, 4.7.2
compiling
program units, 4.13.6
conditional form letter report, 23, 23, 23
conditional formatting
about, 2.1.6
applying to object, 4.9.1.5
Confine mode, 4.9.4.3, 4.9.11.2, 4.9.11.7
connecting to database, 4.3.1
converting
report, format, 4.16.2
COPIES system parameter, 1.9.1
copying report, 4.3.4
cross product group, 25
cross-product group
creating, 4.8.8
cross-product groups
about, 1.7.2
cross-product report
about, 1.3.7
CSS, 2.2.11
currency, spelled out, 3.5.4
curved line graph, 39.1
custom format mask, 4.9.7.5

D

data
filtering, 45.2.6
Data Definition Language, 2.6.11
data link, 11
about, 1.7.4
creating, 4.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, 4.8
Data Model view
about, 1.6.2
data sources, Preface
non-Oracle, accessing, 4.15.2
data within ranges report, 30
Data Wizard
about, 1.4.3
creating query, 4.8.1.2
glossary, Glossary
database
connecting, 4.3.1
selecting HTML tags, 4.8.4
selecting image, 4.8.5
trigger, creating, 4.13.3.7
database column, 1.7.3
Database Objects node, 2.6.2
database role
about, 2.9.1
setting, 4.16.1
database trigger
about, 2.6.13.4
creating, 4.13.3.7
database values
in header, 4.9.9.2, 17
date format masks, 4.9.7.1
date format, in graphs, 39.1
date/time stamps, 4.9.3
DDE built-in package, 2.6.12.2
DDL, 2.6.11
debug actions
about, 2.10.5
working with, 4.14.5
DEBUG built-in package, 2.6.12.2
debug level
about, 2.10.8
debug mode, 4.14.2
debug trigger
about, 2.10.5
debug trigger, setting, 4.14.4
debugging report, 4.14
debugging tools, 2.10
default format masks, 4.9.7.5
default layout
creating, 4.5.4
section, 4.10.2
default layout spacing, 4.9.13.3
Default node, 2.7.2
default Parameter Form, 4.11.5
deleting
program unit, 4.13.3.3
deleting object, 4.3.8
deleting report, 4.3.6
delimited output
about, 2.8.12
generating, 4.7.10
deploying report, 4.7.13
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, 4.9.2.9
dispatching report, 4.7, 4.7.1, 4.7.2, 4.7.3, 4.7.4
DISPLAY dependency, 4.7.17.6
DISPLAY environment variable, 4.7.17.6
distributing
report, 4.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, 4.14.19
DML, 2.6.11
dollar amounts, spelled out, 3.5.4
drawing
importing, 4.9.8.1.1
drawing object, 4.9.8.5
DST file
about, 2.8.3.1

E

editing
program unit, 4.13.2.3
e-mailing report, 4.7.18
enhancedspreadsheet
output, 2.8.13
enhancedspreadsheet output
spreadsheet, 4.7.11
escape
before and after, 2.2.10
event-driven publishing
about, 2.8.5
examples and demos, 4.1.2
EXEC_SQL built-in package, 2.6.12.2
executablesr
about, 1.12
execution
report, tracing, 4.14.18
execution location
current, about, 2.10.6
explicit anchors, 2.4.4
external PL/SQL library
about, 2.6.6
adding program unit, 4.13.5.2
attaching, 4.13.5.5
converting, 4.13.5.6
creating, 4.13.5.1
editing program unit, 4.13.5.3
removing program unit, 4.13.5.4
working with, 4.13.5

F

field
about, 1.8.4
changing format mask, 4.9.7.6
creating, 4.9.1.1
Parameter Form, about, 1.9.2
referencing, 4.9.2.5
fields
intermixed in report, 20
file
linking from HTML object, 4.9.2.7
File Link tool, 4.9.2.6, 4.9.2.7
Fill Color tool, 2.4.5
filter
about, 1.7.2
group, creating or editing, 4.13.4.2
Flex mode, 4.9.4.3, 4.9.11.3, 4.9.11.4, 4.9.11.5
font
changing, 4.9.2.9
fonts
about, 2.1.5
applying different, 18
barcode, 4.9.1.4
changing, 4.9.2.9
footer
group, 4.9.9.3
footer and header report, 16
footer, document
HTML, 2.2.3, 4.6.10.1.2, 4.6.10.2.2
footer, page
HTML, 2.2.3, 4.6.10.1.4, 4.6.10.2.4
footer, Parameter Form
HTML, 2.2.3, 4.6.10.1.6, 4.6.10.2.6
footers, 4.9.9
foreign key, 11
form
report on preprinted, 32
form letter report
about, 1.3.5
conditional, 23, 23, 23
format exceptions, 2.1.6
format masks
working with, 4.9.7
format order, 2.8.1
Format Order property, 2.8.1, 4.5.7
format trigger
about, 2.6.13.2
creating, 4.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, 4.8.10
formula for, 2.6.8
vs. summary column, 14
formula report, 14
frame
about, 1.8.1
creating, 4.9.1.2
sizing, 1.8.3
frequency
layout object, 2.4.1
funnel graph, 39.1

G

Global Variables node, 4.14.16
graph
curved line, 39.1
date fomat, 39.1
funnel, 39.1
graph hyperlink, 2.2.3, 2.2.4, 2.2.6, 4.9.8.4
new functionality, 39.1
number formatting, 39.1
paper report, 4.9.8.2.1, 4.9.8.3.1
SVG, 39.1
SVG support, 39.1
Web report, 4.9.8.2.2, 4.9.8.3.2
graph hyperlink
about, 2.2.6
adding, 4.9.8.4
Graph Wizard, 4.9.8.2.1
about, 1.4.4, 39.1
glossary, Glossary
graphic objects, 4.9.8
graphics
adding to report, 18
group
creating break, 4.8.7
creating matrix, 4.8.8
header or footer, 4.9.9.3
linking, 4.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, 4.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, 4.9.11.5
single-query, 10
two-query, 11
groups
about, 1.7.2

H

header
group, 4.9.9.3
page and group, working with, 4.9.9
report, 4.9.9.1
header and footer report, 16
header page
creating object in, 4.9.10.2
Header Section, 4.10.1
header with database values report, 4.9.9.2, 17
header, document
HTML, 2.2.3, 4.6.10.1.1, 4.6.10.2.1
header, page
HTML, 2.2.3, 4.6.10.1.3, 4.6.10.2.3
header, Parameter Form
HTML, 2.2.3, 4.6.10.1.5, 4.6.10.2.5
heading, 17.4, 17.4
report, 4.9.9.1
Height property, 2.1.4, 4.7.14
hierarchy
in Object Navigator, 4.4.4
highlighting
boilerplate, 18
row in report, 4.9.6.8
value in report, 4.9.6.7
Horizontal Gap, 4.9.13.3
Horizontal Interfield, 4.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, 4.9.2.3
in Reports Builder, about, 2.8.8
including image URL, 4.8.6
linking object to file, 4.9.2.7
output, 2.8.8, 4.7.5
paginating output, 2.8.8.1, 4.6.10.2.11, 4.7.16.5
pagination, 2.8.8
Parameter Form extensions, 2.5.1
selecting tags from database, 4.8.4
style sheets, 2.2.11
HTML document footer, 2.2.3, 4.6.10.1.2
using PL/SQL, 4.6.10.2.2
HTML document header, 2.2.3, 4.6.10.1.1
using PL/SQL, 4.6.10.2.1
HTML page footer, 2.2.3, 4.6.10.1.4
using PL/SQL, 4.6.10.2.4
HTML page header, 2.2.3, 4.6.10.1.3
using PL/SQL, 4.6.10.2.3
HTML page-streamed output, 4.6.10.1.12
HTML Parameter Form
changing input to uppercase, 4.11.13
creating field with events, 4.11.12
HTML Parameter Form footer, 2.2.3, 4.6.10.1.6
using PL/SQL, 4.6.10.2.6
HTML Parameter Form header, 2.2.3, 4.6.10.1.5
using PL/SQL, 4.6.10.2.5
HTMLCSS
output, 4.7.5
Human Resources schema, Preface
hyperlink, 4.6.10.1.8
about, 2.2.5
graph, 2.2.3, 2.2.4, 2.2.6, 4.9.8.4
using PL/SQL, 4.6.10.2.7
hyperlink destination, 4.6.10.1.7
about, 2.2.7
PL/SQL, 4.6.10.2.8

I

image
about, 2.4.3
adding to report, 18
image column, 4.8.5, 4.8.6
importing, 4.9.8.1.1
in JSP-based Web report, 4.8.5, 4.8.6
selecting from database, 4.8.5, 4.8.6
image objects, 4.9.8
images
image column, 1.7.3, 4.9.8.1.1
implicit anchors, 2.4.4, 4.9.5.2
algorithm, 2.4.4.1
importing
drawing or image, 4.9.8.1.1
SQL query, 4.8.1.3
index
creating, 4.5.8
creating for a report, 35.3
intermixed fields report, 20

J

Java classes
importing, 43.2.1
Java Database Connectivity (JDBC), 4.15.2
Java importer, 43.2.1
JavaBean
importing, 43.2.1
using for a Web report, 43.3
using in a paper report, 43.2
JavaServer Pages (JSPs)
about, 2.2.1
JDBC, 4.15.2
JDBC Query tool, 4.8.1.5
JDBC-ODBC bridge, 4.15.2
JNI built-in package, 2.6.12.2
join, 11
JSP
about, 2.2.1
JSP Parameter Form, 42
JSP-based Web report, 42
justification
changing, 4.9.2.9

K

Keep With Anchoring Object property, 2.4.1

L

label
changing, 4.9.13.1
landscape orientation, 4.7.14
layering objects, 4.9.11.7
about, 2.4.7
layout
additional, 4.5.5
default spacing, 4.9.13.3
default, creating, 4.5.4
default, section
section, 4.10.2
modifying, 4.9.14
multiple, 13.4
objects, about, 1.8, 2.4
working with, 4.9
layouts
merging, 13.5
lexical reference
about, 2.3.4.2
vs. bind, 2.3.4.3
library
adding program unit, 4.13.5.2
attached, 2.6.7
attaching, 4.13.5.5
converting, 4.13.5.6
creating, 4.13.5.1
editing program unit, 4.13.5.3
external PL/SQL, 2.6.6
removing program unit, 4.13.5.4
Line Color tool, 2.4.5
link
about, 1.7.4
creating, 4.8.9
linking
boilerplate text object to file, 4.9.2.6
data links vs. groups, 2.3.6
image object, 4.9.8.1.3
query, non-linkable, 2.3.5
linking tables, 11
links
creating between ref cursor queries, 41.5
LIST built-in package, 2.6.12.2
list of values (LOV)
creating for parameter, 4.11.3
logical page, 2.1.4
LONG column, 1.7.3
LONG RAW column, 1.7.3

M

magnifying output, 4.7.16.8
mailing label report, 6
about, 1.3.6
Main Section, 4.10.1
margin
adjusting, 4.9.14.1
creating object in, 4.9.10.1
template, 4.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, 4.8.8
matrix object, 1.3.7.2.1
about, 2.3.7
creating in layout, 4.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, 4.9.4.3
MODE system parameter, 1.9.1
moving objects, 4.9.11
about, 2.4.7
multiple destinations
distributing to, 37
report output, 4.7.12
multiple layouts, 13.4
multiple objects
making same size, 4.9.12.2
moving, 4.9.11.1
multiple platforms, 4.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), 4.5.11
navigation controls
about, 2.8.8.1
using PL/SQL, 4.6.10.2.11
using properties, 4.6.10.1.12
nested matrix report
about, 2.1.7
Net8, 2.9.2
new features, 4.1.2
node
in Object Navigator, 4.4.2
non-linkable query
about, 2.3.5
non-Oracle data sources
accessing, 4.15.2
number format masks, 4.9.7.2
numbering pages
renumbering by repeating frame, 3.5.6

O

Object Navigator
about, 1.5.1
changing views, 4.4.4
preferences, 4.2.4
working with, 4.4
Object Type View, 1.5.2, 4.4.4
objects
common tasks, 4.3
OCA, 4.15.2
ODBC, 4.15.2
online Help, 4.1.1
Open Database Connectivity (ODBC), 4.15.2
opening report, 4.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 Net Services, 2.9.2
Oracle Open Client Adapter (OCA), 4.15.2
Oracle Portal, 4.12.10, 4.15.1
Oracle Reports
about this release, 1.1.2
and JSPs, 2.2.1.1
Order Entry schema, Preface
orientation, 4.7.14
ORIENTATION command line keyword, 4.7.14
Orientation property, 4.7.14
ORIENTATION system parameter, 1.9.1, 4.7.14
outer join, 11
output
about, 2.8
delimited, 2.8.12, 4.7.10
displaying in Paper Design view, 4.7.16.2
displaying in Previewer, 4.7.16.3
displaying in Web browser, 4.7.16.4
enhancedspreadsheet, 2.8.13, 4.7.11
format order, 2.8.1
HTML and HTMLCSS, about, 2.8.8
HTML, HTMLCSS, 4.7.5
magnifying or reducing, 4.7.16.8
PDF, 2.8.10, 4.7.6
RTF, 2.8.11, 4.7.8
splitting view, 4.7.16.7
spreadsheet, 2.8.13, 4.7.11
text, 2.8.14, 4.7.9
viewing, 4.7.16
XML, 2.8.7, 4.7.7
Override node, 2.7.2
overview
new features, 4.1.2
Oracle Reports, 4.1.2
Ownership View, 1.5.2, 4.4.4

P

package
creating, 43.2.2
moving a SELECT statement into, 41.8
moving into a library, 41.9
using built-in, 4.13.1
page break, adding, 4.9.14.2
page layout, modifying, 4.9.14
page numbers, 4.9.3
Page Protect property, 2.4.1
pages
renumbering by repeating frame, 3.5.6
page-streamed output, 4.6.10.1.12
paginating HTML output
page-streamed HTML output, 2.8.8.1, 4.6.10.2.11, 4.7.16.5
pagination
in HTML, 2.8.8
paging, 4.7.16.6
Paper Design view
about, 1.6.4
displaying report output, 4.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, 4.6.9
vs. JSP-based report, 4.6.10
parameter
about, 1.9.1
creating LOV, 4.11.3
Parameter Form, 42
adding pages, 4.11.8
default, 4.11.5
displaying at runtime, 4.11.7
footer, 4.6.10.1.6
HTML extensions, 2.5.1
HTML, changing input to uppercase, 4.11.13
HTML, creating field with events, 4.11.12
in Web reports, 4.11.7
objects, about, 1.9, 2.5
selecting parameters for, 4.11.6
suppressing, 4.7.15
working with, 4.11
Parameter Form footer, 2.2.3
HTML, 4.6.10.2.6
Parameter Form header, 2.2.3, 4.6.10.1.5
HTML, 4.6.10.2.5
Parameter Form view
about, 1.6.5
parameters
creating user, 4.11.2
in Runtime Parameter Form, 4.11.6
passing to batch reports, 4.11.9
referencing, about, 2.3.4
using system, 4.11.1
validating at runtime, 4.11.4
working with, 4.11
parent object
moving child outside, 4.9.11.2
patterns
about changing, 2.4.5
changing, 4.9.6.3
changing using PL/SQL, 4.9.6.4
in templates, 2.4.5
using in report, 18
working with, 4.9.6
PDF
output, 2.8.10, 4.7.6
output orientation, 4.7.14
Web links for paper-based reports, 2.2.4
performance
improving, 4.16.3, 4.16.4
physical page, 2.1.4
placeholder column
about, 2.3.3
creating, 4.8.12
formula for, 2.6.8
platforms, running on multiple, 4.5.10
PL/SQL
adding Web links to paper-based report, 4.6.10.2
changing colors and patterns, 4.9.6.4
changing text attributes, 4.9.2.10
defining, 4.13.2.1
in formulas, 4.8.10
using in report or template, 4.13
PL/SQL Editor
about, 2.6.1
working with, 4.13.2
PL/SQL Interpreter
about, 2.10.2
working with, 4.14.9
PL/SQL library
about, 2.6.6
adding program unit, 4.13.5.2
attaching, 4.13.5.5
converting, 4.13.5.6
creating, 4.13.5.1
editing program unit, 4.13.5.3
removing program unit, 4.13.5.4
pluggable data source (PDS)
accessing, 4.15.2
pluggable destinations, 2.8.4
Portal, 4.12.10, 4.15.1
portlet, 4.12.10
portrait orientation, 4.7.14
PostScript, 4.7.17.2, 4.7.17.6
preferences
color palette, 4.2.6, 4.9.6.1
Object Navigator, 4.2.4
report, 4.2.3
setting, 4.2
preprinted form
printing, 4.7.17.4
report, 32
Previewer, 4.7.17.2
about, 1.11.2
displaying report output, 4.7.16.3
printing report, 4.7.17.2
primary key, 11
Print Object On property, 2.4.1
printable area, 4.7.16.1
PRINTER
output orientation, 4.7.14
printer dependency, 4.7.17.6
printer tray
switching, 2.8.6, 4.7.17.5
printing
format order, 2.8.1
preprinted form, 4.7.17.4
report, 4.7.17
UNIX, 4.7.17.6
PRINTJOB system parameter, 1.9.1
program unit
about, 2.6.4
compiling and running, 4.13.6
controlling execution, 4.14.11
creating, 4.13.3.1
debugging, 4.14.11
deleting, 4.13.3.3
editing, 4.13.2.3
moving between client and server, 4.13.3.4
searching and replacing in, 4.13.2.2
properties
comparing, 4.2.8
multiple objects, 4.2.7
report, 4.2.2, 4.2.5
setting, 4.2
templates, 2.7.4
Property Inspector
about, 1.10.1
displaying, 4.2.1

Q

query
about, 1.7.1
building an XML query, 45.2.2
creating, 4.8.1
importing, 4.8.1.3
modifying, 4.8.2
non-linkable, about, 2.3.5
Query Builder, 4.8.1.3, 4.8.3
about, 1.7.5

R

range of data
aggregating, 30
ranking report, 34
reading direction
changing, 4.9.2.9
reducing output, 4.7.16.8
REF CURSOR, 2.6.10
ref cursor
creating links between queries, 41.5
query, creating, 41.3
type, defining, 41.2
REF CURSOR query
about, 2.6.10
Ref Cursor Query tool, 4.8.1.7
Referenced By node, 4.14.17
References node, 4.14.17
referencing columns and parameters
about, 2.3.4
referencing field, 4.9.2.5
renaming report, 4.3.5
renumbering pages by repeating frame, 3.5.6
repeating frame
about, 1.8.2
creating, 4.9.1.2
renumbering pages by, 3.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, 4.2.5, 4.5.9
bursting, 37.2
check printing, 3.5.4
common tasks, 4.3
conditional form letter, 23, 23, 23
converting, 4.16.2
creating, 4.5.1
creating a table of contents, 35.2
creating an index, 35.3
creating multilevel TOC, 36
debugging, 4.14
definition, 1.2.1
deploying, 4.7.13
dimensions, 2.1.4
distributing, 4.7.12
distributing to multiple destinations, 37
e-mailing, 4.7.18
form letter, conditional, 23, 23, 23
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, 4.9.9.2, 17
intermixed fields, 20
JSP-based, 42
layout, 4.9
mailing label, 6
master/master, 8
matrix, 25
matrix with group, 27
modifying page layout, 4.9.14
preferences, 4.2.3
preprinted form, 32
printing, 4.7.17
properties, 4.2.2, 4.2.5
ranked data, 34
renumbering pages by repeating frame, 3.5.6
running, 4.7.1, 4.7.2, 4.7.3, 4.7.4
running and dispatching, 4.7
running in batch mode, 4.11.9
sections, 2.1.2, 4.10
summary, 9
tabular, 5
template, working with, 4.12
time series calculations, 28
title, 2.1.1, 4.5.6
tracing distribution, 4.14.19
tracing execution, 4.14.18
trigger, creating, 4.13.3.5
trigger, deleting, 4.13.3.6
unit of measurement, 2.1.3
using PL/SQL, 4.13
wrapped break, 15
Report Block Wizard
about, 1.4.2
glossary, Glossary
Report Editor
about, 1.6.1
displaying view, 4.4.1
report trigger
about, 2.6.13.1
creating, 4.13.3.5
deleting, 4.13.3.6
Report Wizard
about, 1.4.1
creating query, 4.8.1.1
creating report, 1.2.1.1
glossary, Glossary
Reports Builder
about, 1.1.1
executables, 1.12
Reports Server, 1.12, 4.1.2, 4.7.4
REPORTS_CLASSPATH, updating, 43.1.1
resizing objects, 4.9.12
about, 2.4.6
role
database, setting, 4.16.1
rotating objects, 4.9.11.8
row
alternating colors, 4.9.6.9
highlighting, 4.9.6.8
row colors
applying alternating row colors, 45.2.5
rows
blank lines between groups, 4.9.13.5
spacing between, 4.9.13.4
RTF
output, 2.8.11, 4.7.8
output orientation, 4.7.14
RUNDEBUG, 4.14.2
running
program units, 4.13.6
report, 4.7, 4.7.1, 4.7.2, 4.7.3, 4.7.4
runtime
modifying code, 2.10.9, 4.14.13
Runtime Parameter Form
adding pages, 4.11.8
displaying, 4.11.7
selecting parameters for, 4.11.6
with HTML, 2.5.1
Runtime Parameter Formr
about, 1.11.1
rwbuilder, 1.12
rwclient, 1.12
rwconverter, 1.12
rwrun, 1.12
rwserver, 1.12
rwservlet, 1.12

S

saving report, 4.3.3
Scalable Vector Graphic (SVG) support, 39.1
schemas, Preface
scope location
about, 2.10.7
displaying, 4.14.14
SCOTT schema, Preface
screenprinter.ppd, 4.7.17.6
scrolling, 4.7.16.6
searching
in Object Navigator, 4.4.3
program unit, 4.13.2.2
sections
about, 2.1.2
working with, 4.10
SELECT statement
moving into a package, 41.8
selecting objects, 4.3.7.1
server
moving program unit to, 4.13.3.4
server-side
program unit, creating, 4.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, 4.9.12.2
Snap to Grid, 4.9.13.3
Source pane
about, 2.10.3
spacing
changing, 4.9.13, 4.9.13.3
changing text, 4.9.2.9
default layout, 4.9.13.3
text, changing, 4.9.2.9
splitting viewing region, 4.7.16.7
spreadsheet
output, 2.8.13
spreadsheet output
generating, 4.7.11
SQL Query tool, 4.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, 4.6.10.2.6
SRW.SET_AFTER_PAGE_HTML, 2.8.8, 4.6.10.2.4
SRW.SET_AFTER_REPORT_HTML, 4.6.10.2.2
SRW.SET_BACKGROUND_BORDER_COLOR, 2.4.5, 4.9.6.4
SRW.SET_BACKGROUND_FILL_COLOR, 2.4.5, 4.9.6.4
SRW.SET_BEFORE_FORM_HTML, 1.9.4, 4.6.10.2.5
SRW.SET_BEFORE_PAGE_HTML, 4.6.10.2.3
SRW.SET_BEFORE_REPORT_HTML, 4.6.10.2.1
SRW.SET_BOOKMARK, 4.6.10.2.10
SRW.SET_BORDER_PATTERN, 2.4.5, 4.9.6.4
SRW.SET_CHARMODE_TEXT, 4.9.2.10
SRW.SET_FILL_PATTERN, 2.4.5
SRW.SET_FONT_FACE, 4.9.2.10
SRW.SET_FONT_SIZE, 4.9.2.10
SRW.SET_FONT_STYLE, 4.9.2.10
SRW.SET_FONT_WEIGHT, 4.9.2.10
SRW.SET_FOREGROUND_BORDER_COLOR, 2.4.5, 4.9.6.4
SRW.SET_FOREGROUND_FILL_COLOR, 2.4.5, 4.9.6.4
SRW.SET_FORMAT_ORDER, 2.8.1, 4.5.7, 35, 35.2.3, 36.3
SRW.SET_HYPERLINK_ATTRS, 4.6.10.2.7
SRW.SET_JUSTIFICATION, 4.9.2.10
SRW.SET_LINKTAG, 4.6.10.2.8
SRW.SET_PAGE_NAVIGATION_HTML, 4.6.10.2.11
SRW.SET_PDF_ACTION, 4.6.10.2.9
SRW.SET_PRINTER_TRAY, 2.8.6
SRW.SET_TEXT_COLOR, 2.4.5, 4.9.6.4
Stack node, 4.14.14, 4.14.15
Stored PL/SQL Editor
about, 2.6.2
copying syntax into, 4.13.2.4
stored program unit
about, 2.6.5
creating, 4.13.3.2
STPROC built-in package, 2.6.12.2
style sheets
about, 2.2.11
subprogram references, viewing, 4.14.17
summary
in matrix report, 25
summary column
about, 2.3.1
creating, 4.8.11, 36.4
for header, 17.3
vs. formula column, 14
summary report, 9
SUMMIT schema, Preface
suppressing Parameter Form, 4.7.15
Syntax Palette
about, 2.6.3
using to copy syntax, 4.13.2.4
system parameter
about, 1.9.1
referencing, about, 2.3.4
using, 4.11.1

T

table of contents
creating, 2.8.1, 4.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, 4.12.6
applying to report, 2.7.3, 4.12.4
attributes, about, 2.7.2
creating, 4.12.1
creating HTML for report portlet, 4.12.10
defining default attributes, 4.12.2
defining override attributes, 4.12.3
inheritance, 2.7.4
modifying body objects, 4.12.8
modifying margin objects, 4.12.7
properties, 2.7.4
setting title attributes, 4.12.5
using PL/SQL, 4.13
working with, 4.12
Template Editor
about, 2.7.5
text
objects, 4.9.2
output, 2.8.14, 4.7.9
spacing, changing, 4.9.13.2
wrapping, 4.9.2.8
text attributes
changing, 4.9.2.9
changing using PL/SQL, 4.9.2.10
Text Color tool, 2.4.5
Text Query tool, 4.8.1.6
TEXT_IO built-in package, 2.6.12.2
time format masks, 4.9.7.1
time series calculations report, 28
time/date stamps, 4.9.3
title
adding to report, 4.5.6
report, about, 2.1.1
template, 4.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, 4.14.20
tracing
report distribution, 4.14.19
report execution, 4.14.18
TRACE function, 4.14.20
trailer page
creating object in, 4.9.10.2
Trailer Section, 4.10.1
translating
report to other languages, 4.5.11
trigger
about, 2.6.13
database, creating, 4.13.3.7
debug, setting, 4.14.4
format, creating, 4.13.4.1
report, creating, 4.13.3.5
report, deleting, 4.13.3.6

U

uiscreenprint.txt, 4.7.17.6
unit of measurement, 2.1.3
UNIX, 4.7.17.6
uppercase
Parameter Form input, 4.11.13
URL
for image, 4.8.6
linking image to, 2.2.3, 4.9.8.1.3
user exits, 2.9.3
user parameter
about, 1.9.1
creating, 4.11.2

V

validating parameters at runtime, 4.11.4
validation trigger
about, 2.6.13.3
using, 4.11.4
variables
examining or changing, 4.14.15
Vertical Gap, 4.9.13.3
Vertical Interfield, 4.9.13.3
Vertical Panels per Page property, 2.1.4
vertical spacing
adding, 6.3
viewing output, 4.7.16
viewing region, splitting, 4.7.16.7

W

Web browser
displaying report output, 4.7.16.4
printing report, 4.7.17.3
Web links
adding to paper-based report, 4.6.10
Web report, 42
about, 1.2.2, 2.2
Parameter Form, 1.9.4, 4.11.7, 4.11.7
previewing, 2.2.2
vs. paper-based, 2.8.8
Web Source view
about, 1.6.6
white space
adding, 8.5, 10.2.3
width
column, changing, 4.9.13.1
Width property, 2.1.4, 4.7.14
wizard
glossary, Glossary
wrapped break report, 15
wrapping text, 4.9.2.8

X

XML, 4.9.8.3.1
filtering data, 45.2.6
output, 2.8.7, 4.7.7
XML data source
building an XML query, 45.2.2
XML query
building, 45.2.2
XML Query tool, 4.8.1.4