This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

generating reports in servlets?? MAHA please helppppp

 
Mohan R
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1467
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Mohan R
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
maha anna
Ranch Hand
Posts: 1467
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi indyahack,
the site u had mentioned is not getting connected.
Pls tell me the correct add.
regards
S Chandramohan
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,
Just remove the , ( comma ) after the com and it connects .
Kunal
 
salman rasheed
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic