Discussion Locked

Web Reporting

0 helpful
12 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We are developing a web-based financial accounting application using Java but we have a problem: we don?t know how to provide reports to the users of the application. We would like you to advise us how to build the ad-hoc queries and how to store and display the results (the reports).

12 replies

by john.mallonee

One option is to use an enterprise reporting tool such as Cognos' Impromptu or Crystal Decisions' Crystal Reports. These tools allow you to build report formats with a nice graphical representation. They also allow you to run the reports ad hoc over the web. They both have cost and infrastructure implications, so they are a strategic decision and not just a simple answer to one application's reporting needs. See www.cognos.com and www.crystaldecisions.net for these particular reporting solutions.

by dnu

Thank you for your answer. We have thought of such a solution but it is unacceptable for our client. So, we need another solution using HTML, .pdf, Java or whatever!
If you have another idea please tell me what it is!

by khamus

WHy don't you check the documentation on www.iowagie.cmo/itext3.0? this is a free API for the creation of PDF's on the fly, another option would be to use a JSP to assemble the report on-the-fly, but I don't know about your client requirements, maybe they need more security on those reports? Also, the problem is only on writing those reports or in getting the queries to display the results?

feel free to contact me!

by rohanm

Hello,
Since ur using Java as a tool for development, u can always use JSP to create the reporting tool along with our good old HTML. In the JSP page u can have prepared statement for ur queries. This will reduce the time taken to complie the pages as the Prepared statement is checked initially. U can use tables to display the data that u have retrived via the query. Also there is no need to get all the data at the same time as u can provide hyperlinks for them. This will be useful when ur having a drill down report.

Hope that this will help u
Rohan.

by afsarp

You can use the jreport tool, it is good and provides full integration with the application and it is developed in java
it has good features you can export the report the format u like and u can schedule a report to a email account.
have a look at
www.jinfonet.com

This discussion is closed to new replies.