Index

A  B  C  D  E  F  H  I  J  L  M  O  P  Q  R  S  T  U  V  W 

---

A

accessing

database, 6

demo tables, 6

adding

boilerplate object, 115

bookmarks, 16, 71

format exception, 14

format masks, 68

HTML header to template, 36

hyperlink destinations, 73

hyperlinks, 74

hyperlinks to external destinations, 74

Javascript, 86, 90

summary columns, 138

applying template to report, 43

---

B

boilerplate object, adding, 115

bookmarks, adding, 16, 71

break group, creating, 28, 134

---

C

changing object properties, 111

chart, adding to summary section, 80

code, modifying, 20

columns, summary, 138

comment for book, ix

Conditional Formatting dialog box, about, 7

conditional formatting, about, 7

conditional hide/show for web output, 79

Confine Mode, defined, 114

creating

break group, 28, 134

data link, 29

data model, 27, 64, 96

default layout, 106

default report layout, 30

layout, 140

links between ref cursor queries, 136

package body, 143

pop-ups, 77

ref cursor query, 132

rollovers, 78

summary section with chart, 80

template, 34

---

D

data link, creating, 29

Data Model

objects, renaming, 28

refining, 98

view, description, 5

data model

creating, 27, 64, 96

Data Wizard

description, 3

using, 96

default attributes

overriding, 51

templates, 46

default layout, creating, 30, 106

defining

package spec, 130

ref cursor types, 130

demo table, accessing, 6

designing a Runtime Parameter Form, 105

distributing reports, 123

distribution, specifying, 123

---

E

external destinations, adding hyperlinks to, 74

---

F

fetching data, 127

Format Exception

dialog box, about, 7

format exception

adding, 14

adding to repeating frame, 19

format mask, adding, 68

Format Trigger property, about, 7

formatting objects in Live Previewer, 32

frames, re-arranging, 113

---

H

HTML

header, adding to template, 36

report, 61

report header, 70

hyperlink

adding, 74

adding to external destinations, 74

destinations, adding, 73

---

I

including HTML report header, 70

---

J

Javascript, adding, 86

---

L

Layout Model view

description, 5

formatting a report, 35

using, 110

layout, creating, 140

links, creating between ref cursor queries, 136

Live Previewer

description, 4

formatting objects, 32

using to modify a report, 12

---

M

modifying

code, 20

report output, 67

moving packages into a library, 145

multiple object selection, 13

---

O

object

boilerplate, adding, 115

properties, changing, 111

Object Navigator, description, 5

objects, re-arranging, 113

operating system considerations, 6

overriding template attributes, 51

---

P

package

body, creating, 143

moving a SELECT statement into, 143

moving into a library, 145

spec, defining, 130

page

breaks, specifying, 122

separator, changing, 72

Parameter Form view

description, 5

using, 105

PDF, generating, 16

PL/SQL, fetching data, 127

pop-ups, creating, 77

predefined template list, adding template, 40

Program Unit Editor, using, 132

properties, changing, 111

---

Q

query, rows returned, 69

---

R

re-arranging frames and objects, 113

ref cursor

queries, about, 127

queries, creating links between, 136

query, creating, 132

type, defining, 130

renaming Data Model objects, 28

repeating frame, adding formatting exception, 19

report

header, HTML, 70

output, modifying, 67

sections, about, 93

styles, viewing, 40

Report Builder

starting, 9, 151

what is, 1

Report Editor, description, 4

Report Wizard

description, 2

using, 10, 152

reports

basics, 1

conditional formatting, 7

Express, 149

ref cursors, 127

sections, 93

templates, 23

web, 61

required software, 6

rollover, creating, 78

rows returned by query, 69

Runtime Parameter Form, designing, 105

---

S

sections, about, 93

SELECT statement, moving into a package, 143

shift-clicking objects, 13

software required, 6

specifying report distribution, 123

SQL Query tool, using, 27

starting Report Builder, 9, 151

suggestions for book, ix

summary

columns, adding, 138

section, creating, 80

---

T

template

about, 23

adding HTML header, 36

adding to predefined template list, 40

applying to a report, 43

creating, 34

default attributes, 46

default attributes, overriding, 51

text conventions, xii

---

U

using

Data Wizard, 96

Layout Model view, 110

Report Wizard, 10, 152

Web Wizard, 71

---

V

viewing

report styles, 40

reports, 4

---

W

web report, 61

Web Wizard

description, 4

using, 71

wizards, description, 2