aspose file tools*
The moose likes I/O and Streams and the fly likes Report Generation Tool for huge data in PDF , XLS , RTF , XML formats Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » I/O and Streams
Bookmark "Report Generation Tool for huge data in PDF , XLS , RTF , XML formats" Watch "Report Generation Tool for huge data in PDF , XLS , RTF , XML formats" New topic
Author

Report Generation Tool for huge data in PDF , XLS , RTF , XML formats

karthik Suryanarayanan
Ranch Hand

Joined: Oct 07, 2009
Posts: 115

Dear All,
I need to generate reports for huge data (around 2 to 5 lakh records) in different file formats in my web application.

Data will be fetched from database.

I have been searching for a best open source report generation tool and ended up on choosing on Dynamic Reports.

Aspose , is licensed and unluckily we could not afford to at this moment.

I request for all your suggestions as to whether i can use Dynamic Reports , or is there any other tool available.

Thanks.


"Learning is a Culture where your Eagerness & Curiosity plays a major Role".
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42286
    
  64
JasperReports comes to mind.


Ping & DNS - my free Android networking tools app
karthik Suryanarayanan
Ranch Hand

Joined: Oct 07, 2009
Posts: 115

Hi Ulf ,
Yup. I guess , Jasper Reports might need more coding than Dynamic reports. And also Dynamic Reports is based on Jasper.

Need to validate on the server performance as well as this can crash the server if wrongly implemented.
Arun Giridhar
Ranch Hand

Joined: Mar 10, 2012
Posts: 147

go for dynamic reports. Start More.I have used for sample never used for actual application. The only drawback is they dont have active forum.


hate Professionalism . Join the http://2014.hack.lu/index.php/Main_Page
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16145
    
  21

Aside from the technical issues, though, this reminds me of a similar assignment I had way back in the earliest days of my career.

I was given the task of generating a multi-level report that would be run daily and emit about 2-1/2 boxes of IBM fanfold printout. That means 2.5 boxes of 2000-pages at 60 lines per page.

This was obviously nothing but a data dump, since no human being is going to read that much, period, to say nothing about daily. We accepted the assignment knowing full well that it was going to tie up the printer, destroy trees, consume ink, wear out ribbons and type chains and more often than not, get discarded unread. We didn't have Earth Day back then and it was all billable anyway.

There was little enough excuse for such things back then, when data tended to mostly be locked away on magnetic tapes, but these days it's considered to be more or less trivial to hack out a data query and drill down for the information you actually need, instead of wading through reams of eye-watering raw output.

In fact, the next level up when you're talking masses of data is Business Intelligence. The Pentaho BI suite is available in a fully-functional free Community Edition, and its report writer is pretty good (in fact, they used to use Jasper). Plus it can do OLAP stuff and other things that are not only impressive buzzwords but actually very powerful business tools.

I use their Kettle tool extensively to convert and transform stuff like Excel to database tables, database tables to CSV or XML and similar extraction, transformation and loading operations. One daily scheduled job unloads most of a database to CSV files and FTP-transfers them to an offsite Software-As-A-Service data analysis service. All automatically.


Customer surveys are for companies who didn't pay proper attention to begin with.
 
wood burning stoves
 
subject: Report Generation Tool for huge data in PDF , XLS , RTF , XML formats