iSelfSchooling.com - Copyright © 1999-2009 iSelfSchooling.com ||  References  |  Job Openings
    Home  | Search more...  |  FREE Online VIDEO Oracle Training 

    Oracle Syntax  | Suggestions  | Private Tutoring

  Copyright & User Agreement

Email2aFriend  | Homepage us! |  Bookmark

Services

 Vision/Mission

 Services

 Biography

 Contact Us

 FREE Training

 SQL

 PL/SQL

 Forms 

 Reports

 Other TOOLS

 Fundamentals

 Performance

 OEM

 Application Server

 Grid Control

 Articles

 Prepare for OCP

Oracle SYNTAX

 Oracle Functions

 Oracle Syntax

 Oracle 10g Syntax

  PL/SQL Syntax

UNIX and more...

 UNIX for DBAs

 LINUX for DBAs

 DB using PHP

  A+ Certification

 Basics of JAVA  

 Tips of  SEO

Finance/Jobs

 Financial Aid

 Skilled

 Oracle

 Jobs

  Magazine

More Training

 Q & Answers

 SQL-PL/SQL

 DBA

 Developer

 Important Notes

 Case Studies

 9i New Features

 10g New Features

 10g Qs/As

 Grid Control

 OracleAS # I

 OracleAS # II

  LDAP and OID

  HTTP Server

 Instructor-Led

  Virtual Hosts

 Community Sharing

More to know...

Acknowledgement**

 FREE Legal Forms

 Who is who

 Market Place

 University Directory

 Advisory Articles

 Links...

 

 

FREE Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

BASICS

SQL | PL/SQL

DEVELOPERS

FORMS 2 | REPORTS | Other TOOLS

DBAs

FUNDAMENTALS 2 | PERFORMANCE | OEM

ADVANCE

APPLICATION SERVER | GRID CONTROL | ARTICLES 2 3 4

Developers - REPORTS

Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 | Lesson 17 | Lesson 18 | Lesson 19 | Lesson 20 | Lesson 21 | Lesson 22 | Lesson 23 | Lesson 24 | Lesson 25 | Lesson 26 | Lesson 27 | Lesson 28 | Lesson 29 | Lesson 30 | Lesson 31 | Lesson 32 | Lesson 33 | Lesson 34 | Lesson 35 |

Lesson 09

“You can tell the character of every man when you see how he receives praise.” Seneca (5 BC - 65 AD), Epistles

Read first then play the video:

   RPT010(VIDEO)-(Hands-On 08) How to use layout appearances (Boilerplate)

 

Layout Appearances (Boilerplate)

Hands-on

Now, you client needs to improve on report appearance. They ask you for any artistic changes.

Be creative and artistic to change the appearance of their reports. Use boilerplate to change the title and draw graphic to their reports. Your client wants you to use your imagination that has no limits.

See Figure 8.

 

Your tasks are:

1- Modify the appearance of a report.

2- Use your creative imagination.

3- Run the report.

4- Test the report.

 

FYou will learn how to: use boilerplate; use your imagination that has no limit.

 

Figure 8

 

 

Login to the Report Builder.

Connect to a database

In the Object Navigator, highlight the Database object, go to the Main menu, choose File, select the Connect option, and in the Connect window enter your USERID and PASSWORD.

Open a Module

In the ‘Object Navigator’ window, go to the Main menu and choose “File,” select “Open” to open an existing report (REPT07) from the “iself” folder. Run the report.

 

Layout Model

In the Live Pre-viewer, click on the "Layout Model" icon.

In the ‘Report Editor - Layout Model’, click on the "Edit Margin" icon on the horizontal toolbar. Your report heading margin will be appeared. You can change anything on that margin.

 

Change appearance of a report

Use your creative imagination and change the report title. There is no limit on your creativities. By now, you should know how to use the Boiler plate objects. We have done that in one of Forms’ hands-on. Review that and do the same here.

 

Run the report.

Navigate through the report pages.

 

After testing the report output, highlight the report and save the changes as the report number 8 (REPT08).

 

 

 

“Life is like playing a violin in public and learning the instrument as one goes on.” Samuel Butler (1835 - 1902)

Questions:

Q: What is the boilerplate in the Layout Editor?

Q: How do you select an object or objects in the layout editor?

Q: How do you move an object or objects in the layout editor?

Q: How do you delete an object or objects form the layout editor?

Q: When do you use the Edit Margin icon?

Q: Now, your client needs to improve on report appearance. They ask you for any artistic changes.

Be creative and artistic to change the appearance of their reports. Use boilerplate to change the title and draw graphic to their reports. Your client wants you to use your imagination that has no limits.

See Figure 8.

 

Your tasks are:

1- Modify the appearance of a report.

2- Use your creative imagination.

3- Run the report.

4- Test the report.

 

 

 
 
Google
 
Web web site