Hi Everyone,
If possible how would you given a numeric column in a database table that represents time in minutes:
-define an object in designer in the format hh:mm:ss while
-satisfying the condition permitting a sum aggregate on this object at a report level?
I can do a concatenation to get the format hh:mm:ss, however this is not of type time and can not be summed. Is there an alternative?
While this may not sound quite feasible as first glance, I do not want to be limited by my own preconceptions.
Thanks for any feedback.
Ken
Edited by: Banseka Kenneth on Mar 2, 2009 5:25 PM