Axis label formatting for the Bar chart

[Zakk]

Hello!

I have one problem with creating custom formatting for axis label of the bar chart.

I have time in Seconds (int) as Data Source for X Axis but I need to display this in format HH:MM  (and HH can be more than 24).

 

My project with build-in csv data: https://dropmefiles.com/pWr9e

I will appreciate any help! Thanks! 

 

[Silviya]

Hello Eugene,

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

public static string ConvertToFormat(int seconds)
{
    TimeSpan t = TimeSpan.FromSeconds(seconds);
    return string.Format("{0:D2}:{1:D2}:{2:D2}",
        (int)t.TotalHours,
        t.Minutes,
        t.Seconds);

}

You could refer to What is the best way to convert seconds into (Hour:Minutes:Seconds:Milliseconds) time? and/or How to convert seconds to HH:MM:ss format public threads.

Regards,
Silviya
Progress Telerik

[Zakk]

Hello Silviya!

Thanks for reply!

Can I use\create an user functions in reports created by "Telerik Report Designer (.trdp)" ? 

[Silviya]

Hi Zakk,

Basically, there is no difference when using custom user functions in Type (.CS) and Declarative (.TRDP) reports. 
The custom function could be any public static method that resides in a loaded assembly can be invoked from an expression by its fully qualified name, including the full namespace and the name of the type it belongs to, and specifying the necessary parameters in the braces - check User Functions article.

In order the custom function to be accessible in Standalone Designer, it would be necessary to register the corresponding assembly in the designer's config file, as explained in the Extending Report Designer article. The custom functions appear under Functions->Misc section.

Regards,
Silviya
Progress Telerik