Oracle9i Reports Building Reports -- Index

$REPORTS_TMP environment variable, 2-10

across break report, 20-1

administering Reports Builder, 3-169

after form escape, 2-19

After Form Value property, 1-44

after page escape, 2-18

After Parameter Form trigger, 2-64

after report escape, 2-18

After Report trigger, 2-64

aggregating data report, 29-1

aligning objects, 3-110

alternate pages, displaying object, 3-78

alternating row colors, 8-11

anchors

about, 2-38

collapsing, 2-41

explicit, 2-40

implicit, 2-39

working with, 3-86

application command line link, 3-32

about, 2-18

using PL/SQL, 3-43

application program interface (API), 3-4

archiving report, 3-14

ASCII report, 2-86, 3-6, 3-22

attached library

about, 2-53

attaching, 3-152

removing program unit, 3-151

attributes

template, 3-130, 3-132

B_OR$REPORT_TITLE, 2-2, 3-132

barcode

creating using barcode font, 3-77

creating using barcode JavaBean, 5-1

in a paper report, 5-5

in Web report, 5-15

JavaBean, initializing, 5-21

batch mode

about, 2-73

passing parameters, 3-124

before form escape, 2-18

Before Form Value property, 1-44

before page escape, 2-18

Before Parameter Form trigger, 2-64

before report escape, 2-18

Before Report trigger, 2-64

Between Pages trigger, 2-64

binary files (BFILEs) (Oracle9i), 2-89

binary large objects (BLOBs) (Oracle9i), 2-89

bind reference

about, 2-22

vs. lexical, 2-28

blank lines

between groups of rows, 3-114

body

template, 3-133

boilerplate

about, 1-39

creating for HTML tags, 3-35

creating for text, 3-78

Parameter Form, about, 1-43

resizing, 2-47

bookmark, 3-33

on break columns, 3-33

using PL/SQL, 3-44

borders

adjusting when moving objects, 3-109

resizing, 3-113

working with, 3-84

break column

multiple in group report, 15-10

single in group report, 15-2

break group

about, 1-32

adding column, 15-11

creating, 3-68

data model, 15-3

in nested matrix report, 26-1

multiple in group report, 15-13

break report, 15-2

across, 20-1

wrapped, 21-1

breakpoints

about, 2-103

setting, 3-157

built-in package

about, 2-60

SRW, 2-61

Tools, 2-61

using, 3-136

bursting

about, 6-1

report, 6-3

cash amounts, spelled out, 4-24, 32-1

cell group, 3-69

cell wrapper, 3-51

CGI, 1-4

Change View, 3-18

character large objects (CLOBs) (Oracle9i), 2-89

character-mode executable, 1-5

character-mode report, 2-86, 3-6, 3-22

check printing report, 4-24, 32-1

Child Dimension property, 2-6

child object

anchoring, 2-38

moving outside parent, 3-109

Clearcase, 1-6

client-side

moving program unit to, 3-146

program unit, creating, 3-144

color palette

importing or exporting, 3-90

modifying, 3-89

preferences, 3-8

colors

about changing, 2-45

alternating row colors, 8-11

changing, 3-88

changing using PL/SQL, 3-89

color palette, 3-8

in templates, 2-46

using in report, 24-2

working with, 3-87

column

adding to break group, 15-11

changing labels or widths, 3-113

database, 1-33

formula, 3-70

linking, 3-70

moving, 3-110

placeholder, 3-72

referencing, about, 2-22

summary, 3-71

Column Mode property, 2-34

column object (Oracle9i), 2-91

command file, 3-48

command line, 3-48

Common Gateway Interface (CGI), 1-4

compiling

program units, 3-153

conditional form letter report, 38-1

conditional formatting

about, 2-5

applying to object, 3-77

conditional highlighting report, 39-1

Confine mode, 3-85, 3-109, 3-111

connecting to database, 3-11

converting

report, format, 3-170

COPIES system parameter, 1-41

copying report, 3-12

cross product group, 25-1

cross-product group

