Create Oracle Sample report Manually

Launch Reports Builder (or, if already open, choose File > New > Report).

In the Welcome or New Report dialog box, select Build a new report manually, then click OK.

We need to create

1.    Data Model

2.    Layout Model

1.Data Model

1.In the Data Model view that displays, click the SQL Query tool in the tool palette then click in an open area of the Data Model view to display the SQL Query Statement dialog box.

2.In the SQL Query Statement field, enter the following SELECT statement:

SELECT EMPNO, ENAME, JOB, SAL, COMM, DEPTNO FROM EMP

Click OK.

3.If the Connect dialog box displays, type the connection information for the database where the Order Entry sample schema resides, then click Connect.

4.The query displays in the Data Model view, and should look something like this:

5.Right-click the query (Q_1), then choose Property Inspector from the pop-up menu.

6.In the Property Inspector, under General Information, set the Name property to Q_EMP.

7.Double-click the group (G_EMPNO) to display the Property Inspector, and set the Name   property to G_EMP.

2.Layout Model

1.Click on paper Layout

2.Create frame and create repeating frame inside main frame as below

   Select frame and Right click go to Property Inspector set below Properties

                  Vertical Elasticity    :Expand

                  Horizontal Elasticity :Expand 

   Select repeating frame and Right click go to Property Inspector set below Properties

    

                  Source                      :G_EMP

                  Vertical Elasticity    :Expand

                  Horizontal Elasticity :Expand 

3.Create column labels by using TEXT tool in the tool palette on frame level as below

4.Create fields by using Field tool in the tool palette in reaping frame as below

5. select F_1 field and right click go to Property Inspector set below properties.

               Name                       :Empno

               Source                      :EMPNO

               Vertical Elasticity    :Fixed(if you required you can set as Expand)

               Horizontal Elasticity :Fixed(if you required you can set as Expand)

  Same way you can set remain field also..

 If you set remaining properties it will seems like as below

 Now development part completed you can run the report

Goto >Programs > Run paper Layout (you can find as below report output)

if you want remove all the frames  by using Fill color and Line color tool in the tool palette

 go to paper Layout  Ctrl+A

 Right click on Fill color and click on No Fills

 Right click on Line Color and click on No line

See the report output

You May Like:

Oracle Reports Introduction

How to connect database from oracle report builder

Create Oracle report Using Wizards

Create Oracle Sample report Manually

How to add summary column in oracle reports

Formula columns in oracle reports

Placeholder Column In Oracle Reports 

Create oracle Report with Bind Parameter

Create Oracle Report with Lexical Parameter

Oracle Reports FAQ