Count number of appearance in a column in SSRS

Question

I just want to ask if there is a way to count the appearance of data in a column like this on SSRS:

enter image description here

I would really appreciate your help on this.

Thanks in advance. :)

im asking if i can do it without using query. just the resultset in the report. — ohhzumm, Jul 22 '14 at 02:56
I know literally nothing about SSRS, but according to this question and answer, http://stackoverflow.com/questions/3006471/ssrs-calculating-counts-across-row-and-column-groups, it sounds like you're better off just making a view to do it, then reporting based on that view. I know that isn't exactly what you're looking for, but it sounds like the standard practice. But I could be misunderstanding, since again I know nothing of this stuff. — Matthew Haugen, Jul 22 '14 at 02:59

score 1 · Answer 1 · answered Jul 22 '14 at 03:14

Create another tablix and group it by the fruit column (make sure to add the group header).

Delete the detail row and the table header row so you are just left with the Group header.

If you want it all in one cell then use an expression something like =Field!Fruit.value & ": " & count(Field!Fruit.value)

You could always put the table inside the header or footer cell of the containing table

score 0 · Answer 2 · answered Jul 22 '14 at 03:09

First way - Add another table "tblGroups" after your detail
Second way - Add another row as the last row in the Fruits table outside of any grouping. Place "tblGroups" there.
Set a grouping condition "myFruitGroup" for tblGroups to =Fields!FruitID.Value
Set your text like <Expression>=Fields!FruitName.Value+" : "+CSTR(COUNT(Fields!Fruit.ID,"myFruitGroup"))

2 Answers2