I just uploaded a Report Builder report written a while ago. The
calculated field "TheDate" is set to today() - 1, so employees not
present yesterday should show. Set to today() - 2, today() - 3, to
compensate for weekend.
Although not too many calculations, designing it was not obvious.
Good luck,
Lonnie
calculated field "TheDate" is set to today() - 1, so employees not
present yesterday should show. Set to today() - 2, today() - 3, to
compensate for weekend.
Although not too many calculations, designing it was not obvious.
Good luck,
Lonnie
--- In vantage@yahoogroups.com, Jim Selinger <jim@k...> wrote:
> I am trying to write an absentee report. My thought was to use pay
hours
> and filter by less than zero, by date. This has failed miserably.
Any
> ideas. Please help.
>
> The master table I am using is LaborHead.
>
> Regards,
>
> Jim Selinger
> Kocsis Bros. Machine Co.
> 11755 S. Austin Avenue / 4321 Railroad Avenue
> Alsip, IL 60803 / East Chicago, IN 46312
>
> Phone: (708) 597-8110
> Fax: (708) 389-0792