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.