Count the number of distinct values in a column - SSRS

Question

Is it possible to have the summary below in one textbox within the same column:

Apple
Banana
Apple
Banana
Banana
Orange

Output:

Apple: 2
Banana: 3
Orange: 1

Yes this is possible. you can easily find this out yourself if you look for the functionality of `GROUP BY` in SQL. — Giorgos Betsos, Sep 04 '17 at 09:44

score 1 · Answer 1 · answered Sep 04 '17 at 10:50

Assuming that the fruits come from a field "Fruit" in your dataset, I would write something like this on the expression for the field where you want to set the summary:

= "Bananas: " & Sum(Iif(Fields!Fruit.Value = "Banana", 1, 0)) & Environment.NewLine &
"Apples: " & Sum(Iif(Fields!Fruit.Value = "Apple", 1, 0)) & Environment.NewLine &
"Oranges: " & Sum(Iif(Fields!Fruit.Value = "Orange", 1, 0)) & Environment.NewLine

See this --> Reporting Services - Count Column Values if equals A

Alfaiz Ahmed · Answer 2 · 2017-09-04T09:57:01.100

0

Here you will find something related to grouping in SSRS

https://stackoverflow.com/questions/18379581/grouping-in-ssrs

edited Sep 04 '17 at 09:57

answered Sep 04 '17 at 09:48

Alfaiz Ahmed

1,698
1
11
17

I'm referring to SSRS. – ohhzumm Sep 04 '17 at 09:51

Count the number of distinct values in a column - SSRS

2 Answers2