Hello
I have a table for attendance Data with columns as follows
Date - EmployeeID - EmpName - TimeIn - TimeOut - Remarks
it has the coloumn filled with appropriate data.
now i would like to have the reports in some differant style as:
EmployeeNames As header
Date,timeIn,TimeOut and Remarks column as data.
can anyone help me out to get this kind of result in c# or vb.net OR crystal reports of particular style
Thanks
I had already posted a little sample data in answer to one reply here....
further explanation is as under:
its an attendance report having data from biometric device.
which returns data as: ID, Name, Date, TimeIn, TimeOut, and more...
but i need to show the name as column header and date, TimeIn and TimeOut as data rows under the headers. for example:
it may contain 40-50 employees, and we are having a register with empName as header at upper side and date as row header at left side. And In-Out time as data.
[Edit]
its simple list showing in a report format,
Am I not able to express my concern/requirements properly...
I need to show the data in the Name/Last name column as headers
database table data is as under:
8Apr13 1 Manpreet Kaur 07:20:26 13:39:52
9Apr13 1 Manpreet Kaur 07:18:48 13:37:55
10Apr13 1 Manpreet Kaur 07:24:30 13:38:20
8Apr13 2 Harpreet Singh 07:26:33 13:40:22
9Apr13 2 Harpreet Singh 07:32:37 13:38:35
10Apr13 2 Harpreet Singh 07:14:52 12:17:01
and so on for multiple employees...
I would like to report it as
Headers:
___________|______________________|_____________________|
___________| Manpreet Kaur |Harpreet Singh |
___________|______________________|_____________________|
8Apr |07:20:26 | 13:39:52 |07:26:33 | 13:40:22 |
--------------------------------------------------------|
9Apr |07:18:48 | 13:37:55 |07:32:37 | 13:38:35 |
--------------------------------------------------------|
10Apr |07:24:30 | 13:38:20 |07:14:52 | 12:17:01 |
--------------------------------------------------------|
hope I am clear now...
Pl. suggest me if you have any solution to it
Thanks for your time
[/Edit]