iSelfSchooling.com - Since 1999  References  |  Job Openings
    Home  | Search more  | Oracle Syntax  | Computer Institute   | (Login or Register to access to VIDEOS)
 

Copyright & User Agreement

   Suggestions Email2aFriendHomepage us! |  Bookmark

Services

  Vision/Mission

  Services

  Biography

  Contact Us

 FREE Training

  Start...

  SQL

  PL/SQL

  Forms 

  Reports

  DBA Fundamentals

  Performance

  Prepare for OCP

  ShareUrNotes

...

  Acknowledgement

  Who is who

  University Directory

  Links...

 

 

 

Hands-On REPORT Builder I

Table of contents: 

Click here for case study 

  • Introduction: To complete Hands-On 01 to 06

  • Note on the important definitions to remember  

  • Hands-On 01: Tabular

  • You will learn how to: 

  • Use report wizard,

  • Object navigator,

  • Report builder,

  • “Date Model”,

  • Property palette,

  • Work on query and group box,

  • Work on report style,

  • Use tabular style,

  • Navigating through report’s record,  and

  • Change the format mask for dollar, numeric and date items.  

  • Hands-On 02: Group Left

  • You will learn how to: 

  • Use report wizard,

  • Use report style “Group Left”,

  • Use template,

  • Modify layout on pre-viewer,

  • Use zoom in and out,

  • Work on the body section in the layout model in the object navigator, and

  • Change repeating object’s property palette.  

  • Hands-On 03: Mailing Label

  • You will learn how to:

  • Use report style “Mailing Label,”

  • Use the “query builder,”

  • Generate three columns label,

  • Change the font and size,

  • Change it to two columns label, and

  • Use handlers on the layout model  

  • Hands-On 04: Matrix

  • You will learn how to: 

  • Use query builder,

  • Set table relationship,

  • Change properties from property palette,

  • Use report style matrix,

  • Make subtotal for rows and columns,

  • Use the “select parent frame” icon,

  • Create grid, and

  • Use the conditional formatting.  

  • Hands-On 05: Form Letter

  • You will learn how to: 

  • Use the report style “form letter,” and the “query builder,”

  • Set table relationships,

  • Define column from the “query builder,”

  • Use sub-query,

  • Use of Data Model,

  • Layout Model, and Boilerplate,

  • Write the letter and pass the column to the letter.  

  • Hands-On 06: Group above

  • You will learn how to: 

  • Use a Master-Detail report,

  • Build a new report manually,

  • Create multiple “sql query,”

  • Create data link,

  • Use the formula column,

  • Use the summary column,

  • Use the report “group above” style,

  • Use main section, and Property palette.

 

 
 
Google
 
Web web site