Cyrstal Report count

Need help. I am new to crystal reports. I have the sql below that would run perfectly fine unders windows SQL 2000 server and give me the results that I needed. But I can't get the correct count from crystal report if I only want each distinct record to shown once.

SELECT TYPE, PART_NUM, COUNT(PART_NUM) AS Expr1
FROM dbo.ITEM
GROUP BY PART_NUM, TYPE

type part_num count

Monitor gx260 20
Monitor gx620 40You might need to use distinct count in Crystal.

GJ