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

Course Name: Oracle Reports 10g

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
528
Oracle Essential SQL 10g Oracle Essential PLSQL 10g
None
Contact us for the latest pricing

Synopsis for course

Reports 10g 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.

Course Contents

Section
Contents
Page


One
Introduction to Reports 10g
2

 
- What is Reports 10g
3

 
- Reports 10g Destinations
5

 
- Report Extensions in Reports 10g
6

 
- Running Reports
7

 
- Creating Dynamic Reports
8

Two
Reports 10g Builder
9

 
- Starting Reports 10g
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 10g
25

 
- Web and Paper Output in Reports 10g
29

 
- Report Styles in Reports 10g
31

 
- Tabular Report Style in 10g
32

 
- Group Left Report Style in 10g
33

 
- Group Above Report Style in 10g
35

 
- Matrix Report Style in 10g
36

 
- Matrix Group Report Style in 10g
39

 
- Form-like Report Style in 10g
40

 
- Form Letter Report Style in 10g
42

 
- Mailing Label Report Style in 10g
43

 
- Report Wizards Dialogs in Reports 10g
45

 
- Relationship of Tabs with Report 10g Styles
47

 
- The Data Source Option in Reports 10g
48

 
- The Data Option in Reports 10g
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 10g
69

 
- The Fields Option in Reports 10g
70

 
- The Totals Option in Reports 10g
72

 
- The Labels Option in Reports 10g
73

 
- The Template Option in Reports 10g
75

 
- The Completed Report in Reports 10g
76

 
- Re-Running the Report Wizard
78

 
- Exercise One
79

Four
Creating Totals in Reports 10g
85

 
- Types of Totals Available in Reports 10g
86

 
- Using the Report Wizard to Create Totals
87

 
- Exercise Two
93

Five
Paper Design in Reports 10g
99

 
- Editing Reports within Reports 10g
100

 
- Running Paper Design within Reports 10g
101

 
- Anatomy of Paper Design within Reports 10g
103

 
- Toolbars
104

 
- Tool Palette
107

 
- Functionality of Paper Design in Reports 10g
108

 
- Making Changes in Reports 10g
110

 
- Using the Flex Option in Reports 10g
112

 
- Changing Colours of Elements in Reports 10g
116

 
- Selecting Parent Frames
117

 
- Adding Fields to the Paper Design
120

 
- Property Inspector in Reports 10g
121

 
- Using Read from File in Reports 10g
126

 
- Exercise Three
129

Six
Report Styles in Reports 10g
133

 
- Creating a Group Left Report in Reports 10g
134

 
- Creating a Group Above in Report
138

 
- Totalling in Group Reports
140

 
- Creating a Matrix Report in Reports 10g
143

 
- Totaling a Matrix Report in Reports 10g
153

 
- Creating a Matrix with Group in Reports 10g
156

 
- Creating a Form Report in Reports 10g
160

 
- Creating a Form Letter Report in Reports 10g
164

 
- Creating a Mailing Label in Reports 10g
169

 
- Exercise Four
171

Seven
PL/SQL Editor in Reports 10g
178

 
- Usage of the PL/SQL Editor in Reports 10g
179

 
- Anatomy of the PLSQL Editor
180

 
- PLSQL Syntax in Reports 10g
181

 
- Bind Variables in Reports 10g
182

 
- Colour Coding
183

 
- Compiling PLSQL in Reports 10g
184

 
- Compilation Errors in Reports 10g
185

 
- Commenting Code in Reports 10g
188

 
- Navigation of Programs Within Reports 10g
189

 
- Defining Program Units in Reports 10g
190

Eight
Pluggable Data Sources in Reports 10g
191

 
- Express Server Query
193

 
- JDBC Query
194

 
- OLAP Query
201

 
- Text Query
206

 
- Textpds.conf File in Reports 10g
210

 
- XML Query
215

 
- Exercise Five
221

Nine
Data Model in Reports 10g
223

 
- Using the Data Model in Reports 10g
224

 
- System Parameters in Reports 10g
226

 
- User Parameters in Reports 10g
227

 
- Queries/Groups in Reports 10g
228

 
- Formula Columns in Reports 10g
229

 
- Summary Columns in Reports 10g
230

 
- Placeholder Columns in Reports 10g
231

 
- Data Links in Reports 10g
232

 
- The GUI Interface of the Data Model
233

 
- Toolbar of Data Model in Reports 10g
235

 
- Tool Palette of Data Model in Reports 10g
236

 
- SQL Query in Reports 10g
237

 
- Summary Columns in Reports 10g
240

 
- Formula Columns in Reports 10g
244

 
- Placeholder Columns in Reports 10g
249

 
- Data Links in Reports 10g
251

 
- Ref Cursor Query
254

 
- Cross Product Groups
259

 
- Pluggable Data Sources
261

 
- Groups
262

 
- Groups (Method 1)
264

 
- Groups (Method 2)
266

 
- Groups (Method Comparisons)
268

 
- Deleting Groups
269

 
- Creating Reports Manually in Reports 10g
270

 
- Exercise Six
271

