Calculating Hours Work in A Week 1

[svm]

Hi.

I am new to this software and right now I'm running into problem of generating a formula on how to calculate the hours work per week. The system was designed to have two file one CADTIME is the file containing the employee, Date and hours work. the other file CALREF contains the From Date and To Date. We connect or link to calref file to get the from and to date and from here compare if greater or less than the two dates to add the hours. Please give me advise on how to proceed. Thanks.

 

[kenhamady]

First, are you getting the correct records? I am puzzled by the link, but if you are getting the link to work correctly and return the correct dates for each person, you are almost done.

Now place the hours on the detail band and select Insert - Subtotal. Set it to group by person and you will get a subtotal for each person. You can also select Insert - Grand Total Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[svm]

Hi Ken,

I am displaying the records but I cannot total by week to display the total hours worked by week.

 

[kenhamady]

Insert a group, based on the date in CADTIME. There should be a setting where you can tell it to group by Week, Month, Quarter, Year, etc.

If you don't see this on the group settings window, confirm that the date field is truly a date data type. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[svm]

Hi Ken,

Thanks for the help. I appreciate it.