I was preparing a SSRS report to get count of users title starts with 'QA' (example QA Lead, QA Analyst, etc) in my report, and atlast found the solution
=SUM(IIF(Fields!UserTitle.Value LIKE "QA*", 1, 0))
=SUM(IIF(Fields!UserTitle.Value LIKE "QA*", 1, 0))
No comments:
Post a Comment