Getting data from Multiple tables

[2002 JI Open Discussion]

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