Group by problem in Crystal report..

[sachindeva]

Hi,


i have two columns in my table (ACT)

activity cost

a 10
a 10
a 20
b 30
b 30


And here i will be displaying in crystal report group by 'a' database field with total amount


we should display looks like


activity Cost

a NA

b 30



So how do we display in this format in crystal report.


(Note : this is my requirement to display 'NA' for 'a' row since in my table (ACT) 3rd row value is different compare to first two rows. )


Thanks & regards
Ramesh
sapdeva@yahoo.com