Java-based Report Writer
Posted on 2001-08-09
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 ?