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 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.
|
