Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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]
Posted 11-Jul-13 1:22am
Edited 11-Jul-13 20:44pm
v3
Comments
Maciej Los at 11-Jul-13 6:39am
   
Please, post example data...
yeahgrp at 11-Jul-13 22:56pm
   
hi Maciej,
I had posted some sample data,
Can you help me out...
Sushil Mate at 12-Jul-13 1:45am
   
you need to group by emp name then you will get your desired result.
yeahgrp at 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 at 12-Jul-13 4:32am
   
check my solution.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Have a look here: dynamic columns in Crystal report at runtime [^]. There you'll find 2 links. Wink | ;)
  Permalink  
Comments
yeahgrp at 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... :)
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Comments
yeahgrp at 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
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Have a look, it will solve your problem.
 
C# crystal reports string parameter.[^]
 
Custom Field in Crystal Report[^]
  Permalink  
Comments
yeahgrp at 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)

  Print Answers RSS
0 OriginalGriff 5,130
1 DamithSL 4,237
2 Maciej Los 3,700
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,846


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 12 Jul 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100