Ten
Paper Layout
280

 
- Purpose of Paper Layout in Reports 10g
281

 
- Sections of Paper Layout in Reports 10g
282

 
- Anatomy of Paper Layout in Reports 10g
287

 
- Toolbar of Paper Layout in Reports 10g
289

 
- Tool Palette of Paper Layout in Reports 10g
291

 
- Rulers
292

 
- Use of Frames in Reports 10g
294

 
- Use of Repeating Frames in Reports 10g
295

 
- Identifying Frames in Reports 10g
297

 
- Frame Properties in Reports 10g
299

 
- Confine Mode in Reports 10g
305

 
- Conditional Formatting in Reports 10g
306

 
- Inserting a Report Block in Reports 10g
312

 
- Anchoring Fields in Reports 10g
317

 
- File Link in Reports 10g
321

 
- Inserting a Graph in Reports 10g
322

 
- Exercise Seven
323

Eleven
Web Source in Reports 10g
329

 
- JSP Output of Tabular Report in Reports 10g
332

 
- Breakdown of JSP Web Source Tags
334

 
- JSP Web Source Using Template
335

 
- JSP Web Source Using Grouping
336

 
- JSP Web Source Using Matrix Reports
337

 
- JSP Web Source Using Totals
338

 
- Editing JSP Web Source
339

 
- Exercise Eight
340

Twelve
Built in Packages in Reports 10g
345

 
- Introduction
346

 
- The SRW Package in Reports 10g
347

 
- SRW.RUN_REPORT
348

 
- SRW.DO_SQL
349

 
- SRW.SET_TEXT_COLOR
350

 
- SRW.SET_JUSTIFICATION
351

Thirteen
Report Parameters in Reports 10g
352

 
- Types of Parameters in Reports 10g
353

 
- System Parameters in Reports 10g
354

 
- User Parameters in Reports 10g
355

 
- Defining List of Values in Reports 10g
357

 
- Defining Static List of Values
358

 
- Defining Dynamic List of Values
360

 
- Validating Parameters in Reports 10g
363

 
- Parameter Forms in Reports 10g
364

 
- Using Parameters in Reports 10g
367

 
- Using Bind References With Parameters
368

 
- Using Lexical References
371

 
- Exercise Nine
373

Fourteen
Report Triggers in Reports 10g
379

 
- Firing Programs Within Reports 10g
380

 
- Before Parameter Form
382

 
- After Parameter Form
383

 
- Before Report
384

 
- Between Pages
385

 
- After Report
386

 
- Program Units
387

 
- Exercise Ten
388

Fifteen
Bookmarks in Reports 10g
392

 
- Bookmarking Sections in Reports 10g
393

 
- Bookmarking Examples in Reports 10g
394

 
- Creating Bookmarks in Reports 10g
396

 
- SRW.SET_BOOKMARK
399

 
- Creating using the Property Inspector
401

 
- Exercise Eleven
403

Sixteen
Drill Down Reporting
410

 
- Hyperlinking Reports
411

 
- SRW.RUN_REPORT
415

 
- Exercise Twelve
419

Seventeen
The Use of Templates in Reports 10g
422

 
- The Purpose of Templates in Reports 10g
423

 
- Pre-defined Paper Templates in Reports 10g
424

 
- Pre-defined Web Templates in Reports 10g
425

 
- Pre-defined Templates in Reports 10g
426

 
- Creating New Paper Templates in Reports 10g
427

 
- Using New Paper Templates in Reports 10g
433

 
- Creating New Web Templates in Reports 10g
435

 
- Incorporating Templates in Reports 10g
442

Eighteen
Incorporating Graphs in Reports 10g
446

 
- Creating Graphs in Reports 10g
447

 
- Types of Graphs in Reports 10g
449

 
- Positioning Graphs in Reports 10g
450

 
- Defining Axis in Reports 10g
451

 
- Defining Graph Titles in Reports 10g
454

 
- Defining Colour Options in Reports
456

 
- Defining Hyperlinks in Reports 10g
459

 
- Graphs in Paper Output
464

 
- Returning to the Graph Wizard
466

 
- Positioning Graphs in Web Output
467

 
- The Graph Tag in Web Output
470

 
- Re-running Graphs in Web Output
473

 
- Copying Graphs from Paper to Web
474

Nineteen
Long Objects in Reports 10g
475

 
- What are Long Objects
476

 
- Using LOBs in Reports 10g
477

 
- Exercise Thirteen
482

Twenty
Additional Features of Reports 10g
490

 
- File Conversion in Reports 10g
491

 
- Tracing in Reports 10g
492

 
- Compiler
494

 
- Stored PLSQL Editor in Reports 10g
497

 
- Database Trigger Editor
499

Twenty One
PL/SQL Libraries in Reports 10g
500

 
- Using Libraries in Reports 10g
501

 
- Creating and Populating Libraries
502

 
- Attaching Libraries to Reports
503

 
- Updating Libraries in Reports 10g
506

 
- Report 10g Modules with Libraries
507

Twenty Two
Help Facility in Reports 10g
510

 
- Help Contents
512

 
- About Reports Builder
515

 
- Exercise Fourteen
516