Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Monday, 18 April 2016

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:
Share this article :

0 comments:

Post a Comment