I've created the attached report which calculates the amount of paid time for an employee. The records in the Management database will include various records throughout the day. The Group selects the earliest start time and latest end time and rounds them to the appropriate quarter hour. Then depending on the amount of total time between those values, a lunch break time may be deducted. The difference is the amount of Paid Time.
I have all those formulas working in the group headers, but I don't know how to total for the report footer. If I use the same formula, I get errors. Since it's a group, I can't use calculated columns.
Is there a way to set the value of a variable from the value of a text box. For example, I tried to make the AfterPrint action to PaidTime=Text27.
I don't have extensive coding knowledge, so trying to do this in the report interface.
http://dl.dropbox.com/u/2491635/TimeLog%20Report.zip
Thanks,
Tim S.
Calculating Sum
Calculating Sum
Hello.
We need more time to prepare an answer for you.
Thank you.
We need more time to prepare an answer for you.
Thank you.
Calculating Sum
Hello,
Please see the modified report in attachment.
Thank you.
Please see the modified report in attachment.
Thank you.
- Attachments
-
- 1887.Generic Payroll Time Log - Weekly1.mrt
- (29 KiB) Downloaded 189 times