开发者

RDLC Expression to convert seconds in hh:mm:ss

开发者 https://www.devze.com 2022-12-11 18:19 出处:网络
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.

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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号