SUMMARY:   This course takes students though reports development in Developer Reports 6i. Beginning with basic report design and ending up with fully integrated applications rollout. The workshops are designed to mimic a true application building process. AUDIENCE:   This course is for programmers and developers who need a comprehensive introduction to Reports 6i. 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. APPROACH:   The course is highly interactive, consisting of instructor led, modular chapters containing plenty of hands on, practical workshop sessions. OBJECTIVES:   This course covers the fundamental concepts of Oracle Reports 6i 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 Concepts and Terminology Introduction to Oracle Reports V6i Designing an Oracle report The Object Navigator Define the data model · Queries · Groups · Columns · Parameters · Data links Specify the layout model · Default report layouts · Repeating frames · Frames · Fields · Boilerplate · Anchors Specify a runtime parameter form · Fields  · Bolilerplate The Oracle Reports interface · Property sheets · Object navigator · Editors  · Palettes and toolbars Tips for creating Oracle reports Default Layouts Invoking the Oracle Reports Designer Using Object Navigator Connect to the Database Specify the Data · Data Model Editor and Tool Palette · QueryTool Specify A Default Layout Save and Run the Report View Report Output A Break Report Open an existing report Changing the data model · Create a break group  Updating the report layout Repeating frames Create calculations · Formulas · Summaries · Create formula columns · Enter the formula · Create a group summary · Create a running summary · Create a report summary Changing fonts and column widths Modify field properties Add Boilerplate · To change column labels · Displaying report margins · Altering report margins · Adding a report heading · Add the current date Master Detail Report Multi query reports Multi-part unrelated query reports Multi-part related query reports Data links Create a master/detail report A master/detail/detail report Frames, Fields, Boilerplate and Anchors Frames · Default frames · User-created frames · Repeating frames Boilerplate · User-created boilerplate · Boilerplate text from external text files Fields · Field types · Field creation properties Anchors · Anchor creation properties · Implicit anchors · Explicit anchors Online Help Oracle Reports help · Contents · Cue cards · Quick tour · Module info · About reports  Context sensitive help Oracle book Form Letters and Mailing Labels Creating a mailing label report · To create a mailing label report · To suppress blank lines A form letter report · To create a form letter report · To suppress blank lines Matrix Reports Introduction to matrix reports The matrix data model The number of queries The group structure Summaries and product order To create a one query matrix report Parameters Runtime parameter form Parameter form objects · Fields · Boilerplate Parameter creation properties · System parameters · User created parameters Parameter and column references · Bind references · Lexical references · Parameter lists of values and combo-boxes Parameter form editor · How to build a parameter form Drill Down Reports Using buttons on a report Creating a drill down report The Runtime Interface Compiling reports to create an executable Using the runtime Interface Iconizing reports in a Windows environment Running reports in a Web environment.