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

RDL file not maintaining Extended File Properties

Please try this if you want...
1 For a .RDL file, right click on the file its self and select
"properties"
2 Click the "Summary" tab and enter information in any of the text
fields (Subject, author, ...)
3 Save it and then copy the file on another computer, is your metadata
missing just like mine?
It seems to be saving it somehow locally, but does not transfer with
the file. What gives?
We were originally trying to add some of the install info in here, but
seems to only be local.
Weird thing is... if you look at the same file over the network from
another computer, the information looks to be there, it looses it when
copied.oh well. I just found out why. This data is actually stored in NTFS
and is not in the file. Any time the file is copied into source safe
or email all properties are lost.