File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
JavaRanch » Java Forums » Java » JSP
Bookmark "Report in JSP" Watch "Report in JSP" New topic

Report in JSP

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
2 asdasd ddd

The way data stored in tables

eno ename
1 ahsdgas

2 asdasd

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

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.
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
r there any examples on net
I agree. Here's the link:
subject: Report in JSP
It's not a secret anymore!