COUNT PROBLEM
-
Hi all, Iam wrking in sql reporting services .In that i want to find the COUNT OF male and female in report .I have used an expression fielD to find count of male and female but it returnS both the count of male and female ..IE (TOTAL ROWS VALUE) I have pasted my expression FIELD =Count(Fields!GENDER.Value="MALE") =Count(Fields!GENDER.Value="FEMALE") PLS ANY ONE GIVE SOLUTION FOR THIS
-
Hi all, Iam wrking in sql reporting services .In that i want to find the COUNT OF male and female in report .I have used an expression fielD to find count of male and female but it returnS both the count of male and female ..IE (TOTAL ROWS VALUE) I have pasted my expression FIELD =Count(Fields!GENDER.Value="MALE") =Count(Fields!GENDER.Value="FEMALE") PLS ANY ONE GIVE SOLUTION FOR THIS
-
could you use =SUM(IIF(fields!GENDER.value = "MALE", 1, 0)) =SUM(IIF(fields!GENDER.value = "FEMALE", 1, 0))