Multiple select statements on ireport\'s editor

[rajuchacha007]

Hello experts,

 

I have been trying to work on multiple select statements in ireport. I want to fire two different queries for header section and details section from two tables. How could I do it? I am trying by using inner join on. I am not able to see desired results.  Assume I have got 2 tables called employee and org.

Employee

ID           code                status code

1             xyz                    present

2            abc                  absent

3            pqr                   present

for header i want to use (i am using btw) following query.

select employee.ID ,employee.CODE, employee.STATUS_CODE from employee

 

table org

org_ID     

ID            name                 STATUS_CODE

1             efg                        Y

2             def                        N

3              tyu                        N

4             acd                        Y

for details i want to use following query.

select org.ID,org.name,org.STATUS_CODE from org

 

Is it possible to use 2 two different select queries from 2 different tables in ireport? Please advise/suggest. Thanks in advance.? Later I have been trying to use following statement to join although it's not correct technically as IDs should be different. I tried just for a chance.

employee.ID ,employee.CODE, employee.STATUS_CODE ,org.ID,org.name,org.STATUS_CODE from employee INNER JOIN org ON emp.ID=org.ID

[rajuchacha007]

Experts, has anyone worked on this? Is it possible to do it in query editor of ireport or should I change my track? Please suggest.

[mandm]

Looks like ireport cannot do it without using something like subreports

[rajuchacha007]

@mandm.

 

Thank you. Yes subreports might work for it. Any good tutorial of subreport which is easy to understand? I have gone through 2-3 tutorials but they are too fast and use much older version. I am using 3.7.1

 

Best regards.