need a expression to convert seconds into hh:mm:ss to use in a texbo开发者_开发问答x of a local report (ASP.NET with Report Viewer)
This works even if hour part is >24hrs.
=right("0" & int(sum(Fields!Total_Login_Seconds.Value)/3600),2) & ":"
& right("0" & int((sum(Fields!Total_Login_Seconds.Value) Mod 3600)/60),2) & ":"
& right("0" & (sum(Fields!Total_Login_Seconds.Value) Mod 3600) Mod 60,2)
you can write a vb syntax code to make calculations within the report, choose report textbox value property and write your vb code there
精彩评论