Page 1 of 1

Calculating Sum

Posted: Mon May 28, 2012 12:14 pm
by tims
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

Posted: Tue May 29, 2012 10:23 am
by HighAley
Hello.

We need more time to prepare an answer for you.

Thank you.

Calculating Sum

Posted: Wed May 30, 2012 5:25 am
by Alex K.
Hello,

Please see the modified report in attachment.

Thank you.