locked
Cross Tab Crystal Report. RRS feed

  • Question

  • User-1887468396 posted

    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:

    EmpID

    Name

    InTime

    OutTime

    Date

    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........

    Tuesday, November 12, 2013 2:55 AM

Answers

All replies

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, November 12, 2013 11:51 PM
  • User-1887468396 posted

    Hi Ajay,

    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


    Please help

    Wednesday, November 13, 2013 1:58 AM
  • User-578610739 posted

    Hi Kavita,

    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.

    Wednesday, November 13, 2013 6:13 AM