creating, 3-69

cross-product groups

about, 1-32

cross-product report

about, 1-13

CURRENCY system parameter, 1-41

currency, spelled out, 4-24, 32-1

cursor

vs. cursor variable, 2-31

cursor variable

about, 2-31

custom format mask, 3-100

data

filtering, 8-13

data link, 16-2

about, 1-34

creating, 3-69

non-linkable query, 2-28

vs. groups, 2-29

data model

break group, 15-3

objects, about, 1-28, 2-20

working with, 3-63

Data Model view

about, 1-24

data sources, 3-x

about XML, 8-2

non-Oracle, accessing, 3-167

data within ranges report, 29-1

Data Wizard

about, 1-20

creating query, 3-64

database

connecting, 3-11

selecting HTML tags, 3-37

selecting image, 3-103

trigger, creating, 3-148

database column, 1-33

Database Objects node, 2-50

database role

about, 2-87

setting, 3-169

database trigger

about, 2-66

creating, 3-148

database values

in header, 3-106, 23-1

date format masks, 3-93

date/time stamps, 3-82

DDE built-in package, 2-61

debug actions

about, 2-103

working with, 3-158

DEBUG built-in package, 2-61

debug level

about, 2-105

debug mode, 3-156

debug trigger

about, 2-104

debug trigger, setting, 3-157

debugging report, 3-155

debugging tools, 2-100

DECIMAL system parameter, 1-42

default format masks, 3-100

default layout

creating, 3-20

section, 3-118

default layout spacing, 3-114

Default node, 2-70

default Parameter Form, 3-123

deleting

program unit, 3-146

deleting object, 3-16

deleting report, 3-13

delimited output

about, 2-81

generating, 3-51

deprecated functionality, 1-4, 3-3

DESFORMAT system parameter, 1-42

DESNAME system parameter, 1-42

DESTINATION keyword, 2-74

DESTYPE system parameter, 1-42

dimensions, report, 2-4

direction

for reading text, changing, 3-81

dispatching report, 3-46, 3-48

distributing

report, 3-52

distribution

about, 2-73, 6-1

DESTINATION keyword, 2-74

DST file, 2-74

editing XML definition, 6-5

example report, 6-1

report, tracing, 3-165

docroot, 2-10

document root directory, 2-10

dollar amounts, spelled out, 4-24, 32-1

drawing

importing, 3-103

drawing object, 3-101

DST file

about, 2-74

dynamic graphics report, 40-1

editing

program unit, 3-138

e-mailing report, 3-61

environment variables

changes this release, 1-7

escape

before and after, 2-18

Event-based publishing, 1-3

event-based publishing

about, 2-76

examples and demos, 3-4

EXEC_SQL built-in package, 2-61

executablesr

about, 1-48

execution

report, tracing, 3-164

execution location

current, about, 2-105

explicit anchors, 2-40

Express

building report with, 9-1

Express Server, 9-3

Express Server Query tool, 3-66

external PL/SQL library

about, 2-52

adding program unit, 3-151

attaching, 3-152

converting, 3-152

creating, 3-151

editing program unit, 3-151

removing program unit, 3-151

working with, 3-150

field

about, 1-39

changing format mask, 3-100

creating, 3-74

Parameter Form, about, 1-43

referencing, 3-80

fields

intermixed in report, 31-1

file

linking from HTML object, 3-36

Fill Color tool, 2-45

filter

about, 1-32

group, creating or editing, 3-149

Flex mode, 3-85, 3-109, 3-110

font

changing, 3-81

font mappings, 3-7

fonts

applying different, 24-1

footer

group, 3-107

footer and header report, 22-1

footer, document

HTML, 2-15, 3-29, 3-39

footer, page

HTML, 2-15, 3-29, 3-40

footer, Parameter Form

HTML, 2-16, 3-30, 3-41

footers, 3-105

foreign key, 16-2

form

report on pre-printed, 33-1

form letter report, 13-1

about, 1-12

conditional, 38-1

format exceptions, 2-5

