File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JSP and the fly likes Report in JSP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Report in JSP" Watch "Report in JSP" New topic
Author

Report in JSP

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I have to generate a report and value for one column is many

for eg my report should look like
eno ename status
1 ahsdgas bbb
aaa
ccc
2 asdasd ddd
aaa


The way data stored in tables

emp
eno ename
1 ahsdgas

2 asdasd

emp_status
eno status_id
1 2
1 1
1 3
2 4
2 1

status
status_id descr

1 aaa
2 bbb
3 ccc
4 ddd
5 eee
6 fff

Is it possible to generate report like that in JSP
Give me some ideas...
Jeffrey Hunter
Ranch Hand

Joined: Apr 16, 2004
Posts: 305
This is certainly possible. Ideally, you'd want your Servlet to retrieve the data from the database and feed it to the JSP, at which point the JSP will use custom tags to dynamically build the tables. You can set page breaks in the HTML to create a printer-friendly report that can be printed easily.

If all this sounds alien to you, just ask a more detailed question, and you'll most likely get an answer/suggestion which is more descriptive.
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
r there any examples on net
 
Consider Paul's rocket mass heater.
 
subject: Report in JSP