oracle 10g reports builder

global knowledge canada
calgary, edmonton, halifax, montreal, ottawa, quebec city, toronto, vancouver, winnipeg, canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' this lab-intensive course is designed to lead developers through the steps involved in developing a report. the course covers concepts involved in using the gui report writer to build reports in various formats that can include buttons, multimedia, and ole2 objects.

what you’ll learn


create reports by accessing data from various data sources,and modify basic tabular reports and high quality web reports,other report styles such as break reports and matrix reports
manage report templates,mailing labels and letters
identify the main components in a report document and how they are related, identify the differences between web and paper reports, identify standard report design styles and run existing reports to various output destinations
publish a report on the web
add dynamic data to an existing html page
use report parameters and customize a runtime parameter form
enhance reports using graphs and pl/sql trigger code
maximize report performance using oracle reports services and tune reports
course outline


1. introduction to oracle reports
oracle reports overview
working with oracle reports on the client and the web
report builder, synchronization, help
2. run a report on the client
paper design and web layout actions, from the command line, pass a parameter to a report, generate report output
3. creating a tabular reports
creating a tabular report, the report wizard, report choices and style, data source type and definition, displayed fields in the report, add summaries, modify labels, report templates and viewer
4.master-detail reports
create a master group, query, group fields,a detail group in the wizard, data model for a single report, and a master detail report, layout for a group left report,a detail group manually, data model for a group above report, repeating frames, page number and date/time in a report
5.form letter reports
create a form letter, query, text, add boilerplate in the layout, explore the margin section, import an image
6.mailing label reports
create mailing labels, and query, add boilerplate to mailing labels, repeat frames in multiple directions, frame property inspector
7.form reports
create a form-like report, form report query and labels, a field in the paper payout, field property inspector, toolbars in the layout,report documentation
8.data model groups
create a query in the data model, query and group property inspector, add a group filter, link queries,a pl/sql query,a pl/sql package and query function, ref property inspector
9.data model columns
creating data model columns, summary columns, column property manager,grand total and formula columns, placeholder columns
10.matrix reports
creating a matrix report, add summaries to a matrix report, matrix report labels, output, data model, layout,a matrix in the data model,a cross product in the data model
11. enhance matrix reports
creating a matrix group report, matrix group query, rows, columns, cell fields, summaries, labels, data model, output, layout,a nested matrix report, add matrix summaries in the data model
12. using parameters
system parameter,a bind parameter, parameter property inspector, validation triggers, creating a lexical parameter, static list of variable, bind versus lexical, generate parameter form, parameter form editor, size, at runtime
13.or modify layout objects
create a header and trailer page, formatting data, conditional formatting
confine mode off and on, flex mode off and on, select parent frame, print objects, object elasticity, page breaks, multi-panel reports, column mode,a report block,explicit anchors
14. embed a graph in a report
the graph wizard, select the graph type and position the graph, choose the x or y axis, graph layout, titles, legend, options, output, property inspector, hyperlinks
15. using pl/sql in reports
understanding pl/sql, pre-defined packages and exceptions, pl/sql functions in triggers, creating and attaching external pl/sql, pl/sql trace and debug features
16.reports for the web
jsp, jsp tags, web source,a bookmark, generate html and pdf output, adding html header or footer, creating hyperlinks, report escapes
17. run a report on the web
environment variables, static and dynamic reporting, three-tier architecture, how to deploy a report, test a report on the client, the report in a web browser
18.report triggers
five report triggers, pl/sql block structure,a procedure or function,and view a report trigger,and store code in a pl/sql library, attach a pl/sql library, stored procedures versus library
19.other report triggers
group filter triggers, validation triggers, format triggers on fields and frames
20. the srw package
send a message, run a report in the background, set field values, perform sql statements, set formatting
21. use xml in oracle reports
generate xml output, report definition tags, partial and complete xml report, run an xml report, apply and xml format
22. use the report queue manager
report services, queue manager, schedule a report job
labs


lab 1: introduction to oracle reports
lab 2: run a report on the client
lab 3: creating a tabular reports
lab 4:master-detail reports
lab 5:form letter reports
lab 6:mailing label reports
lab 7:form reports
lab 8:data model groups
lab 9:data model columns
lab 10:matrix reports
lab 11: enhance matrix reports
lab 12: using parameters
lab 13:or modify layout objects
lab 14: embed a graph in a report
lab 15: using pl/sal in reports
lab 16:reports for the web
lab 17: run a report on the web
lab 18:report triggers
lab 19:other report triggers
lab 20: the srw package
lab 21: use xml in oracle reports
lab 22: use the report queue manager ...''

Elements of this syllabus are subject to change.

Phone:1-800-courses

School Address:

global knowledge - canada
535 legget drive
suite 200
kanata, on k2k 3b8 canada



Jobs & Resumes: calgary, edmonton, halifax, montreal, ottawa, quebec city, toronto, vancouver, winnipeg
Houses & Roommates: calgary, edmonton, halifax, montreal, ottawa, quebec city, toronto, vancouver, winnipeg
Travel Agencies: calgary, montreal, ottawa, toronto, vancouver, winnipeg

Search other schools for oracle 10g reports builder training resources.

Nortel Converged Campus: ERS Solution
Nortel ERS 5000 & 4500 Advanced Configuration & Maintenance with Hands-in Labs
Nortel ERS 8600/8300/1600 Advanced Configuration and Maintenance
oracle 10g database administration
oracle 10g discoverer desktop
Oracle 10g Discoverer for Administrators
oracle 10g forms builder
oracle 10g pl/sql intermediate
oracle 10g release 2 business intelligence discoverer plus
Oracle Application Server 10g
.net web developer
Advanced .NET Programming
Visual Studio.NET
Intermediate and Advanced .NET Programming
Windows Communication Foundation using VB.NET or C#
microsoft visio 2003 bundle
Guided PMP Exam Prep
PMP Renewal Subscription Program

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.