Oracle Reports Designer class
© by Donald K. Burleson
Location: This course is taught at your Company site with up to 20 students.
Course Price:
Click here for on-site course prices
Curriculum Design:
This course was designed by
Donald K. Burleson, an acknowledged leader in Oracle database administration.
Author of more than 20 database books, Burleson was chosen by Oracle Press to
write five authorized editions, including Oracle High-Performance SQL tuning.
Burleson has over a decade of real-world DBA experience in Oracle features and
shares his Oracle secrets in this intense hands-on Oracle training.
Oracle Reports
Designer
Syllabus
© 2007-2009 by Donald K. Burleson
Introduction to Oracle Reports Designer
Using the Report Wizard
- Developing a Simple Report
- Report Wizard Actions
- Report Designer Components
The Designer Interface
- The Object Navigator
- Object Navigator Elements
- Changing the View
- Understanding Object Navigator Symbols
- Navigation Features and Methods
- Toolbar functions, menus
Data Model Painter
- Data Model Painter Components
- The Query Tool and Property Palette
- What Are Groups? How are Groups Created?
- The Group Property Palette
- Column Ordering
- Using Groups for Breaks
- Break Order Rules & Properties
- Showing the Master/Detail Report
- What are Computational Columns?
- Summary, Formula, Placeholder Columns
- The Query Link Tool
- Bind, Lexical & System Defined Parameters
- Creating the Query
- Creating Break Groups
- Creating the Layout Model
|
|
Layout Model Painter
- What is the Report Editor?
- Elements Within the Report Editor
- Concepts Within the Report Editor
- Using the Tool Palettes
- Menus: VIEW, Inser Menu, FORMAT Menu
- Custom Spacing Window
- Custom Line Sizes Window
- Graphics Options, Layout Options
- Color Palette, ARRANGE Menu
- Introduction to Report Sections
- What are Logical Pages?
- Introduction to Report Layout Frames
- General and Advanced Layout Properties
- Frames: Regular, Repeating Frames
- Framing Models, What is Three-Space?
- Using the Live Previewer
Using Report Parameters
- Creating User Parameters
- Customizing the Parameter Form Layout
Web Techniques
- Static Web Reporting
- Dynamic Web Reporting
- HTML Output
- PDF Output
- Adding links to your reports
Layout Fields and Special
Techniques
Using PL/SQL to enhance
Reports
Template Editing
- Predefined Templates
- Modifying Templates
- Applying Templates to Reports
|
Please note
that while the knowledge gained from this Oracle training may be valuable when
preparing for Oracle certification exams, the content of this course is not
for Oracle Certification, including the Certified Professional
(OCP) or Oracle Certified Associate (OCA) programs. This is a
BC Oracle training course. |
