not able to print report in one row

priti · 2011-04-07

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 · 2011-04-08

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 · 2011-04-08

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

abhinav0408 · 2011-04-08

Just group the Lot No. and calculate sum for Quantity

priti · 2011-04-08

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

j.marselo · 2011-04-09

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.

not able to print report in one row

Comments

Categories