Oracle Reports Tutorials ~ Symrich

Today, we are going to develop a simple Oracle report which will display sales orders information from order management(EBS).

Open the Report Builder

Select Build a new report manually to begin a new design and click OK.

Otherwise,

Go to File -> New -> Report

Select Build a new report manually to begin a new design and click OK.

Whenever, we click on OK button we directly get Data model window where we have to write SQL query.

Rename module name. Right click on Module.

Select Property inspector and name the module.

Click on SQL button which is present in TOOL PALETTE and drop in empty place

Whenever we drag and drop, it will ask for SQL Query statement like which is shown below.

Write SQL Query and click OK.

Whenever you click on OK button, system will ask for DATABASE CONNECTION.

Then provide user name and password and then click on CONNECT button. Now we can see below window nothing but DATAMODEL window.

Now we have to display the data in layout model extracted from data model.

Now we are going to create layout model.

For that click on layout model icon in tool palette then we get like, shown below

In this report we are going to use below objects-

1. Frame

2. Repeating frame

3. Text

4. Field

First take one frame for holding objects which is shown below

Select Frame from palette.

Add another frame to hold column names.

Add TEXT from pelette for each column name.

Now put one repeating frame inside main frame to hold data.

Now take fields in repeating frame for each column to display data as below.

Now create the link between layout model and data model. To give link go to properties of repeating frame or press f4 on repeating frame to go to properties and then give source as group name as below.

Now give sources for every field added on repeating fields. To cater this go to properties of every field and give sources(Column name) to the source field.