Home arrow Oracle arrow Page 3 - Developing Applications on Oracle 10g XE: Generating a Report

Creating a report from scratch - Oracle

This tutorial shows you how to create a report based on a table in the Oracle 10g XE database without stepping out of the IDE. It will show you how to manipulate the report and create a UI.

TABLE OF CONTENTS:
  1. Developing Applications on Oracle 10g XE: Generating a Report
  2. Building an Application
  3. Creating a report from scratch
  4. Adding a Page
  5. Adding a User Interface
  6. Running a report, searching and sorting
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 16
July 05, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

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.



 
 
>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: