Skip to Content
0
Feb 25, 2009 at 02:47 AM

Convert a numeric value into hh:mm:ss in object definition to allow sum

34 Views

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