How to pick one record from the group

[crystalreport85]

The report I am working returns more then one record because of the linkage.
group1 ord number--order#1
group2 itemno
lineno quantity color

1 10 1
1 10 1
1 10 1
group2 itemno
lineNo Quantity color
2 2 2
2 2 2

group1 ordNumber --order#2

group2 itemno
lineno quantity color

1 10 1
1 10 1
1 10 1

My question is I have to add the quantity for each line where the color is equal to 1.My answer should be
QuantityCount=20
how to do it? How do I pick just one record from the group itemno? And
Thank you

 

[Turkbear]

Hi,
What is the linkage - what tables are involved and what is the structure involved?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

Insert a running total that does a sum of amount, evaluate on change of a formula:

(
onfirstrecord or
{table.orderno} <> previous({table.orderno}) or
{table.itemno} <> previous({table.itemno})
) and
{table.color} = 1

Reset never.

-LB