read cell value

anyone can help me plz,

I have data like these in the report page:

Item_ID code_ID
xxx1 x1
xxx2 x2
xxx3 x3
xxx4 x3
xxx5 x3
xxx6 x2

I want get summary data like these:
code_ID x1 : 1 (items)
code_ID x2 : 2 (items)
code_ID x3 : 3 (items)

what should I do to get summarized data like that?
I've tried to use "CountDistinct" but the result always 6 that indicate how many of the data.

thank you.

Hi S

Im not sure what it is you want to do with the 'item'
count or sum?

I'm assuming count...

Use a table report and group by code_ID
then use items as your detail field and use
a 'Count()'

If what you want is to count the number of times a
certain code_ID appears you should use count instead of count distinct.

CountDistinct counts the number of unique entries where as count
counts the number of total entries.

I hope that I understood your question correctley
and be sure to tell me if I have not. If i was unclear
just let me know.

G