Download the open-source JasperReports tool JAR file jasperreports-2.0.5.jar. Download the iText Java-PDF library itext-2.1.0.jar. Download the Jakarta-POI ZIP file poi-bin-3.0.2-FINAL-20080204.zip. Download Commons Digester 1.8 and extract the ZIP file to a directory. Install the JDeveloper 10g IDE Studio Edition Complete Install. Download and install the Oracle database from: http://www.oracle.com/database/index.html 10g.

Create an example database table, Catalog from which a JasperReports PDF report and Excel report will be generated. Create the database table in Oracle SQL *Plus. The SQL script to create the example table is listed below.

CREATE TABLE OE.Catalog(CatalogId VARCHAR(25), Journal VARCHAR(25),
Publisher Varchar(25),Edition VARCHAR(25), Title Varchar(45),
Author Varchar(25));
INSERT INTO OE.Catalog VALUES('catalog1', 'Oracle Magazine', 'Oracle
Publishing', 'July-August 2005', 'Tuning Undo Tablespace',
'Kimberly Floss');
INSERT INTO OE.Catalog VALUES...