Download our latest
Android and iPhone apps ...
At a glance ...
Pages
515
Exercises
14
Sections
22
Public
On-Site
Level
2
Days
4

Course Name: Oracle Reports 9i

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:
4 days
2 (1 - Beginner, 2 - Experienced 3 - Advanced)
Yes
No
22
14
515
Oracle Essential SQL 9i Oracle Essential PLSQL 9i
None
Contact us for the latest pricing

Synopsis for course

Reports 9i 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.

Reports 9i allows the publication of output on the web, as well as allowing the production of paper based output.

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 9i
2

 
- What is Reports 9i ?
3

 
- Reports 9i Destinations
5

 
- Report Extensions in Reports 9i
6

 
- Running Reports
7

 
- Creating Dynamic Reports
8

Two
Reports 9i Builder
9

 
- Starting Reports 9i
10

 
- Object Navigator
13

 
- Object Navigator (Reports)
15

 
- Object Navigator (Templates)
17

 
- Object Navigator (PL/SQL Libraries)
18

 
- Object Navigator (Debug Actions)
20

 
- Object Navigator (Stack)
21

 
- Object Navigator (Built in Packages)
22

 
- Object Navigator (Database Objects)
23

Three
Report Wizard
24

 
- Starting the Report Wizard in Reports 9i
25

 
- Web and Paper Output in Reports 9i
29

 
- Report Styles in Reports 9i
31

 
- Tabular Report Style in 9i
32

 
- Group Left Report Style in 9i
33

 
- Group Above Report Style in 9i
35

 
- Matrix Report Style in 9i
36

 
- Matrix Group Report Style in 9i
39

 
- Form-like Report Style in 9i
40

 
- Form Letter Report Style in 9i
42

 
- Mailing Label Report Style in 9i
43

 
- Report Wizards Dialogs in Reports 9i
45

 
- Relationship of Tabs with Report 9i Styles
47

 
- The Data Source Option in Reports 9i
48

 
- The Data Option in Reports 9i
49

 
- Specifying SQL in Data Source Definition
50

 
- Column Labels in Data Source Definition
53

 
- Error Handling in Data Source Definition
56

 
- Query Builder in Data Source Definition
58

 
- Import Query in Data Source Definition
68

 
- Creating a Tabular Report in Reports 9i
69

 
- The Fields Option in Reports 9i
70

 
- The Totals Option in Reports 9i
72

 
- The Labels Option in Reports 9i
73

 
- The Template Option in Reports 9i
75

 
- The Completed Report in Reports 9i
76

 
- Re-Running the Report Wizard
78

 
- Exercise One
79

Four
Creating Totals in Reports 9i
85

 
- Types of Totals Available in Reports 9i
86

 
- Using the Report Wizard to Create Totals
87

 
- Exercise Two
93

Five
Paper Design in Reports 9i
99

 
- Editing Reports within Reports 9i
100

 
- Running Paper Design within Reports 9i
101

 
- Anatomy of Paper Design within Reports 9i
103

 
- Toolbars
104

 
- Tool Palette
107

 
- Functionality of Paper Design in Reports 9i
108

 
- Making Changes in Reports 9i
110

 
- Using the Flex Option in Reports 9i
112

 
- Changing Colours of Elements in Reports 9i
116

 
- Selecting Parent Frames
117

 
- Adding Fields to the Paper Design
120

 
- Property Inspector in Reports 9i
121

 
- Using Read from File in Reports 9i
126

 
- Exercise Three
129

Six
Report Styles in Reports 9i
133

 
- Creating a Group Left Report in Reports 9i
134

 
- Creating a Group Above in Report
138

 
- Totalling in Group Reports
140

 
- Creating a Matrix Report in Reports 9i
143

 
- Totaling a Matrix Report in Reports 9i
152

 
- Creating a Matrix with Group in Reports 9i
155

 
- Creating a Form Report in Reports 9i
159

 
- Creating a Form Letter Report in Reports 9i
163

 
- Creating a Mailing Label in Reports 9i
168

 
- Exercise Four
170

Seven
PL/SQL Editor in Reports 9i
177

 
- Usage of the PL/SQL Editor in Reports 9i
178

 
- Anatomy of the PLSQL Editor
179

 
- PLSQL Syntax in Reports 9i
180

 
- Bind Variables in Reports 9i
181

 
- Colour Coding
182

 
- Compiling PLSQL in Reports 9i
183

 
- Compilation Errors in Reports 9i
184

 
- Commenting Code in Reports 9i
187

 
- Navigation of Programs Within Reports 9i
188

 
- Defining Program Units in Reports 9i
189

Eight
Pluggable Data Sources in Reports 9i
190

 
- Express Server Query
192

 
- JDBC Query
193

 
- Text Query
200

 
- Textpds.conf File in Reports 9i
204

 
- XML Query
209

 
- Exercise Five
215

Nine
Data Model in Reports 9i
217

 
- Using the Data Model in Reports 9i
218

 
- System Parameters in Reports 9i
220

 
- User Parameters in Reports 9i
221

 
- Queries/Groups in Reports 9i
222

 
- Formula Columns in Reports 9i
223

 
- Summary Columns in Reports 9i
224

 
- Placeholder Columns in Reports 9i
225

 
- Data Links in Reports 9i
226

 
- The GUI Interface of the Data Model
227

 
- Toolbar of Data Model in Reports 9i
229

 
- Tool Palette of Data Model in Reports 9i
230

 
- SQL Query in Reports 9i
231

 
- Summary Columns in Reports 9i
234

 
- Formula Columns in Reports 9i
238

 
- Placeholder Columns in Reports 9i
243

 
- Data Links in Reports 9i
245

 
- Ref Cursor Query
248

 
- Cross Product Groups
253

 
- Pluggable Data Sources
255

 
- Groups
256

 
- Groups (Method 1)
258

 
- Groups (Method 2)
260

 
- Groups (Method Comparisons)
262

 
- Deleting Groups
263

 
- Creating Reports Manually in Reports 9i
264

 
- Exercise Six
265

Ten
Paper Layout
274

 
- Purpose of Paper Layout in Reports 9i
275

 
- Sections of Paper Layout in Reports 9i
276

 
- Anatomy of Paper Layout in Reports 9i
281

 
- Toolbar of Paper Layout in Reports 9i
283

 
- Tool Palette of Paper Layout in Reports 9i
285

 
- Rulers
286

 
- Use of Frames in Reports 9i
288

 
- Use of Repeating Frames in Reports 9i
289

 
- Identifying Frames in Reports 9i
291

 
- Frame Properties in Reports 9i
293

 
- Confine Mode in Reports 9i
299

 
- Conditional Formatting in Reports 9i
306

 
- Inserting a Report Block in Reports 9i
312

 
- Anchoring Fields in Reports 9i
311

 
- File Link in Reports 9i
315

 
- Inserting a Graph in Reports 9i
316

 
- Exercise Seven
317

Eleven
Web Source in Reports 9i
323

 
- JSP Output of Tabular Report in Reports 9i
326

 
- Breakdown of JSP Web Source Tags
328

 
- JSP Web Source Using Template
329

 
- JSP Web Source Using Grouping
330

 
- JSP Web Source Using Matrix Reports
331

 
- JSP Web Source Using Totals
332

 
- Editing JSP Web Source
333

 
- Exercise Eight
334

Twelve
Built in Packages in Reports 9i
339

 
- Introduction
340

 
- The SRW Package in Reports 9i
341

 
- SRW.RUN_REPORT
342

 
- SRW.DO_SQL
343

 
- SRW.SET_TEXT_COLOR
344

 
- SRW.SET_JUSTIFICATION
345

Thirteen
Report Parameters in Reports 9i
346

 
- Types of Parameters in Reports 9i
347

 
- System Parameters in Reports 9i
348

 
- User Parameters in Reports 9i
349

 
- Defining List of Values in Reports 9i
351

 
- Defining Static List of Values
352

 
- Defining Dynamic List of Values
354

 
- Validating Parameters in Reports 9i
357

 
- Parameter Forms in Reports 9i
358

 
- Using Parameters in Reports 9i
361

 
- Using Bind References With Parameters
362

 
- Using Lexical References
365

 
- Exercise Nine
367

Fourteen
Report Triggers in Reports 9i
373

 
- Firing Programs Within Reports 9i
374

 
- Before Parameter Form
376

 
- After Parameter Form
377

 
- Before Report
378

 
- Between Pages
379

 
- After Report
380

 
- Program Units
381

 
- Exercise Ten
382

Fifteen
Bookmarks in Reports 9i
386

 
- Bookmarking Sections in Reports 9i
387

 
- Bookmarking Examples in Reports 9i
388

 
- Creating Bookmarks in Reports 9i
390

 
- SRW.SET_BOOKMARK
393

 
- Creating using the Property Inspector
395

 
- Exercise Eleven
397

Sixteen
Drill Down Reporting
404

 
- Hyperlinking Reports
405

 
- SRW.RUN_REPORT
409

 
- Exercise Twelve
413

Seventeen
The Use of Templates in Reports 9i
416

 
- The Purpose of Templates in Reports 9i
417

 
- Pre-defined Paper Templates in Reports 9i
418

 
- Pre-defined Web Templates in Reports 9i
419

 
- Pre-defined Templates in Reports 9i
420

 
- Creating New Paper Templates in Reports 9i
421

 
- Using New Paper Templates in Reports 9i
427

 
- Creating New Web Templates in Reports 9i
429

 
- Incorporating Templates in Reports 9i
436

Eighteen
Incorporating Graphs in Reports 9i
440

 
- Creating Graphs in Reports 9i
441

 
- Types of Graphs in Reports 9i
443

 
- Positioning Graphs in Reports 9i
444

 
- Defining Axis in Reports 9i
445

 
- Defining Graph Titles in Reports 9i
448

 
- Defining Colour Options in Reports
450

 
- Graphs in Paper Output
453

 
- Returning to the Graph Wizard
455

 
- Positioning Graphs in Web Output
456

 
- The Graph Tag in Web Output
459

 
- Re-running Graphs in Web Output
463

 
- Copying Graphs from Paper to Web
464

Nineteen
Long Objects in Reports 9i
465

 
- What are Long Objects ?
466

 
- Using LOBs in Reports 9i
467

 
- Exercise Thirteen
470

Twenty
Additional Features of Reports 9i
477

 
- File Conversion in Reports 9i
478

 
- Tracing in Reports 9i
479

 
- Compiler
481

 
- Stored PLSQL Editor in Reports 9i
484

 
- Database Trigger Editor
486

Twenty One
PL/SQL Libraries in Reports 9i
487

 
- Using Libraries in Reports 9i
488

 
- Creating and Populating Libraries
489

 
- Attaching Libraries to Reports
490

 
- Updating Libraries in Reports 9i
493

 
- Report 9i Modules with Libraries
494

Twenty Two
Help Facility in Reports 9i
497

 
- Help Contents
499

 
- About Reports Builder
502

 
- Exercise Fourteen
503