Skip to Content
0
Aug 03, 2016 at 03:44 AM

Display 1 row only in crystal report

105 Views

hi expert i dont know if this is correct please help me..

i have a 3 rows in JDT1

Account Linememo

4027 Cancellation

4027 Ayx001

4027 Ayx001

OINV

i want to display the U_40STD field UDF of AR-Invoice - e.g. U_40std = 2 so that i want to display 2

here is the code

if {JDT1.Account}= '4027' and Instr({JDT1.LineMemo},'Cancellation') = 0

then {OINV.U_40STD}*2 else 0

Output

2

2

2

But i want to display 2 only or one row only because if i used the suppress if duplicated when i summarize it will give total of 6. i want 2 instead...

thank you very much

regards

silent