I remember generating reports using Oracle Report Builder, and it was a tough one, especially dealing with the “sensitive” alignments.
Have always fear of doing reports… well, not till I notice there are open-source reporting tools offered in the market.
Been generating reports using iReport and JasperReport, and I would say, things are becoming easier, and faster when developing a system or application to generate reports.
Taken from the official site of iReport, it says that iReport is a powerful, intuitive and easy to use visual report builder/designer for JasperReports written in 100% pure java. This tool allows users to visually edit complex reports with charts, images, and subreports. iReport is integrated with leading open source chart libraries for java.
To start using iReport, you can always download for free at iReport site
After unzip, the folder, double click on the bat file and iReport is ready to run.
the iReport gui
Here, I’m going to show how to create a report using active connection. Assumption is you have a db installed on your local pc. For this, I have postgres installed in mine.
Before we get any further, after you have the iReport, you need to set the classpath.
options => classpath
a classpath box appeared
Add JAR => search for the jar file and add it
there i have configured my classpath
Now that you are done with the classpath, you can start creating connection by this:
Data => Connections/Data Sources
add new connection
To the next step, will be start creating report template.
File => Report wizards
Write a select SQL.
write sql
Click next, and add the fields columns to be displayed in your report.
select columns
Save it, and now you’re ready to run iReport with an active connection.
Build => Execute
There you have. Isn’t it simple?
