Count Time
Hello,
I'm working with D7 and RB9.02. Is there a simple possibility to sum time
value for some reasen without using the SUM field in RB?
In a report I show a field with tme value in it. When the time doesn't
exceed the 24 hours it is working fine with a SUM field in RB. But when the
total value is more then 24 hours, logically it is starting from zero.
What I want to know is there a simple solution to solve this problem. I
dislike to solve it within D7.
Regards Ronald
I'm working with D7 and RB9.02. Is there a simple possibility to sum time
value for some reasen without using the SUM field in RB?
In a report I show a field with tme value in it. When the time doesn't
exceed the 24 hours it is working fine with a SUM field in RB. But when the
total value is more then 24 hours, logically it is starting from zero.
What I want to know is there a simple solution to solve this problem. I
dislike to solve it within D7.
Regards Ronald
This discussion has been closed.
Comments
What is the datatype of your time field? Instead of using a DBCalc to
calculate the sum of your time field, try using two TppVariables. The
TppVariable component gives you access to the OnCalc event in which all
calculations are made for a specific field. I would suggest placing one
variable in your detail band and one in the band you would like to see the
sum. Then in the OnCalc event of the first variable, increase the value of
the second variable by the amount of the field value (making the proper
checks to keep it within the time boundaries). The TppVariable contains a
"Time" datatype so the time checks should not be necessary.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com