Oracle Reports v3,6,6i
Course
Inhouse
Description
-
Type
Course
-
Methodology
Inhouse
-
Duration
3 Days
This is a practical course covering Oracle's flagship report writing tool, Oracle Reports v6/6i and also v3. The course aims to cover ground level techniques necessary to understand the product and implement enterprise standard reports within the development business environment. Suitable for: Analyst/Designers. Analyst Programmers. Technicians.
About this course
There are no prerequisites. .
Reviews
Course programme
This is a practical course covering Oracle's flagship report writing tool, Oracle Reports v6/6i and also v3.
The course aims to cover ground level techniques necessary to understand the product and implement enterprise standard reports within the development business environment.
Training Course Contents: Report Basics
- What is Oracle Reports?
- Welcome to Report Builder
- Object Navigator Menus
- Object Navigator Toolbars
- Object Navigator Structures
- Using the Report Wizard
- Using the Data Wizard Manually
- What Data Model Objects Were Built?
- What Layout Model Objects Were Built?
- What Obect Navigator Objects Were Built?
- Data Model Work Area
- Formula Columns
- Control Break Groups Using the Report Wizard
- Control Break Groups Manually
- Summary Columns using the Report Wizard
- Summary Columns Manually
- Query Properties
- Group Properties
- Database Column Properties
- Multiple Queries & the Additional Default Layout Tool
- Query Data Links
- Query Builder
- Live Previewer Work Area
- Report Formatting using the Live Previewer,
- Layout Model Work Area,
- Layout Model Tools,
- Layout Model Menus,
- Report Formatting using the Layout Model,
- Layout Object Proporties,
- Header and Trailer Pages,
- Margin Page,
- Direct Column and Field Referencing,
- Tabular Report Style,
- Group Left Report Style,
- Form Like Report Style,
- Mailing Label Report Style,
- Form Letter Report Style,
- Group Above Report Style,
- Matrix Report Style,
- Matrix with Group Report Style
- Template Editor Work Area,
- Template Data Model,
- PL/SQL in Templates,
- Group Levels in Templates,
- Adding Templates to the Predetermined List.
- Setting System Parameters,
- Creating User Parameters,
- Building Parameter Drop Down Lists,
- Parameter Form Builder,
- Parameter Form Formatting.
- PL/SQL Overview,
- Oracle 8 Support,
- PL/SQL Editor,
- Syntax Palette,
- Find and Replace in PL/SQL,
- Report Triggers,
- Format Triggers,
- Validation Triggers,
- Creating Independent Program Units,
- Building and Using PL/SQL Libraries,
- SRW. Message Built In,
- SRW. Set_Field Built Ins,
- Conditional Formatting and the SRW. Set Built Ins.
- Generating RTF Output for Word Processors,
- Generating Delimited Text File Output,
- Generating HTML Output,
- Generating HTML Style Sheet Output,
- Generating XML Output,
- Generating PDF Output,
- Setting Report Distribution Properties,
- Building a Report Distribution File,
- Distributing Report Output.
- What is the Report Server?
- Using the WEB Wizard,
- Setting the WEB Properties.
- Creating Buttons in Reports.
- Drilling Through Reports Using SRW. Run_Report.
Oracle Reports v3,6,6i