BIReportGuy
BIReportGuy

Reputation: 817

SSRS Count Distinct Expression into a Yes or No

I'm wondering if there's a way or an expression I could use in SSRS to show a Yes or No based on a Distinct Count function?

Example of what I'm currently using - RM_Name is the group

=CountDistinct(iif(Fields!qtrtradecnt.Value >= 15, 1, Nothing), "RM_Name")

I also would like to show if the qtrtradecnt is >= 15 to show a Y or N based on the RM_Name group, and maybe countdistinct is not the correct function to use...I've messed with this for days.

Thank you!

Upvotes: 1

Views: 240

Answers (1)

Harry
Harry

Reputation: 2941

One way to do this is to the calculation in your your dataset.. with a case expression..

select
...
,case when your_table.qtrtradecnt >= 15 then 1 else 0 end as rm_count 

from your_table

Then in your report just do a

=iif(sum(Fields!rm_count.value) >15 then 'Y','N')

Upvotes: 1

Related Questions