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)
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
Share
Report
All responses (
Answers (
