How We Display Date wise student attendance reports?

Question

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 ?

Pravin Ghadge · Answer

In cross tab threre is option of hw to disply columns in report. Just search on cross tab u will get ur answer. It is very much easy.

znaneswar kodavanti · Answer

Thanks for your reply Pravin Ghadge but i dont know how to do. if you dont mind let me clear one. how can i get those columns as 1 2 3 ..... 23 24 25 . . .

Pravin Ghadge · Answer

hi Use crosstab report in crystal report.