Oracle Reports Building Reports -- Index

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_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

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

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

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

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

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

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

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

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

Keep With Anchoring Object property, 2-33

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

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

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

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

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

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

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

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

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

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

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

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

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

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