Email Us : sunilkumark11@gmail.com
Free Training > SQL PL / SQL Forms Reports Oracle Applications
< Previous Next >

 
Reports - Developing report manually

Let us learn how to develop the report manually.

Open the Report Builder tool Select Build new Report manually OK

We will be directed to Data Model of the report.

Click on SQL  and Click on Work Area. We get SQL Query Statement window.

Provide the Query Select * from dept OK

Provide the connection Details,  User Name , password and  the Database  OK

This is how the Data Model looks like.
We have Query ie ( Q_1) , it results in Group ( G_DEPTNO ).
Group is collection of columns.

We are done with Data Model. Close the Data Model.
We need to design the report in layout model.
In Object Navigator Double click on Paper Layout
This is how Paper Layout looks like

Click on Frame Draw the frame in the work area.

Right Click on the frame   Property Inspector Provide the following property

General Information
Name -- M_GRPFR
General Layout
Vertical Elasticity -- Variable

Create another frame inside M_GRPFR

Right Click on the inner frame   Property Inspector Provide the following property
Name -- M_HDR    

Click on Text  and place three text_items  ( Deptno, Dname and loc ) in the frame M_HDR.

Create a repeating frame below the header frame.

Place three fields in the repeating frame.

Right click on the Repeating Frame Property Inspector   Provide the following property.
Repeating Frame
Source --  G_DEPTNO            ( It is the name of the group in data model ).

Similarly, provide the source for the fields.

Right click on the Field ( F_1)  Property Inspector   Provide the following property.
Field
Source --  DEPTNO       ( It is the column name ).

Right click on the Field ( F_2)  Property Inspector   Provide the following property.
Field
Source --  DNAME       ( It is the column name ).

Right click on the Field ( F_3)  Property Inspector   Provide the following property.
Field
Source --  LOC       ( It is the column name ).

File   Save as    DEPT_MANUAL.rdf

In the Object Navigator,  Program Compile All

Program Run Paper Layout

We are done developing the report manually.

In the Object Navigator, we can see the all the frames, repeating frames, text and fields which we have created.

 


< Previous Next >