Last post Aug 03, 2013 04:06 AM by Ajay2707
Aug 03, 2013 03:17 AM|krishnandu.sarkar|LINK
Hello, I'd like to show Monthly Attendance Report Employee Wise in Cross Tab Crystal Report.
I do not have much idea about forming the query for it and the Cross Tab Report.
My Database Have Fields like:
So I can have data like
1 ABC 10:00AM 6:30PM 1-Aug-2013
2 XXX 10:00AM 6:30PM 1-Aug-2013
3 YYY 10:00AM 6:30PM 1-Aug-2013
1 ABC 10:00AM 6:30PM 2-Aug-2013
2 XXX 10:00AM 6:30PM 2-Aug-2013
3 YYY 10:00AM 6:30PM 2-Aug-2013
1 ABC 10:00AM 6:30PM 3-Aug-2013
2 XXX 10:00AM 6:30PM 3-Aug-2013
3 YYY 10:00AM 6:30PM 3-Aug-2013
So I can have the data for whole month this way, and I'd like to display it in...
EmpName/Date 1-Aug-2013 2-Aug-2013 3-Aug-2013
IN | OUT IN | OUT IN | OUT
ABC 10:00AM 6:30PM 10:00AM 6:30PM 10:00AM 6:30PM
XXX 10:00AM 6:30PM 10:00AM 6:30PM 10:00AM 6:30PM
YYYY 10:00AM 6:30PM 10:00AM 6:30PM 10:00AM 6:30PM
Can anyone please help me regarding this?
Or you may suggest something else if you think something else will be better.
I'm aware of PIVOT Table Query but not much of idea how to form it.
Aug 03, 2013 04:06 AM|Ajay2707|LINK
please check link,
http://www.codeproject.com/Articles/142064/Step-by-Step-Creation-of-Crystal-Report-using-its search "Cross-tab" keyword. where explain how to create