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 master/detail 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 "master/detail report in jsp" Watch "master/detail report in jsp" New topic
Author

master/detail report in jsp

Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
i have a list box with range of departments like 10-30 10-20.

I have to display a master detail report like

dno 10 dname aqqqqq

eno ename
1 a
2 b

dno 20 dname eeeee

eno ename
3 aa
4 bb

Using sql I get info like this

dno dname eno ename

10 aqqqqq 1 a
10 aqqqqq 2 b
20 eeeeee 3 aa
20 eeeeee 4 bb

What is the best way to store them in my java program
so that I can easily retrieve in my jsp in the desired format
and display as report with minimun code in jsp.
Ali Gohar
Ranch Hand

Joined: Mar 18, 2004
Posts: 572
Use a reporting software to do that job like Crystal Reports or JReports.
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
any help?
Ali Gohar
Ranch Hand

Joined: Mar 18, 2004
Posts: 572
Use inet crystal clear to use Crystal Reports with Java. Search through google for that.
Balan Raj
Ranch Hand

Joined: Aug 26, 2003
Posts: 74
Before jumping to a reporting tool, what are u looking at.. what is the ideal data-structure for storing such information? or how best to store in session or whatever ?

Storing it in JSP (session/request-attrbute) for future pages does not sound like a wise option to me, since data can grow & make the application really unscallable.

If u still need a datastructure, i would go for a dictionary keyed by department no ept name.. The value could be an array.


my 2c :roll:
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
ram,

can you give me a example using dictionary? i am using vectors. Is that ok?
Balan Raj
Ranch Hand

Joined: Aug 26, 2003
Posts: 74
Oh by 'dictionary', I just meant a dataStructure type.. Did not mean any Java Object... My thought was similar to the lines of a HashSet or hashtable
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: master/detail report in jsp