format masks

working with, 3-93

format trigger

about, 2-65

creating, 3-149

layout objects, 2-34

form-like report

about, 1-12

formula column, 19-1

about, 2-21, 2-53

creating or editing, 3-70

formula for, 2-53

vs. summary column, 19-2

formula report, 19-1

frame

about, 1-36

creating, 3-75

szing, 1-38

frequency

layout object, 2-34

functionality

, 3-3

Get Info, 1-6

Global Variables node, 3-164

Grant, 1-6

graph

paper report, 3-101, 3-102

Web report, 3-102

Graph Wizard, 1-3, 3-101

about, 1-21

graphic objects, 3-100

graphics

adding to report, 24-1

dynamic, 40-1

Graphics Builder, 1-5

group

creating break, 3-68

creating matrix, 3-69

header or footer, 3-107

linking, 3-70

vs. data link, 2-29

group above report, 16-1

about, 1-11

building, 16-3

with matrix, 27-1

group filter

about, 1-32, 2-55

creating or editing, 3-149

vs. Maximum Rows to Fetch property, 2-55

group left report, 15-2

about, 1-12

with database values in header, 23-1

with header and footer, 22-1

group left summary report, 18-1

group report

grouped in middle, 31-1

offsetting detail fields, 3-110

single-query, 15-1

two-query, 16-1

groups

about, 1-32

header

group, 3-107

report, 3-106

header and footer report, 22-1

header page

creating object in, 3-108

Header Section, 3-118

header with database values report, 3-106, 23-1

header, document

HTML, 2-15, 3-28, 3-38

header, page

HTML, 2-15, 3-29, 3-39

header, Parameter Form

HTML, 2-16, 3-30, 3-41

headers

page and group, working with, 3-105

heading, 23-6

report, 3-106

Height property, 2-4

hiding or showing components, 3-16

hierarchy

in Object Navigator, 3-18

highlighting

boilerplate, 24-2

conditional, 39-1

row in report, 3-92

value in report, 3-91

Horizontal Gap, 3-114

Horizontal Interfield, 3-114

Horizontal Panels per Page property, 2-4

HTML

font sizes, 2-13

in boilerplate text, 3-35

in Reports Builder, about, 2-12

including image URL, 3-104

linking object to file, 3-36

output, 2-76, 3-49

paginating output, 2-77, 3-44, 3-57

pagination, 2-13

Parameter Form extensions, 2-48

selecting tags from database, 3-37

style sheets, 2-19

HTML document footer, 2-15, 3-29

using PL/SQL, 3-39

HTML document header, 2-15, 3-28

using PL/SQL, 3-38

HTML page footer, 2-15, 3-29

using PL/SQL, 3-40

HTML page header, 2-15, 3-29

using PL/SQL, 3-39

HTML page-streamed output, 3-34

HTML Parameter Form

changing input to uppercase, 3-127

creating field with events, 3-124

HTML Parameter Form footer, 2-16, 3-30, 3-41

HTML Parameter Form header, 2-16, 3-30

using PL/SQL, 3-41

HTMLCSS

output, 3-49

Human Resources schema, 3-x

hyperlink, 3-31

about, 2-17

using PL/SQL, 3-42

hyperlink destination, 3-31

about, 2-17

PL/SQL, 3-42

image

about, 2-37

adding to report, 24-1

importing, 3-103

linking to URL, 3-34

selecting from database, 3-103, 3-104

image objects, 3-100

implicit anchors, 2-39, 3-86

algorithm, 2-42

importing

drawing or image, 3-103

SQL query, 3-65

intermixed fields report, 31-1

J2EE, 1-3

Java classes

importing, 5-6

Java Database Connectivity (JDBC), 3-167

Java documentation, 3-4

Java importer, 3-168, 5-6

JavaBean

importing, 5-6

using for a Web report, 5-15

using in a paper report, 5-5

JavaServer Pages (JSPs)

about, 2-8

JDBC, 3-167

JDBC Query tool, 3-65

JDBC-ODBC bridge, 3-167

