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
- 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, 50
- templates, 45
- 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, 50
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, 39
- 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
- summary
- columns, adding, 138
- section, creating, 80
T
- template
- about, 23
- adding HTML header, 36
- adding to predefined template list, 39
- applying to a report, 43
- creating, 34
- default attributes, 45
- default attributes, overriding, 50
- 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