Click here to Skip to main content
15,867,453 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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]

CSS
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]
Posted
Updated 11-Jul-13 19:44pm
v3
Comments
Maciej Los 11-Jul-13 6:39am    
Please, post example data...
poiuytrewq12349876543 11-Jul-13 22:56pm    
hi Maciej,
I had posted some sample data,
Can you help me out...
Sushil Mate 12-Jul-13 1:45am    
you need to group by emp name then you will get your desired result.
poiuytrewq12349876543 12-Jul-13 4:00am    
sushil, group by will surly give the result, which my data already having.

can you pl. tell me how it could result the Groups in a column header.
Sushil Mate 12-Jul-13 4:32am    
check my solution.

Have a look here: dynamic columns in Crystal report at runtime [^]. There you'll find 2 links. ;)
 
Share this answer
 
Comments
poiuytrewq12349876543 13-Jul-13 13:29pm    
seems nice Los,

I am little busy on other stuff today,
surly check and get back to you on this
anyways thanks for your concern... :)
 
Share this answer
 
Comments
poiuytrewq12349876543 11-Jul-13 9:00am    
Deenuji, 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
Have a look, it will solve your problem.

C# crystal reports string parameter.[^]

Custom Field in Crystal Report[^]
 
Share this answer
 
Comments
poiuytrewq12349876543 16-Jul-13 4:26am    
Thanks for you concern sushil

but if you could help me out with more clear details or any code sample available to download...
I am little confused with the example and could do in with VS2010 vb.net.

Thanks

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900