CrossTab
Hi,
I'm using Delphi XE and FastReport 4.11.4. I'm also a newbie at FastReport and need a lot of help.
I'm trying to create a monthly timesheet for each employee and each timesheet should fit on one page. The report would have three sections. The first would show the total leave hours taken/used and total hours worked for the month. The second would show individual day and the type of leave taken or hours worked. The third would show the types of leave available. The following is an example:
Monthly Attendance Report
Employee Name
For Reporting Dates: 07/01/2011 - 07/31/2011
Leave Summary
Annual Leave: 6 Hours Sick Leave: 2 Hours
07/01/2011
AL 6.00
SL 2.00
07/04/2011
HOLI 8.00
07/05/2011
WK 8.00
.......
AL - Annual Leave SL - Sick Leave
WK - Worked HOLI - Holiday
Sincerely,
Tan Hartley
I'm using Delphi XE and FastReport 4.11.4. I'm also a newbie at FastReport and need a lot of help.
I'm trying to create a monthly timesheet for each employee and each timesheet should fit on one page. The report would have three sections. The first would show the total leave hours taken/used and total hours worked for the month. The second would show individual day and the type of leave taken or hours worked. The third would show the types of leave available. The following is an example:
Monthly Attendance Report
Employee Name
For Reporting Dates: 07/01/2011 - 07/31/2011
Leave Summary
Annual Leave: 6 Hours Sick Leave: 2 Hours
07/01/2011
AL 6.00
SL 2.00
07/04/2011
HOLI 8.00
07/05/2011
WK 8.00
.......
AL - Annual Leave SL - Sick Leave
WK - Worked HOLI - Holiday
Sincerely,
Tan Hartley
Comments
I did try to use three data bands that has the detail band with three columns since all information should fit on one page. The detail band has a group-by band on transaction date so that the result will look like the following:
07/01/2011 07/04/2011 07/05/2011
AL 6 HOL 8 WK 8
SL 2
07/06/2011
WK 8
........
instead of the following:
07/01/2011 07/04/2011 07/05/2011
AL 6 HOL 8 WK 8
SL 2
07/06/2011 07/07/2011
WK 8 WK 8
.........
Thank you,
th
I don't know how to attach a demo project since my report is within a big project that use Oracle database. However, I can attach the two reports showing what it should look like and what it looks like when I am using three bands with the detail band having three columns.