BIRT newbie - Subreports

cobirtops

Appreciate the help anyone can give. Here's the given:

Main dset is "WO" with simple sql query of: select wo from workorder where wo = ?. Sample result set would be:

wo
123

Second dset is "PH" with sql of select wo, ph from phase where wo = ?. Sample result set would be:

wo phase
123 001
123 002
123 003

Third dset is "LABOR". SQL would be select wo, ph, timecard from labor where wo = ?. Result would be:


wo phase timecard
123 001 0901
123 001 0904
123 001 1543
123 002 5456
123 003 3987


Last dset is "MATERIAL". SQL is select, wo, ph, release_no from material where wo = ?

wo phase release_no
123 001 02001
123 001 02002
123 002 04545
123 003 06754

My desired report layout is:


WO 123

PH 001

LABOR:

TIMECARD 0901
TIMECARD 0904
TIMECARD 1543


MATERIAL:

RELEASE 02001
RELEASE 02002

---

PH 002

LABOR:

TIMECARD 5456


MATERIAL:

RELEASE 04545

---

PH 003

LABOR:

TIMECARD 3987


MATERIAL:

RELEASE 06754


Can this be done by subreport?

Thanks.

fwhorton

it looks like it can be.

main report ph (detail 1)
subreport link ph to labor (detail 2)
subreport link ph to material (detail 3)