SSRS Mobile Reports Distinct Count

Question

Anyone know how to get a distinct count in ssrs 2016 mobile reports?

The built in aggregation only offers a count, not distinct.

CountDistinct() function can be used – Kashif Qureshi Oct 19 '17 at 17:05 — Kashif Qureshi, Oct 19 '17 at 17:05

score 0 · Answer 1 · answered Oct 19 '17 at 17:06

0

use CountDistinct() function in ssrs 2016

More info here: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-countdistinct-function

answered Oct 19 '17 at 17:06

Kashif Qureshi

1,460
2
13
20

That works in paginated ssrs reports it there's no way to use it in Mobile Reports – John Millward Oct 19 '17 at 20:48

score 0 · Accepted Answer · answered Oct 27 '17 at 15:18

0

Mobile reports are extremely limited compared to paginated reports. As you suggested, there's no way to do a distinct count in the visualization, you would need to do it in the dataset beforehand.

answered Oct 27 '17 at 15:18

StevenWhite

5,907
3
21
46

It almost makes sense that there needs to be a round trip to the database to work out the distinct at different levels of aggregation, or there would be quite a lot of work required on the client side and records held at a low granularity. - Just wanted to check that I wasn't missing a trick - looks like paginated for this one! Thanks – John Millward Oct 30 '17 at 12:31

SSRS Mobile Reports Distinct Count

2 Answers2