generating reports in servlets?? MAHA please helppppp

[Mohan R]

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]

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]

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]

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 [email protected] as early as possible . Thanks and regards
mohan

[Mohan R]

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 [email protected]
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]

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 [email protected]

[maha anna]

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]

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]

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]

hi indyahack,
the site u had mentioned is not getting connected.
Pls tell me the correct add.
regards
S Chandramohan

[Anonymous]

Hi ,
Just remove the , ( comma ) after the com and it connects .
Kunal

[salman rasheed]

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]

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]

We have updated the JavaRanch forum since then, which is why the link is invalid.
Try this one:
https://coderanch.com/t/347584/Servlets/java/IE-Netscape-conflict-again