ashok reddy

ashok reddy

  • NA
  • 10
  • 0

How to Display Date wise Employee attendance reports?

Sep 24 2012 3:13 AM
In my project i want to display the student attendance reports in Date wise..but i maintained a single table for storing all attendance details...In my table the records are stored as,
E.No Name            Status   Date
225   Arun              A         08/25/2011
226   Jegankumar   P         08/25/2011
225   Arun              P         08/24/2011
226   Jegankumar   P         08/24/2011
225   Arun              A         08/23/2011
226   Jegankumar   P         08/23/2011
here i want a report in following format,
E.No      Name          23   24   25
225     Arun               A     P    A
226     Jegankumar   P     P    P


how i get this ?

Answers (2)