mardi 21 avril 2015

How to count record using 2 conditions in crystal report

I have a table in crystal report with rows and columns, for each intersection of row (Projects) and column (Employees), I want to put a count of records using 2 conditions (value of row and value of column) I tried: if ({table.NameEmployee} = "Mark" and {table.ProjectName} = "Project1") then count ({table.idEmployee}) and the same thing for the other intersection with different value of row and column but it doesn't work !!

Aucun commentaire:

Enregistrer un commentaire