Last post Nov 13, 2013 06:13 AM by Ajay2707
Nov 12, 2013 02:55 AM|kavita.05kp|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
I want report ,exectly same like above, Pleas help........
Nov 12, 2013 11:51 PM|Ajay2707|LINK
http://www.codeproject.com/Articles/142064/Step-by-Step-Creation-of-Crystal-Report-using-its (search cross tab)
Nov 13, 2013 01:58 AM|kavita.05kp|LINK
Thanks for reply, i have created report according to above, but i have face one problem, when i run my solution, report get generated but no records are displayed. i have chk my dataset object, list object, proper data come in to these objects but still
i am not able to see these records in report. I got blank report.
But same thing m created with Standard Expert i am able to see proper output. This problem occurs only for
Cross Tab Expert
Nov 13, 2013 06:13 AM|Ajay2707|LINK
To understand data comes while creating cross tab, You just think the bunch of data you have and then set manually in mind if you set, how the data will set as you visulalize understand.
The data is show with linked data in cross-tab, as grouping.
The data is not show means the link between horizontal column and vertical column 's data is not in dataset. please check the data.
you definately understand the means.