preethamonline
asked on
Transpose data on a dataviewgrid
Hello Guys. I'm in the process of display the employee attendence on a datagrid and later export it to excel. I can do it without any problems. But now i would like to transpose the dates field on the database to make it appear like a column rather than a row. Any suggestions on how to accomplish this would be highly appreciated. Thanks in advance
Attached are the database structure and desired layout.
layout.JPG
attendence.JPG
Attached are the database structure and desired layout.
layout.JPG
attendence.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I guess we can achieve this by using the datalist control right. can anyone provide me with a small example.
ASKER