Creating a report from scratch - Oracle

We will create a Report. Click on the Report radio button.

The Table Name: drop-down is added and you will be Adding a Report (Action: Add a report). The report page  needs a source, which is a Table on which the report will be based. The UI changes, as shown in the next picture.

Adding a Table

Click on the UP[ ^ ] arrow. This opens up a separate window with all the objects in the HR database as shown in the next picture.

When you click on the Employees in the list, the Employees table will be added to the Add a Report screen as shown in the next picture.

Do not place a check mark against the Include Analysis Pages check box. However, you should add at least one page before you go to the next stage. Now click on the Add Page button. The program is forgiving, as it will let you know that an error has occurred, and you can back out of the situation should you hit Add Page before adding the table.

This opens up the screen shown in the next picture, where you will be adding the page. The tabulated region at the top refers to the application being created. Page number, page name, page type, source type and source have been defined at this point.