JDeveloper, 1-3

JNI built-in package, 2-63

join, 16-2

JSP

about, 2-8

JSP-based Web report, 3-xi

justification

changing, 3-81

Keep With Anchoring Object property, 2-34

label

changing, 3-113

labels

suppressing, 36-1

landscape, 3-53

large objects (LOBs) (Oracle9i), 2-88

layering objects, 3-111

about, 2-47

layout

additional, 3-21

default spacing, 3-114

default, creating, 3-20

default, section

section

Layout Model view, 1-7

layouts

merging, 18-12

lexical reference

about, 2-24

vs. bind, 2-28

library

adding program unit, 3-151

attached, 2-53

attaching, 3-152

converting, 3-152

creating, 3-151

editing program unit, 3-151

external PL/SQL, 2-52

removing program unit, 3-151

Line Color tool, 2-45

link

about, 1-34

creating, 3-69

Link File tool, 3-34, 3-37

linking

boilerplate text object to file, 3-80

data links vs. groups, 2-29

image object, 3-104

query, non-linkable, 2-28

linking tables, 16-2

links

creating between ref cursor queries, 7-11

LIST built-in package, 2-62

list of values (LOV)

creating for parameter, 3-121

Live Previewer view, 1-7

logical page, 2-4

LONG column, 1-33

LONG RAW column, 1-33

magnifying output, 3-58

mailing label report, 12-1

about, 1-12

Main Section, 3-118

MAPI, 1-6

margin

adjusting, 3-116

creating object in, 3-107

template, 3-133

master/detail report, 15-2

master/detail/summary report, 18-2

master-master report, 14-1

matrix, 2-6

layout, 1-18

matrix data model

considerations, 1-13

matrix group

creating, 3-69

matrix object, 1-19

about, 2-31

creating in layout, 3-75

matrix report, 25-1

about, 1-13

nested, 26-1

with group, 2-6, 27-1

matrix with group report, 27-1

about, 2-6

Maximum Rows to Fetch property, 2-55

mode

Confine or Flex, 3-85

MODE system parameter, 1-42

moving objects, 3-108

about, 2-47

multiple destinations

distributing to, 6-1

report output, 3-52

multiple layouts, 18-7

multiple objects

making same size, 3-112

moving, 3-109

multiple platforms, 3-22

multiple queries, 16-1

about, 1-30

linking, 16-2

linking, about, 1-34

master-master report, 14-1

multi-query reports, 1-30

National Language Support (NLS), 3-23

navigation controls

about, 2-77

using PL/SQL, 3-44

using properties, 3-34

nested matrix report, 26-1

about, 2-6

Net8, 2-88

new features, 1-3, 3-3

node

in Object Navigator, 3-17

non-linkable query

about, 2-28

non-Oracle data sources

accessing, 3-167

number format masks, 3-95

numbering pages

renumbering by repeating frame, 4-27, 34-1

Object Navigator

about, 1-22

changing views, 3-18

hiding or showing components, 3-16

Oracle9i functionality, 2-98

preferences, 3-6

working with, 3-17

object table (Oracle9i), 2-91

Object Type View, 1-23, 3-18

objects

common tasks, 3-11

obsolete functionality, 1-5, 3-3

OCA, 3-167

OCI, 1-6

ODBC, 3-167

OEM, 1-4

OLE2, 1-4

online help, 3-xi, 3-2

Open Database Connectivity (ODBC), 3-167

opening report, 3-11

ORA_DE built-in package, 2-63

ORA_FFI built-in package, 2-62, 3-168

ORA_JAVA built-in package, 2-62, 3-168

ORA_NLS built-in package, 2-62

ORA_PROF built-in package, 2-62

Oracle Call Interface (OCI), 1-6

Oracle drawing format, 1-6

Oracle Enterprise Manager (OEM), 1-4

Oracle Graphics, 1-5

Oracle Net Services, 2-88

Oracle Open Client Adapter (OCA), 3-167

Oracle Reports Services, 3-3

