iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

Online Oracle Training

Table of contents

REPORTS -- Table of contents

 

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

 

Introduction: To complete Hands-On 07 to 11

Note on the important definitions to remember

 

Hands-On 07: Template

You will learn how to: Create or modify an existing template; Save the template with new name; Change the default; Delete the logo; Replace the new logo; and Save your template.

 

Hands-On 08: Layout appearances (Boilerplate)

You will learn how to: Use boilerplate; Use your imagination that has no limit

 

Hands-On 09: Parameters

You will learn how to: Use the Group above; Use the Query Builder; Set table relationship; Create and use binding variable; Calculate total and average shares; Delete the object from layout.

 

Hands-On 10: Drill Down or Push Button report

You will learn how to: Use Push Button to execute another report; Use or pass parameter; Use the select parent frame icon; Use or open objects property; Compile report; Use the boilerplate; Write and compile PL/SQL trigger; and Use Runtime Pre-viewer.

 

Hands-On 11: LOVs (List Of Values)

You will learn how to: Use parameter; Modify parameter properties using property palette; Use Query Builder; Add more parameters to existing parameter form

 

Good Luck!

 

Google
 
Web web site