How to add columns for a crystal report?
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