Delegates: |
|
This course is aimed at database administrators, software developers and technical support personnel who need to create reports in a variety of styles and customise reports to meet their business requirements.
|
Objectives: |
|
By the end of this course, delegates will understand the main concepts of Oracle Reports Developer. The course is designed to give delegates practical experience in designing and creating web and paper reports using the Report Wizard. They will also be able to add dynamic report data to static HTML pages and publish reports on the web.
|
Topics Covered: |
- Creating paper and web reports
- Defining report queries
- Building reports in various different formats
- Applying queries, groups, calculations and summaries to a report
- Editing and manipulating boilerplate and layout objects
- Editing and enhancing the Web source code
- Building master/detail and matrix reports
- Building and using report templates
- Using PL/SQL to base reports on ref cursor queries
- Using PL/SQL trigger code for validating and formatting reports
- Using XML and text pluggable data sources in reports
- Using Parameters in Reports
- Adding graphics to a report
- Distributing and bursting reports
- Tuning reports
- Maximizing report performance using Oracle AS Reports Services
- Publishing reports on the Web
- Adding dynamic data to an HTML page
|
Requirements:
|
|
A working knowledge of SQL*Plus and PL/SQL is required. T
his can be obtained by attendance on the pre-requisite courses. Familiarity with basic XML and HTML would be an advantage. |
