Reporting solution in java 1

[Rajesh99]

I have a Oracle 9i database and I want to generate 10/15 reports in pdf that users can view and print thru IE browser. Really not interested to buy a tool like crystal or oracle report writer etc. Are there some freeware I can use in my JSP code to do this. I just picked up pdf since Acrobat will give me page numbers and preview/print options and it does a good job of keeping format intact?


Thanks

 

[sedj]

http://www.pdfbox.org/

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[siberian]

Jasper reports jasper reports jasper reports

http://jasperreports.sourceforge.net

This tool is awesome, I just finished integrating it into our solution and the customers really like it. Once you learn it you can do some incredible things with it.

Exports to PDF, CSV, Excel and you can write your own export engines.

I (heart) JasperReports.

 

[Rajesh99]

Is Jasperreports a freeware? This seems like a servlet solution. I have a JSP page that makes up HTML report, I was thinking simplest task will be for me to create a
pdf file based on this table and users preview and print. All this I was looking at doing form JSP. Any clues in this area?

 

[siberian]

Jasper reports is LGPL meaning 'yes its truly free'

It can be run in any number of contexts, applet, servlet whatever, its just a set of classes, you can integrate it however you want. Servlet is the easiest in a web context but there is no reason a JSP page couldn't do the same stuff and just change the content-type.

JasperReports!

 

[Rajesh99]

While researching on web I came across these tools that are free:
itext
Jreport
Jasper

Any idea which is a thin library and least learning time. Really I am looking at passing some parameter and allow preview/print with page numbers(if possible) out of sql against Oracle database. We have tomcat on Solaris to provide us backbone.

Any advise on above.

Thanks

 

[siberian]

ireport is just a report construction ui based on jasperreports.

Jasper reports its easy, just feed it a JDBC result set or an actual SQL query in the simplest implementation.

The source comes with examples for all of this.