How to add columns for a crystal report?

May 18 2012 8:30 AM
Hi friends i have a table as follows
student table
id lastname firstname phoneno
and another table as attendance as follows
id date in/outstatus

here date is every day date and in/out status is weather the id is came to school or not

in the second table i have dates now my problem is
i have to generate attendance report based on a month the report should be like as follows
id date1 date2 date3 . . . . . . . .date30

now how can i create date1 date2 ... date30 in crystal report?
i have only one column that date in attendance table


Plz help me

regards
znaneswar