Daily attendance Report builder

Yahoo Archive
1
>>Try changing your filter: "(LaborHed.ClockInDate = 09/27/00 OR
LaborHed.ClockInDate = ?)".<<

Thanks for the tip Steve. I'm working on the same report and this works like
a charm. I used conditional printing to NOT print the record lines when the
laborhed.payhrs is zero, empty or unknown. I can't use the calculated field
like Martin suggested because the users running this report don't have
access to Report Builder to change the date.

Tom Taylor
I.S. Administrator
Teklution, LLC.
www.teklution.com
2
I am trying to write a report showing daily attendance in report builder. I
want to include employees who are absent. I joined laborhead to empbasic
using a left join. The left join is being cancelled out by my filter
laborhead clockindate > 09/27/00. Absent active employees are being
excluded. I sure the solution is obvious. Unfortunately the coffee has not
kicked in yet. Any help would be appreciated.

Thanks
Dan Shallbetter
States Electric Mfg.
3
Dan,
Try changing your filter: "(LaborHed.ClockInDate = 09/27/00 OR
LaborHed.ClockInDate = ?)".
The join will cause EmpBasic records without a matching LaborHed record to
report the ClockInDate as ?, which fails your first filter (ClockInDate >
9/27/00).
================
Steve Sanders
Delta Centrifugal Corp.
-----Original Message-----
From: Dan Shallbetter [mailto:dans@...]
Sent: Wednesday, October 04, 2000 8:52 AM
To: 'vantage@egroups.com'
Subject: [Vantage] daily attendance Report builder


I am trying to write a report showing daily attendance in report builder.
I
want to include employees who are absent. I joined laborhead to empbasic
using a left join. The left join is being cancelled out by my filter
laborhead clockindate > 09/27/00. Absent active employees are being
excluded. I sure the solution is obvious. Unfortunately the coffee has not
kicked in yet. Any help would be appreciated.

Thanks
Dan Shallbetter
States Electric Mfg.




We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)



[Non-text portions of this message have been removed]
4
I created the same report but instead of a filter I used a conditional
printing on the record Band line.

1) Create a calculated field that give a blank result if the clock in date
is not the one you want.
2) In the properties of the record Band line, tick conditional printing. It
will only print the band line if the calculated field is not blank.

However this does increase the printing time significantly. If you have any
problems let me know I can send you my report.

Martin Nijdam (Jr. Ing.)
Suss Woodcraft Int'l
(514) 363-3565

> -----Original Message-----
> From: Dan Shallbetter [SMTP:dans@...]
> Sent: Wednesday, October 04, 2000 9:52 AM
> To: 'vantage@egroups.com'
> Subject: [Vantage] daily attendance Report builder
>
> I am trying to write a report showing daily attendance in report builder.
> I
> want to include employees who are absent. I joined laborhead to empbasic
> using a left join. The left join is being cancelled out by my filter
> laborhead clockindate > 09/27/00. Absent active employees are being
> excluded. I sure the solution is obvious. Unfortunately the coffee has not
> kicked in yet. Any help would be appreciated.
>
> Thanks
> Dan Shallbetter
> States Electric Mfg.
>
>
>
>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
> to www.egroups.com, login and be sure to save your password, choose My
> Groups, choose Vantage, then choose Files. If you save the password, the
> link above will work the next time you try it.)
5
Hi Martin,

Can you upload your report to egroups or send me a copy personally?
Thanks,
Daniel A. Clifton
Northwest Swiss-Matic