How to make a crystal report for counting number of records against all unique register members? RRS feed

  • Question

  • 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?


    employee ID                  total presents                                                                        
    12345                           24

    78542                           27

    Saturday, July 29, 2017 8:46 AM