Display 1 row only in crystal report

[former_member366557]

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

[abhilash_kumar · Accepted solution]

Hi Silent,

Insert a Group on the Account field and place the Calculated Field on the Group Header.

Suppress the Details Section.

For summaries, use a Running Total set to 'Evaluate' when the Group Changes.

-Abhilash