Oracle Technology Network, 3-xi

Oracle9i, 2-88

Oracle9i JDeveloper, 1-3

Oracle9i Reports

about this release, 1-3

and JSPs, 2-9

Order Entry schema, 3-x

orientation, 3-53

ORIENTATION system parameter, 1-42

outer join, 16-2

output

about, 2-72

delimited, 2-81, 3-51

displaying in Paper Design view, 3-55

displaying in Previewer, 3-56

displaying in Web browser, 3-56

HTML and HTMLCSS, about, 2-76

HTML, HTMLCSS or PDF, 3-49

magnifying or reducing, 3-58

PDF, 2-79

RTF, 2-80, 3-51

splitting view, 3-58

text, 2-86, 3-52

viewing, 3-54

XML, 2-79, 3-50

Override node, 2-70

overview

functionality, 3-3

new features, 3-3

Oracle9i Reports, 3-2

Ownership View, 1-23, 3-18

package

creating, 5-7

moving a SELECT statement into, 7-17

moving into a library, 7-20

using built-in, 3-136

page break, adding, 3-116

page layout, modifying, 3-116

page numbers, 3-82

Page Protect property, 2-34

pages

renumbering by repeating frame, 4-27, 34-1

page-streamed output, 3-34

paginating HTML output

page-streamed HTML output, 2-77, 3-44, 3-57

pagination

in HTML, 2-13

paging, 3-58

Paper Design view

about, 1-25

displaying report output, 3-55

Paper Layout view

about, 1-24

paper-based report

HTML output, 2-15

PDF output, 2-16

preparing for Web, 3-26

vs. JSP-based report, 3-27

parameter

about, 1-41

creating LOV, 3-121

Parameter Form

adding pages, 3-124

default, 3-123

displaying at runtime, 3-123

footer, 3-30

HTML extensions, 2-48

HTML, changing input to uppercase, 3-127

HTML, creating field with events, 3-124

in Web reports, 1-44, 3-123

objects, about, 1-40, 2-48

selecting parameters for, 3-123

suppressing, 3-54

working with, 3-120

Parameter Form footer, 2-16

HTML, 3-41

Parameter Form header, 2-16, 3-30

HTML, 3-41

Parameter Form view, 1-8

about, 1-26

parameters

creating user, 3-121

in Runtime Parameter Form, 3-123

passing to batch reports, 3-124

referencing, about, 2-22

using system, 3-120

validating at runtime, 3-122

working with, 3-120

parent object

anchoring, 2-38

moving child outside, 3-109

patterns

about changing, 2-45

changing, 3-88

changing using PL/SQL, 3-89

in templates, 2-46

using in report, 24-2

working with, 3-87

PDF

in Reports Builder, about, 2-12

output, 2-79, 3-49

Web links for paper-based reports, 2-16

performance

improving, 3-170

physical page, 2-4

placeholder column

about, 2-22

creating, 3-72

formula for, 2-53

platforms, running on multiple, 3-22

PL/SQL

adding Web links to paper-based report, 3-38

changing colors and patterns, 3-89

changing text attributes, 3-82

defining, 3-136

in formulas, 3-70

Oracle9i support, 2-99

using in report or template

report

PL/SQL Editor

about, 2-49

working with, 3-136

PL/SQL Interpreter

about, 2-101

working with, 3-159

PL/SQL library

about, 2-52

adding program unit, 3-151

attaching, 3-152

converting, 3-152

creating, 3-151

editing program unit, 3-151

removing program unit, 3-151

PL/SQL report, 35-1

pluggable data source (PDS)

accessing, 3-167

using XML, 8-2

portrait, 3-53

preferences

color palette, 3-8, 3-88

Object Navigator, 3-6

report, 3-6

setting, 3-5

pre-printed form

printing report, 3-61

pre-printed form report, 33-1

Previewer

displaying report output, 3-56

printing report, 3-59

Previewerr

about, 1-47

primary key, 16-2

Print Object On property, 2-34

printable area, 3-55

printer tray

