AUDIENCE:   This course is for programmers and developers who need a comprehensive introduction to Reports 10G. The course takes students though reports development in Developer Reports 10G, beginning with basic report design and ending up with fully integrated applications rollout. The workshops are designed to mimic a true application building process. PREREQUISITES:   A good knowledge of SQL and PL/SQL, preferably gained through attendance of a suitable course like Verhoef's Oracle SQL and PL/SQL courses together with some experience of using these products in an everyday role. Knowledge of the GUI environment would be advantageous. DURATION:   3 days. Hands on. OBJECTIVES:   This course covers the fundamental concepts of Oracle Reports 10G in order to allow the delegate to create reports, making effective use of the enhanced procedural and report layout features. Delegates will gain sufficient knowledge from this course to enable them to become productive immediately on completion. COURSE CONTENT:   Oracle Reports Overview Introduction The environment Data model editor A simple report Oracle Reports Architecture Invoking the designer and connecting to a database Viewing the structure How to access an object How to create new objects Editing objects Removing objects Report properties Data model editor Layout editor Parameter form editor Program units node and built-ins Reports interface components Tips for creating reports Hands on practice Creating Reports Using the report wizards Specifying the data Queries Groups Database columns Data model tools Hands on practice Creating Layouts The layout editor The default layout Frames Repeating frames Specifying a default layout Saving and running a report Viewing report output Hands on practice Manipulating Layouts Options Creating a break report Updating the report layout Headers and trailers Report body and margins Fields Adding text Adding drawings Graph Wizard Changing fonts Modifying field properties Adding boilerplate text Adding a report heading Adding a run date Hands on practice Building Reports Multi-query reports Data links Creating master / detail reports Frames revisited Repeating frames revisited Fields User created boilerplate text Anchors Adding additional layouts Hands on practice Creating a new report Creating a label report Creating a form letter report An introduction to matrix reports Adding parameters to a report Templates Calling reports from Forms Hands on practice PI07/01