Maricopa Community Colleges  CIS164AE   19996-20015 
Official Course Description:   MCCCD Approval:  03/23/99
CIS164AE     19996-20015 L+L 3 Credit(s) 4 Period(s)
Oracle: Developer Reports
Building a variety of standard and custom reports in a client-server environment. Using a graphical user interface (GUI) environment to retrieve, display, and format data in many styles to create tabular, matrix, mailing label, and letter reports. Customizing more complex reports, embedding graphical charts in reports, and using the Intelligent Remote Reports Server. Prerequisites: (CIS117DO and CIS164AB) or permission of instructor.
 
 Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS164AE   19996-20015 Oracle: Developer Reports
1. Define report builder concepts. (I)
2. Create and modify reports. (II)
3. Manage report templates. (III)
4. Customize reports using parameters. (IV)
5. Embed a chart in a report. (V)
6. Enhance reports, objects, and layouts. (VI)
7. Enhance reports with trigger codes. (VII)
8. Maximize performance using the reports server. (VIII)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS164AE   19996-20015 Oracle: Developer Reports
    I. Report builder concepts
        A. The main components in a report document and how they are related
        B. Designing and running a report
        C. Standard report design styles
        D. Running existing reports to various output destinations
      II. Creating and modifying reports
          A. Invoking the report builder
          B. Creating a tabular report
          C. Modifying the report by adding data and altering the report style
          D. Inserting page numbers and altering visual attributes
          E. Building mailing labels, letters, break, and matrix reports
          F. Modifying a selection of report-level and runtime properties and options
        III. Managing report templates
            A. Opening and modifying predefined Developer/2000 report templates
            B. Registering a customized template
          IV. Using report parameters and customizing a parameter form
              A. Creating and referencing user parameters
              B. Referencing systems parameters
              C. Creating and customizing a parameter form to display parameters at runtime
            V. Embedding a chart in a report: Creating a Developer/2000 graphical chart to display in a report at runtime
              VI. Enhancing report objects and layout
                  A. Creating user-defined columns for summaries and calculations
                  B. Creating additional layout objects such as buttons and variable-length lines
                  C. Modifying object properties to control placement and pagination of objects
                VII. Enhancing reports with trigger code
                    A. Trigger types
                    B. Creating conditional trigger code to control report output
                    C. Sharing and reusing common code
                  VIII. Maximizing performance using the reports server
                      A. Controlling and monitoring a remote reports server installation
                      B. Viewing and scheduling reports sent from a client to the reports server
                      C. Building reports to run on various platforms and in different environments and languages
                      D. Identifying and modifying the properties needed for character-mode reports
                  Go to Description    Go to top of Competencies    Go to top of Outline