Link to home
Start Free TrialLog in
Avatar of jquarter
jquarter

asked on

Java-based Report Writer

We would like to integrate a report writer (such as Crystal Reports) into a Java-based application.  The design created by the application is a series of canned reports in HTML and CSV format that are generated using Java (writing text to files) of which the HTML version is accessible through the GUI via menus.   Our customers like the canned reports, but the total inflexibility makes them not practical for the long-term.  Ideally, I  would use Java to dump the data into relational tables (XML, CSV, or other ODBC-compliant format), and use an imbedded report writer to generate the canned reports, while making all the data accessible for our customer via the tables so that they can link to them and generate custom reports via thier own report writer, Access, etc.  Our appication is single -user, but is used on mulitple platforms (Windows, NT, Linux, Unix), and Crystal Reports, JReports, etc., won't work for us except via a web server, which the company doesn't want to do.  The only option I can see now is to write a basic report writer to generate the appropriate SQL, then use JDBC to generate the results table and dump to XML.  Does anyone know of a reasonably-priced  commercial report writer that I can integrate into the app, that doesn't require a web server ?
ASKER CERTIFIED SOLUTION
Avatar of dviji
dviji

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jquarter
jquarter

ASKER

Thanks for the help.  Doesn't look like The ideal solution is out there, but this is closer than where I was.