CrossTab

Tan Hartley

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

gpi

I think you should use report with three data bands instead of crosstab

Tan Hartley

gpi wrote: »

I think you should use report with three data bands instead of crosstab

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

gpi

Attach demo project

Tan Hartley

gpi wrote: »

I think you should use report with three data bands instead of crosstab

Tan Hartley

gpi wrote: »

Attach demo project

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.