switching, 2-76

printer tray, switching, 3-61

printing report, 3-59

pre-printed form, 3-61

PRINTJOB system parameter, 1-42

program unit

about, 2-50

compiling and running, 3-153

controlling execution, 3-161

creating, 3-144

debugging, 3-161

deleting, 3-146

editing, 3-138

moving between client and server, 3-146

searching and replacing in, 3-137

properties

comparing, 3-9

multiple objects, 3-9

report, 3-5, 3-6

setting, 3-5

templates, 2-72

Property Inspector

about, 1-45

displaying, 3-5

Property Palette, 1-8

PVCS, 1-6

query

about, 1-28

building an XML query, 8-6

creating, 3-63

importing, 3-65

modifying, 3-67

non-linkable, about, 2-28

Query Builder, 3-64, 3-68

about, 1-36

range of data

aggregating, 29-1

ranking report, 37-1

reading direction

changing, 3-81

reducing output, 3-58

REF column (Oracle9i), 2-91

ref cursor

creating links between queries, 7-11

query, creating, 7-7

type, defining, 7-5

ref cursor query

about, 2-57

Ref Cursor Query tool, 3-66

Referenced By node, 3-164

References node, 3-164

referencing columns and parameters

about, 2-22

referencing field, 3-80

Rename, 1-6

renaming report, 3-13

renumbering pages by repeating frame, 4-27, 34-1

repeating frame

about, 1-37

creating, 3-75

renumbering pages by, 4-27, 34-1

sizing, 1-38

report

about creating, 1-8

across break, 20-1

aggregating data within ranges, 29-1

ASCII, 2-86, 3-6, 3-22

bursting, 6-3

check printing, 4-24, 32-1

common tasks, 3-11

conditional form letter, 38-1

conditional highlighting, 39-1

converting, 3-170

creating, 3-19

debugging, 3-155

definition, 1-8

dimensions, 2-4

distributing, 3-52

distributing to multiple destinations, 6-1

dynamic graphics, 40-1

e-mailing, 3-61

form letter, 13-1

form letter, conditional, 38-1

formula, 19-1

graphics, text, and color, 24-1

group above, 16-1

group in middle, 31-1

group left, 15-2

group left summary, 18-1

header and footer, 22-1

header with database values, 3-106, 23-1

intermixed fields, 31-1

layout, 3-74

mailing label, 12-1

master-master, 14-1

matrix, 25-1

matrix with group, 27-1

modifying page layout, 3-116

nested matrix, 26-1

PL/SQL, 35-1

preferences, 3-6

pre-printed form, 33-1

printing, 3-59

properties, 3-5, 3-6

ranked data, 37-1

renumbering pages by repeating frame, 4-27, 34-1

running, 3-46, 3-48

running and dispatching, 3-46

sections, 2-3, 3-118

summary, 17-1

suppressing labels, 36-1

tabular, 11-1

template, working with, 3-129

time series calculations, 28-1

title, 2-2, 3-21

tracing distribution, 3-165

tracing execution, 3-164

trigger, creating, 3-147

trigger, deleting, 3-147

unit of measurement, 2-4

wrapped break, 21-1

Report Block Wizard

about, 1-20

Report Editor

about, 1-23

displaying view, 3-17

hiding or showing components, 3-16

views, 1-7

Report on Reports, 1-6

report trigger

about, 2-64

creating, 3-147

deleting, 3-147

Report Wizard

about, 1-20

creating query, 3-64

creating report, 1-8

Express report, 9-4

reports

about Web, 1-9

running in batch mode, 3-124

Reports Background Engine, 1-5

Reports Builder

about, 1-2

executables, 1-48

Reports Server, 1-49, 3-3, 3-48

Reports Web Cartridge, 1-4

REPORTS_CLASSPATH, updating, 5-4

REPORTS_COMMON_AUTH, 1-4

REPORTS_COOKIE_EXPIRE, 1-4

REPORTS_DB_AUTH, 1-4

REPORTS_ENCRYPTION_KEY, 1-4

