Recording employee absense

[Phil00001]

Hello,
I'm very new to Crystal Reports - I've managed to set up an employee time sheet, which will be printed off weekly (reporting clocking's for previous 7 day's)

I'm struggling with trying to incorporate employee absense. If an employee is absent from work on a Wednesday, my report skips that day for that employee, just reporting on day's clocked

How can I include non clocked day's

I would appreciate any advice/guidance - thank you

Phil - Using Crystal Reports 2008 with SQL and Windows XP

 

[IdoMillet]

Add a Calendar table with one row for each date in the next N years. Do an outer from that table to the Clocked table.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Phil00001]

Sorry that's gone right over my head, please simplify if possible, appreciate you trying to help a novice

 

[IdoMillet]

Reporting tools are not good at providing information that is not in the database.
After adding a simple table that has a row for each date, you can use that table to ensure the report provides a row for each and every date.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com