How to Display Date wise Employee 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 ?

ashok reddy · Answer

Thanks for your reply Sivaraman Dhamodaran

Sivaraman Dhamodaran · Answer

1) Check the Internet or our C# corner and learn how do I create CrossTab Report in Crystal reports. Or 2) Search for creating the CrossTab Query. Once you have the result you need created a view on your query and use that View on your reporting App.