SSRS Count function expression

(0) Share

Report

Posted on by Shane Brown

190

I have a text box on my ssrs report and I want to count the number of records that the S_Type = ''New" in an expression from a dataset called MemberDetails.

=Count(Fields!S_Type.Value, "MemberDetails") returns all the records, how can i make it count only ones that S_Type = ''New".

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

VermaNitin 455 on at

Like (1)

Report

Hi,

You can modify your count function something as shown below.

Sum (if(Fields!S_Type.Value=="new",1,0),"MemberDetails")

Hope it helps!

Many thanks,

Nitin Verma

Was this reply helpful? Yes No