REPORTS_FULL_UI, 1-6

REPORTS_JNI_LIB, 1-6

REPORTS_SERVER REPORTS_NO_DUMMY_PRINTER, 1-4

REPORTS_SPLASH, 1-6

REPORTS_SYS_AUTH, 1-4

REPORTS_TAGLIB_URI_SAV, 1-6

REPORTS_TMP environment variable, 2-10

REPORTS_XSL_TEMPLATE, 1-6

resizing objects, 3-112

about, 2-47

role

database, setting, 3-169

rotating objects, 3-111

row

highlighting, 3-92

row colors

applying alternating row colors, 8-11

rows

blank lines between groups, 3-114

spacing between, 3-114

RTF

output, 2-80, 3-51

RUNDEBUG, 3-156

running

program units, 3-153

running report, 3-46, 3-48

runtime

modifying code, 2-106, 3-162

Runtime Parameter Form

adding pages, 3-124

displaying, 3-123

selecting parameters for, 3-123

with HTML, 2-48

Runtime Parameter Formr

about, 1-46

Runtime Previewer, 1-8

rwbuilder, 1-48

rwcgi, 1-48

rwcgixx, 1-4

rwclient, 1-48

rwconverter, 1-49

rwrun, 1-48

rwrunxxc, 1-5

rwserver, 1-49

rwservlet, 1-49

saving report, 3-12

schemas, 3-x

scope location

about, 2-105

displaying, 3-163

SCOTT schema, 3-x

scrolling, 3-58

searching

in Object Navigator, 3-18

program unit, 3-137

sections

about, 2-3

working with, 3-118

SELECT statement

moving into a package, 7-17

selecting objects, 3-14

server

moving program unit to, 3-146

server-side

program unit, creating, 3-145

Servlets, 2-8

.SET_PAGE_NAVIGATION_HTML, 3-45

showing or hiding components, 3-16

Single Sign-On, 1-3

single vs. multiple query group report, 16-2

single-query reports, 1-28

sizing

frame or repeating frame, 1-38

sizing objects, 3-112

Snap to Grid, 3-114

Software Configuration Manager (SCM), 1-6, 3-13, 3-14

source control, 3-13, 3-14

Source pane

about, 2-101

spacing

changing, 3-113

changing text, 3-81

default layout, 3-114

splitting viewing region, 3-58

SQL Query tool, 3-64

SQL*Net, 2-88

SRW built-in package, 2-61

SRW.SET_AFTER_FORM_HTML, 1-45, 3-42

SRW.SET_AFTER_PAGE_HTML, 2-13, 3-40

SRW.SET_AFTER_REPORT_HTML, 3-39

SRW.SET_ATTR masks, 1-4

SRW.SET_BACKGROUND_BORDER_COLOR, 2-45, 3-89

SRW.SET_BACKGROUND_FILL_COLOR, 2-45, 3-89

SRW.SET_BEFORE_FORM_HTML, 1-45, 3-41

SRW.SET_BEFORE_PAGE_HTML, 3-40

SRW.SET_BEFORE_REPORT_HTML, 3-39

SRW.SET_BOOKMARK, 3-44

SRW.SET_BORDER_PATTERN, 2-45, 3-89

SRW.SET_CHARMODE_TEXT SRW.SET_FONT_FACE SRW.SET_FONT_STYLE SRW.SET_FONT_WEIGHT SRW.SET_FONT_SIZE SRW.SET_JUSTIFICATION, 3-82

SRW.SET_FILL_PATTERN, 2-45

SRW.SET_FOREGROUND_BORDER_COLOR, 2-45, 3-89

SRW.SET_FOREGROUND_FILL_COLOR, 2-45, 3-89

SRW.SET_HYPERLINK_ATTRS, 3-42

SRW.SET_LINKTAG, 3-43

SRW.SET_PDF_ACTION, 3-43

SRW.SET_PRINTER_TRAY, 2-76

SRW.SET_TEXT_COLOR, 2-45, 3-89

