Reporting Tool
Hi, I want to generate some reports in my application. I am currently using Struts as a framework. The current architecture for generating reports uses Crystal Report 9.0 The problem faced with this are 1. The data in the crystal report can be read only from a data source i.e. tables. Therefore there is a need to create some table for reports. 2. The reports needs to be presented in such a manner that the rows needs to be converted into columns. (Transpose) The transpose logic makes the reports response time very slow. 3. There is a need to make a call to IIS. Can somebody suggest a reporting tool which has got the features like Crystal Report (Export, Print, Group, Page Header, Page Break) but can also use the data of the java classes for generating reports. I have heard of Datavision, JFreeReport tools but not sure whether they can take data from java classes to generate reports and have the same features.. Taking data from java classes is important as it will be easy to put the transpose logic in the java code and will in the end improve the response time of reports. Thanks, Shailender Jain
AW: Reporting Tool
I'm using the http://jasperreports.sourceforge.net/ and the design tool iReport http://sourceforge.net/projects/ireport/. Ralf -Ursprungliche Nachricht- Von: Shailender Jain [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 16. Juni 2004 08:37 An: [EMAIL PROTECTED] Betreff: Reporting Tool Hi, I want to generate some reports in my application. I am currently using Struts as a framework. The current architecture for generating reports uses Crystal Report 9.0 The problem faced with this are 1. The data in the crystal report can be read only from a data source i.e. tables. Therefore there is a need to create some table for reports. 2. The reports needs to be presented in such a manner that the rows needs to be converted into columns. (Transpose) The transpose logic makes the reports response time very slow. 3. There is a need to make a call to IIS. Can somebody suggest a reporting tool which has got the features like Crystal Report (Export, Print, Group, Page Header, Page Break) but can also use the data of the java classes for generating reports. I have heard of Datavision, JFreeReport tools but not sure whether they can take data from java classes to generate reports and have the same features.. Taking data from java classes is important as it will be easy to put the transpose logic in the java code and will in the end improve the response time of reports. Thanks, Shailender Jain - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Reporting Tool
1. The data in the crystal report can be read only from a data source i.e. tables. Therefore there is a need to create some table for reports. What else would you expect for #1? 2. The reports needs to be presented in such a manner that the rows needs to be converted into columns. (Transpose) The transpose logic makes the reports response time very slow. My CR experience dates back to 7.0 (pre java tools) but what I would do is try to get the database to help me out here. I always found that a reporting tool was only as good as the database query you gave it. If you pull 80 bazillion records from the database, your transpositioning is going to be slow no matter what. Ideally you want Crystal (or any reporting tool) to generate query results that are already digested into something close to the report format. This is good because 1) The database can typically do it faster than Crystal can and 2) It means Crystal _should_ have less data to digest and the report should come out faster (and your report machine might not run out of #@*#@ memory again). Anyway most reports I found broke down to something with mathemical operations (often summations) of various fields, broken down by some other combinations of fields. So, whenever possible I tried to use the Crystal CrossTab report format. Failing that (it didn't always look pretty in excel), I structured my report in such a way that Crystal could generate smart SQL. You want to massage the report such that instead of it generating SQL like SELECT f1, f2, f3, f4 from table where criteria you want it to come out Select f1, f2, AVG(f3), SUM(f4) from table where criteria GROUP BY f1, f2, f3, f4 You could get version 7 to make SQL like that on a good day. Failing this, you want someone (assuredly NOT a junior level report designer) available to look at the explain plan for the query Crystal is going to use and can tweak the database indexes as neeeded. I found that rarely do suits want to look at the database in the way the database design anticipated. HTH -Joe - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Reporting Tool.
There was a discussion on this a while back: http://www.mail-archive.com/[EMAIL PROTECTED]/msg95747.html Niall - Original Message - From: Marcelo Epstein [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Thursday, April 15, 2004 4:07 AM Subject: Reporting Tool. Hi, I need to create some reports in my application. Which is the best tool available to work with Struts? I read about JasperReports, is it the way to go with Struts? Thanks in advance. Marcelo - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]