Index of Oracle Reports 9i training course
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