That worked perfect! I thought that because my report is looking at the date parameter as a string in my view that it wouldn't work and I would get a...

Thanks Rob. I will look into this option.

I answered my own question 🙂 Posting here for anyone else who has the same issue...

=COUNT(IIF(Fields!Call_Disposition.Value="Abandoned",1,Nothing))

Thanks Jeff 🙂

Thank you all very much for your responses and encouragement. I know how to do this in SQL, I was just hoping that SSRS has a faster and easier way...

I know this is a basic question, but I cannot seem to focus today. Thanks for your time.

Hi,

I am looking for the same thing. I saw a blog where a developer said that this is a limitation of SSRS e.g. SSRS is incapable of this. It looks...

Already got it, but thanks very much!

Thanks very much for your time Sean.

I can easily change the datatype column. What should that be? Decimal?

numeric(5,2)

0.53

0.53

Hey friends,

I have a hard deadline for today, can someone please help?

I know it's a dupe, I wanted to post with the code.