Oracle Reports Building Reports
Release 6i

A73172-01

Contents

Prev

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

Prev
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Contents