Calculate a report for days off

[alley211]

I have version 8.5 of crystal.

I need to do the following:

I need to calculate when someone has time off.

For example:

Someone worked 2/1 for the time frame of 2/1-2/14.

I need one column that shows they did not work 2/2-2/7 and
I need to show it like this:

Sa, Su, M, Tu, W, Th

And another column for 2/8-2/14 showing:

F,Sa,Su,M,Tu,W,Th

I can put on the report the days that they work but I'm having trouble figuring out when they didn't.

I've created some variables but they aren't behaving.

Any thoughts or ideas would be greatly appreciated.

alley

 

[chelseatech]

I used a similar appraach with a string variable to create a call line (list all the duties a person has over a period of time).

Build a string of 1 char for each day.
stringvar days:= "xxxxxxxxxxxxxxx"
then change the "x" to " " or a duty code for the day's that have data. (A bit of maths needed here).

Then another formula in the Employee/Group footer to examine the string var and build up a string for the day of the week for the day still with an "x"

A bit of work, but possible. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm