not able to print report in one row

priti

In my Report i have 3 dataitems (Indented in below manner)
Transfer shipment header
Transfer shipment Line
Item Ledger Entry

Some Code is Written in ILE dataitem foe Expiry date calculation.Thats y i have to use body of ILE to print report.But for 1 "item no "there are many lines in ILE with different Lot No .

I wanted the structure of report should be

Column 1 Column 2 Column 3
Item Description|Lot No1| Qantity|

---

|Lot No2|

---

|Lot NO3|


But my item description and quantity is repeating with lot no.
Please help me out how to write code for this.

j.marselo

it will be much easier if you arrange this way:
Item Description

---

|Lot No1| Qty|

---

|Lot No2| Qty|

---

|Lot No3| Qty|

so, get the item description from transfer shipment line, and put it in transfer shipment line section, lot & qty in ILE section.

priti

Thnx j.marselo,
But i want it in a single row.

abhinav0408

Just group the Lot No. and calculate sum for Quantity

priti

Thnx abhivav ,
but the description should also be printed only once for many lot Nos.

j.marselo

you need code to do that. define var: desclast - text and desc - text
in ILE - onpredataitem(), desc := ''; desclast := '';
in ILE - onaftergetrecord():
if desclast = ILE."description" then desc := ''
else begin
desclast := ILE."description";
desc := ILE."description';
end;
then use var: desc in your report section.