I tried to create a form where multiple selected Purchase Orders with line items can be printed out together.
The Report Bands are:
Root
poheader
poline
poline got dataset from JPQL:
select pl.no as no, pl.quantity as quantity,
pl.price as price,pl.remark1 as remark1,
pl.remark2 as remark2,
pl.deliveryDate as deliveryDate,
pl.purchaseOrder.id as plid,
i.itemNo as itemNo, i.itemNameA as itemNameA,
i.itemUnit as itemUnit
from erp$PurchaseOrderLine pl, erp$Item i
where pl.purchaseOrder.id = ${poheader.id}
and pl.item.id = i.id
I am able to display the line items if only the first Purchase Order is selected. If I select other ones or multiple ones. The line items doesn’t appear. It seems like I am not able to iterate through the entities in the poheader.
How should I iterate through the poheader (Purchase Order) so that poline (Purchase Order Line Items) can match the header?
PO-Multipage-template-v2-20160920.docx (15.5K)
