i'm new comer as a programmer so i want to make a crystal report for an **Employees attendance project** so i have table "Attendance" in SQL DB and in this table have some columns (id,status(present/leave), and last one is Date) i want to display
a list of all employees with their "id" and a column "total Presents" so how to i'm counting employees total presents in a specific month and showing in a list in crystal report?
like
////////employee ID/////////// ///////total presents/////////
//////// 12345 /////////// ////////////////// 24 /////////////
/////////21546////////// ////////////////// 28 ////////////////