This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Servlets and the fly likes generating reports in servlets?? MAHA please helppppp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "generating reports in servlets?? MAHA please helppppp" Watch "generating reports in servlets?? MAHA please helppppp" New topic
Author

generating reports in servlets?? MAHA please helppppp

Mohan R
Greenhorn

Joined: Oct 19, 2000
Posts: 3
hello friends,
I would like to know if any body has used a THird party componet for genearting database reports using
java servlets.
I would exactly like to know how to embed the reporting tool object in the servlet so as to dynamically generate queries.
May be even crystal reports also.
maha anna please try to help.
thanks in advance
- regards
mohan
maha anna
Ranch Hand

Joined: Jan 31, 2000
Posts: 1467
I haven't used any till now. Maximum I went to display using Excel s/w. I definitly let you know if I come across any.
regds
maha anna
S Chandra Mohan
Ranch Hand

Joined: Oct 19, 2000
Posts: 75
hello,
upto my knowledge u cant embedd reporting utility with servlet.
but u can call a predefined crystal report with parameters
which can display the output in a viewer.
if u want more details on this feel free to contact


Have a wonderful day and wish u success<p>S Chandra Mohan<br />sc_mohan_us@yahoo.com
Mohan R
Greenhorn

Joined: Oct 19, 2000
Posts: 3
hello chandra mohan,
Thanks a lot for u r response. can u reply me in detail as how u have used the crystal report objects so that i will have an idea regarding the same.
Can i have u r email id so that i can contact u.
please do reply as early because it is very urgent , we have to finish reports for a project as early.
Have u worke don other reporting tools like JREPORT(www.jinfonet.com) or ENTERPRISEREPORT(www.enterprisesoft.com) can they be used as u have used crystal reports.
Please contact me on alit_mohan@rediffmail.com as early as possible . Thanks and regards
mohan
Mohan R
Greenhorn

Joined: Oct 19, 2000
Posts: 3
hello maha,
Thanks for u r response but can u please send me in detail how u have used the same to my email i.e alit_mohan@rediffmail.com
preferably the code or concept to do the same.
Actually one of the utility we have to develop for our project is to save the generated database reports in different formats like .txt,.doc,.csv(excel).
Please do mail me regarding the same as how to generate reports in excel using java servelts, i am trying with 2 reporting tools JREPORT and ENTERPRISE REPORTS.
Please reply as eraly it is very important.
bye and regards
-mohan
Chidananda Sulur
Greenhorn

Joined: May 10, 2000
Posts: 14
Hi Maha,
Can you also please mail me how to save the generated db reports in other formats like excel etc.. My e-mail id is chidusv@yahoo.com


Chidu
maha anna
Ranch Hand

Joined: Jan 31, 2000
Posts: 1467
Hi all,
It is simple. we have to set the 'content type' of the response to be an application. I have discussed it previously here. Please have a look at this. In the html when you seperate 2 words by a tab, then those 2 words are considered as indivudual cols. There is another easy way. Put all your data inside a table. Excel application renders it easily as rows and cols as in html table. I like this way and found it useful. I generate dynamic tables from database and set the content type in the .jsp file. When a request is made to the jsp file, a dialog box will appear to the user asking if he/she wants to opent it or save it as excel file like that. Please refer to this discussion.
http://www.javaranch.com/ubb/Forum7/HTML/000621.html
regds
maha anna
[This message has been edited by maha anna (edited October 23, 2000).]
S Chandra Mohan
Ranch Hand

Joined: Oct 19, 2000
Posts: 75
at present we are using
seagate crystal reports.
u can load the report server in a nt machine and can call it
from any browser
Reports can be framed using crystal reposts utility or
crystal reports sql designer.
these reports can be called from java scrips or servlets by passing the conditional parameters(like dates or code) as arguements.
fell free to contact
i have mailed the same for u also
indyahack
Greenhorn

Joined: Oct 24, 2000
Posts: 7
Hi,
i think that insetsoftcorp's jreportwriter is a very good report writer, you can goto www.inetsoftcorp.com, to check out its features. we tried it it worked .
S Chandra Mohan
Ranch Hand

Joined: Oct 19, 2000
Posts: 75
hi indyahack,
the site u had mentioned is not getting connected.
Pls tell me the correct add.
regards
S Chandramohan
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
Hi ,
Just remove the , ( comma ) after the com and it connects .
Kunal
salman rasheed
Greenhorn

Joined: Aug 16, 2001
Posts: 6
Hi,
The link http://www.javaranch.com/ubb/Forum7/HTML/000621.html does not work. Could somebody point me to the right one.
Thanks in advance.
Praveen Kumar Jha
Greenhorn

Joined: Jul 27, 2002
Posts: 10
Mohan,
You can try Formula One, in the case you want to create Excel report on the server side.
http://www.actuate.com/f1/home/index.asp
Praveen


Praveen Kumar<br />Sun Certified Programmer for Java 2 Platform
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

We have updated the JavaRanch forum since then, which is why the link is invalid.
Try this one:
http://www.coderanch.com/t/347584/Servlets/java/IE-Netscape-conflict-again
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: generating reports in servlets?? MAHA please helppppp
 
Similar Threads
Creating the crystal reports from Java
Crystal Reports using java servlets.
Jasper report
reports in java
RequestDispatcher - Need Help!!!