Download our latest
Android and iPhone apps ...
At a glance ...
Pages
360
Exercises
12
Sections
19
Public
On-Site
Level
2
Days
3

Course Name: Oracle Reports 6i

Duration:
Minimum skill level required:
On-Site course:
Public course:
Sections:
No of exercises:
No of pages in the manual:
Pre-Requisite course(s):
Suggested further course(s):
Price guide:
3 days
2 (1 - Beginner, 2 - Experienced 3 - Advanced)
Yes
No
19
12
360
Oracle Essential SQL 9i Oracle Essential PLSQL 9i
None
Contact us for the latest pricing

Synopsis for course

Oracle Reports 6i is a product specifically designed to enable users of an Oracle database to produce textual output of data, formatable in a variety of ways. You can produce data summaries, management information, graphical representations of data, output for other systems and specific record reporting.

Exercise highlights

Creating various styles of report
Modifying the report layout
Add summary and formula columns
Creating a parameter form

Course Contents

Section
Section Name
Page


One
Introduction to Reports 6i
2

 
- What is Reports?
3

 
- Report Types - Orientation
5

 
- Report Types - Tabular
7

 
- Report Types - Form-like
8

 
- Report Types - Mailing Label
9

 
- Report Types - Form Letter
10

 
- Report Types - Group Left
11

 
- Report Types - Group Above
12

 
- Report Types - Matrix
13

 
- Report Types - Matrix Group
15

 
- Output Types
16

Two
Running Reports
17

 
- Introduction
18

 
- Parameters
20

 
- Via Forms
21

 
- Running Reports
22

 
- Via Reports Runtime
25

 
- The Previewer Toolbar
30

 
- Exercise One
31

Three
Reports 6i Builder
37

 
- Introduction
38

 
- Object Navigator
41

 
- Object Navigator - Reports
44

 
- Object Navigator - Templates
46

 
- Object Navigator - External SQL queries
47

 
- Object Navigator - PL/SQL Libraries
48

 
- Object Navigator - Debug Actions
50

 
- Object Navigator - Stack
51

 
- Object Navigator - Built-in Packages
52

 
- Object Navigator - Database Objects
53

Four
Report Wizard
54

 
- Introduction
55

 
- Style
56

 
- Type
58

 
- Data
59

 
- Manual Entry
61

 
- Query Builder
62

 
- Importing
65

 
- Fields
66

 
- Minimum Effort
67

 
- Modifying Existing Reports
68

 
- Exercise Two
69

 
- Totals
72

 
- Labels
75

 
- Template
76

 
- Text
77

 
- Groups
78

 
- Rows
79

 
- Columns
80

 
- Cell
81

 
- In Conclusion
82

 
- Exercise Three
83

Five
Live Previewer
91

 
- Introduction
92

 
- Anatomy
94

 
- Functionality
95

 
- Toolbars
96

 
- Tool Palette
100

 
- Property Palette
101

 
- Buttons in the Live Previewer
102

 
- Exercise Four
103

Six
Data Model
109

 
- Introduction
110

 
- System Parameters
112

 
- User Parameters
113

 
- Queries/ Groups
114

 
- Formula Columns
115

 
- Summary Columns
116

 
- Placeholder Columns
117

 
- Data Links
118

 
- Creating Elements
119

 
- Data Model Interface - Anatomy
120

 
- Data Model Interface - Tool Bar
121

 
- Data Model Interface - Tool Palette
122

 
- Data Model Interface - SQL Query
123

 
- Data Model Interface - Formula Columns
126

 
- Data Model Interface - Summary Columns
129

 
- Data Model Interface - Placeholder Columns
132

 
- Data Model Interface - Data Links
134

 
- Data Model Interface - Ref Cursor Query
138

 
- Data Model Interface - Cross Product Groups
141

 
- Groups
143

 
- Deleting Goups
150

Seven
PL/SQL Editor
151

 
- Anatomy of the Editor
152

 
- Syntax
153

 
- Colour Coding
154

 
- Compiling
155

 
- Compilation Errors
156

 
- Commenting
159

 
- Navigation of Programs
160

 
- Exercise Five
161

Eight
Layout Model
164

 
- Introduction
165

 
- Anatomy
168

 
- Toolbar
173

 
- Tool Palette
175

 
- Rulers
177

 
- Frames
179

 
- Repeating Frames
180

 
- Editing Frames
183

 
- Performance Issues with Frames
185

 
- Frame Properties
186

 
- Confine Mode
192

 
- Flex Mode
193

 
- Conditional Formatting
194

 
- OLE Objects
200

 
- Additional Default Layout
201

 
- Anchors
202

 
- Buttons
204

 
- Exercise Six
206

Nine
Report Parameters
211

 
- Introduction
212

 
- User
213

 
- Defining LOV's
214

 
- Parameter Forms
218

 
- Usage
221

 
- Using Bind References
222

 
- Using Lexical References
225

 
- Exercise Seven
227

Ten
Triggers and Program Units
234

 
- Introduction
235

 
- Before Parameter Form
237

 
- After Parameter Form
238

 
- Before Report
239

 
- Between Pages
240

 
- After Report
241

 
- Program Units
242

 
- Defining Program Units
243

Eleven
Built-in Packages
244

 
- Introduction
245

 
- SRW
246

 
- SRW Package - Examples
247

 
- Exercise Eight
251

Twelve
Bookmarks
256

 
- Introduction
257

 
- Creating
259

 
- Creating Using PL/SQL
260

 
- Creating Using Property Palette
263

 
- Creating Using Web Wizard
264

 
- Viewing HTML or PDF pages
266

 
- Ordering/ Indentation
269

 
- Exercise Nine
271

Thirteen
Drill Down Reporting
273

 
- Introduction
274

 
- Creating
275

Fourteen
Templates
277

 
- Introduction
278

 
- Pre-Defined
279

 
- Custom Templates - Introduction
282

 
- Custom Templates - Toolbar
283

 
- Custom Templates - Objects
284

 
- Custom Templates - Incorporating
285

 
- Exercise Ten
291

Fifteen
Standards
296

 
- Data Model
297

 
- Layout Model
298

 
- Program Units and Reports
299

 
- Commenting
300

Sixteen
Incorporating Graphs
301

 
- Introduction
302

 
- Chart Wizard
304

 
- Oracle Graphics
313

Seventeen
LOBS in Reports
316

 
- What are LOBS?
317

 
- LOBS vs Long
318

 
- Temporary Space
319

 
- Accessing
320

 
- Exercise Eleven
322

Eighteen
Additional Features
323

 
- Exporting Data
324

 
- Compiler
326

Nineteen
PL/SQL Libraries
329

 
- Introduction
330

 
- Creating and Populating
331

 
- Attaching
332

 
- Updating
335

 
- Opening Report Modules
337

 
- Removing from Reports
339

Twenty
Help Facility
340

 
- Reports Builder Help Topics
342

 
- Quick Tour
343

 
- Cue Cards
344

 
- Manuals
345

 
- About Reports Builder
346

 
- Exercise Twelve
347