Time Formating

[ankit]

I have a field from the database that is an integer which is basically number of seconds.
but i want to display it as HH:MM:SS, Is there a way to do that using expression in the reports or it has to be done in code behind.

[Peter]

Hello ankit,

You can use an User Functions to convert the integer (seconds) into DateTime or correctly formatted string. For example check out the following code snippet:

public static DateTime ConvertToDateTime(int seconds)
{
    //TO DO convert seconds to DateTime
    return dateTime;
}

Greetings,
Peter
the Telerik team

[Colleen]

How do you do this functionality in Telerik's stand-alone Report Designer?  Thank you

[Silviya]

Hello Colleen,

To use custom functions inside the Standalone Designer it needs to be extended - check Extending Report Designer help article for reference. The designer's folder is placed in default Telerik Reporting installation folder, e.g. C:\Program Files (x86)\Progress\Telerik Reporting <VERSION>\Report Designer. 

Best Regards,
Silviya
Progress Telerik