SRW.TRACE_ADD_OPTIONS, 3-164

SRW.TRACE_END, 3-164

SRW.TRACE_REM_OPTIONS, 3-164

SRW.TRACE_START, 3-164

Stack node, 3-163

Stored PL/SQL Editor

about, 2-50

copying syntax into, 3-143

stored program unit

about, 2-52

creating, 3-145

STPROC built-in package, 2-63

style sheets

about, 2-19

subprogram references, viewing, 3-164

summary

in matrix report, 25-1

summary column

about, 2-21

creating, 3-71

for header, 23-5

vs. formula column, 19-2

summary report, 17-1

SUMMIT schema, 3-x

suppressing labels report, 36-1

suppressing Parameter Form, 3-54

Syntax Palette

about, 2-50

using to copy syntax, 3-143

system parameter

about, 1-41

referencing, about, 2-22

using, 3-120

tabular report, 11-1

about, 1-11

.tdf file, 2-68

template

about, 2-68

about colors and patterns, 2-46

adding items and objects, 3-132

applying to report, 2-71, 3-131

attributes, about, 2-69

creating, 3-129

defining default attributes, 3-130

defining override attributes, 3-130

inheritance, 2-71

modifying body objects, 3-133

modifying margin objects, 3-133

properties, 2-72

setting title attributes, 3-132

using PL/SQL, 3-136

working with, 3-129

Template Editor

about, 2-68

text

configuring the textpds.conf file, 10-3

output, 2-86, 3-52

spacing, changing, 3-113

wrapping, 3-81

text attributes

changing, 3-81

changing using PL/SQL, 3-82

Text Color tool, 2-45

text data source

configuring, 10-3

text objects, 3-78

Text Query tool, 3-66

TEXT_IO built-in package, 2-62

textpds.conf

editing, 10-3

THOUSANDS system parameter, 1-42

time format masks, 3-93

time series calculations report, 28-1

time/date stamps, 3-82

title

adding to report, 3-21

report, about, 2-2

template, 3-132

tool palette

about, 1-27

TOOL_ENV built-in package, 2-62

TOOL_ERR built-in package, 2-63

TOOL_RES built-in package, 2-63

toolbar

about, 1-27

Tools built-in package, 2-61

TRACE function, 3-165

tracing

report distribution, 3-165

report execution, 3-164

TRACE function, 3-165

trailer page

creating object in, 3-108

Trailer Section, 3-118

translation, of report to other languages, 3-23

trigger

about, 2-63

database, creating, 3-148

debug, setting, 3-157

format, creating, 3-149

report, creating, 3-147

report, deleting, 3-147

tutorial, 3-xi, 3-3

unit of measurement, 2-4

uppercase

Parameter Form input, 3-127

URL

for image, 3-104

linked from image, 3-34

linking image to, 2-16, 3-104

user exits, 1-4, 3-168

user interface

changes this release, 1-7

user parameter

about, 1-42

creating, 3-121

user-defined objects (Oracle9i), 2-91

validating parameters at runtime, 3-122

validation trigger

about, 2-66

using, 3-122

variables

examining or changing, 3-163

Vertical Gap, 3-114

Vertical Interfield, 3-114

Vertical Panels per Page property, 2-4

vertical spacing

adding, 12-6

viewing output, 3-54

viewing region, splitting, 3-58

Web browser

displaying report output, 3-56

printing report, 3-60

Web links

adding to paper-based report, 3-27

Web report

about, 1-9, 2-8

Parameter Form, 1-44, 3-123

previewing, 2-10

vs. paper-based, 2-12

Web Source view

about, 1-27

WEBSERVER_DOCROOT, 2-10

white space

adding, 14-6, 15-7

width

column, changing, 3-113

Width property, 2-4

wrapped break report, 21-1

wrapping text, 3-81

XML

filtering data, 8-13

output, 2-79, 3-50

XML data source

about, 8-2

building an XML query, 8-6

XML query

building, 8-6

XML Query tool, 3-65

Index

Symbols

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X