I have created a report for showing GRN numbers punched series wise. The Problem i face here is If a particular GRN has 4 items against it, the GRN report(page) repeats 4 times, if there are 5 items, it repeats 5 times.How do i break the loop ?? I want to Limit this only to one.
How do i do this ? Cant think of anything…
code i’v written in fetch method
qRun = new QueryRun(this);
while(qRun.next())
{
vendPackingSlipJourargs = qRun.get(tablenum(vendPackingSlipJour));
element.send(vendPackingSlipJourargs);
while select vendPackingSlipTransargs
where vendPackingSlipJourargs.DeliveryDate == vendPackingSlipTransargs.DeliveryDate
&& vendPackingSlipJourargs.PurchId == vendPackingSlipTransargs.purchId
&& vendPackingSlipJourargs.PackingSlipId == vendPackingSlipTransargs.PackingSlipId
&& vendPackingSlipTransargs.InternalPackingSlipId == VendPackingSlipJourargs.InternalPackingSlipId
{
element.send(vendPackingSlipTransargs);
element.execute(1);
while select inventDimargs
where vendpackingsliptransargs.InventDimId==inventdimargs.inventDimId
{
element.send(inventDimargs);
}
}
element.newPage();
}
return true;