iReport

iReport allows users to generate user configurable reports in various formats (xls, pdf, doc etc). More information about iReport is available at http://jasperforge.org/sf/projects/ireport

To get started, you can follow steps below to install iReport:

1) Download the iReport

http://sourceforge.net/project/showfiles.php?group_id=64348&package_id=64215

2) Install the package

This step is easy, just double click on the executable downloaded earlier

3) Download Postgresql JDBC driver

Download the JDBC3 for PostgreSQL 8.2 (or other versions depends on the Postgresql server that you are trying to connect to) from http://jdbc.postgresql.org/download.html

Save this file into C:\Program Files (x86)\JasperSoft\iReport-1.3.3\lib (depends on where you install the iReport, save it into the "lib" directory).

4) Enable remote connection at the database server.

Edit the following file in the linux server /var/lib/pgsql/data/pg_hba.conf  (specify the internal IP address of the client machine), or router IP address (external public IP) if the database server is located outside the local area network.

Remember to restart the database for the permissions to take effect (command:   /etc/init.d/postgresql restart)

5) Port forwarding

If the database server is located behind a network, be sure to configure the port forwarding of the database server router, so that it will forward all requests to the database server that is listening to port 5432.

6) Linux username and password

If you do not have an existing username / password in the linux server that has access to the postgresql database, please create

i) Linux user

#useradd theusername

#passwd theusername

ii) Postgres user

#createuser theusername

7) Run Report Wizard

Once you have done the above, you should be able to run the report wizard to start generating reports. You can start with the simplest table: user_index , or inv_item tables.