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


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:


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 :


  1. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check

  2. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

  3. Merely a smiling visitant here to share the love (:, btw outstanding style. csgo high tier accounts

  4. Most game lovers have debated about subscribing to an online video game rental website. There are many, many benefits to online video game renting. Valorant Smurf Accounts

  5. I am unable to read articles online very often, but I’m glad I did today. This is very well written and your points are well-expressed. Please, don’t ever stop writing. pubg mobile accounts