reporting framework or tool

[varocho]

Can anyone recommend a reporting framework or tool that has the following
features:

1. SQL statement separate from presentation
2. Output configurable with XML files
3. Input (prompting parameters) configurable with XML file
4. Paging through data predictable and efficient
5. Quick performance
6. Low on memory
7. Easy and quick development
8. CSV, Excel, Adobe, etc. formatting

?

 

[JVZ]

Here are a couple of products:

http://www.object-refinery.com/jfreereport/index.html

- This free..and per the WebSite:
[ul]
[li]full on-screen print preview;[/li]
[li]data obtained via Swing's TableModel interface (making [li]it easy to print data directly from your application);[/li]
[li]XML-based report definitions; [/li]
[li]output to the screen, printer or various export formats (PDF, HTML, CSV, Excel, plain text); [/li]
[li]complete source code included (subject to the GNU Lesser General Public Licence); [/li]
[li]extensive documentation in Acrobat PDF format, plus full Javadocs; [/li]
[/ul]

http://jasperreports.sourceforge.net/

- Another free product..per WebSite:
JasperReports is a powerful report-generating tool that has the ability to deliver rich content onto the screen, to the printer or into PDF, HTML, XLS, CSV and XML files.

Crystal Reports - If you can spend some money....however I found it little diffcult working this product into my Java App.

http://www.java4less.com/print_java_e.htm

- Never used this before - However come across it while doing a search on this topic.

Also another good product is Oracle Reports...

http://www.Oracle.com.

Hope this helps.

 

[tshivam]

Hi,
We too had the same requirements and chose Jasper Reports for our project. Its easy and free as well. It has two Designer UI to design ur template : iReports and Jasper designer. ireports was much much better than jasper designer

We also considered Jreport and Report mill, but they were overkill considering the basic requirements for our project.
Thx
ShivA