如何在水晶报表的组页脚中获取组记录的持续时间总和? [英] How to get sum of time duration of group records in group footer in crystal reports?

问题描述

我正在设计带有持续时间的列的水晶报表.

我有Empcode，名称，持续时间，备注等列.

我正在根据empcode对报告进行分组.

我想在页脚中显示持续时间的总和.

我有两个公式...

I am designing crystal report with a column having time duration.

I have column like Empcode, name, duration, remarks, etc.

I am grouping report according to empcode.

I want to display sum of duration in group footer.

I have two formulae for that...

 @get_seconds :
   local stringvar array completetime;
    local numbervar totalseconds;
    completetime:=split({DailyAttendance.TotalDuration},":");
    totalseconds:= (3600*cdbl(completetime[1])) + (60*cdbl(completetime[2]));

@total_duration :
   replace(cstr(Sum ({@get_seconds})\3600),".00","") 
   + ":" +  replace(cstr((Sum ({@get_seconds}) mod 3600)/60),".00","")

我在组页脚中显示@total_duration，但是我正在获取报表中所有记录的总和，而不是仅组中记录的总和.有人可以告诉我如何实现吗?

谢谢..

I am displaying @total_duration in group footer, but i am getting sum of all records in report, not sum of records in group only. Can someone tell me how to achieve this??

Thanks..

推荐答案

得到了我的解决方案，
我只是将公式更新为:

@total_duration:
replace(cstr( Sum({@ get_seconds}，{DailyAttendance.EmpCode}) \ 3600)，.00"，")
+小时" + replace(cstr(( 总和({@get_seconds}，{DailyAttendance.EmpCode}) mod 3600)/60)，.00"，")+"分钟"

谢谢.

Got my solution,
I just Updated my formula as:

@total_duration :
replace(cstr(Sum({@get_seconds}, {DailyAttendance.EmpCode})\3600),".00","")
+ " Hrs " + replace(cstr((Sum ({@get_seconds}, {DailyAttendance.EmpCode}) mod 3600)/60),".00","") + " Mins"

Thanks..

这篇关于如何在水晶报表的组页脚中获取组记录的持续时间总和?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！