2002 JI Open Discussion Posted August 17, 2006 Share Posted August 17, 2006 By: Muralidhar bp - pmurli Getting data from Multiple tables 2003-01-12 01:14 Hello, What are subreports and how this can be used. And one more query is .......... select b.BRANCH_CODE, b.BRANCH_NAME, count(c.customer_id) from TF_PAR_BRANCH_PERSONALIZATION b, TF_M_CUSTOMER c where b.branch_code=c.branch_code group by b.BRANCH_CODE, b.BRANCH_NAME THis query gets the data from two tables and is it necessary to use sub reports. Please help me, it is very urgent. Thanx Murli By: Teodor Danciu - teodord RE: Getting data from Multiple tables 2003-01-13 01:25 Hi, If you can retrieve all the data you need in a single SQL query, using joins like this, you don't necessarily need subreports. The actual number of tables joined in the query is not important. JasperReports is interested only in the ResultSet. It can work with only one ResultSet per report/subreport. Only if you have multiple queries you'll need subreports. I hope this helps. Teodor Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now