troubleshooting Question

get formula value for each group in the report -- HELP

Avatar of Tech_Men
Tech_MenFlag for Israel asked on
Crystal Reports
2 Comments1 Solution311 ViewsLast Modified:
hi all,

i have a time calculation formula
the problem is that i get a grand total for all the report
i need this formula will run for each group separately
i have this formula  :
@100%hrs
Truncate ({Msam.TotalHour})
@100%Min
 {Msam.TotalHour}- Truncate ({Msam.TotalHour})
@TotalTime
CStr (Sum ({@@ 100%hrs}) + (Sum ({@@100%mins}) * 100 \ 60), "###") + ":" +
 CStr (Remainder (Sum ({@@100%mins}) * 100, 60), "00")

the @TotalTime are placed in the group Footer of the report but the value are for all the reports in all groups how can i fix that the @TotalTime will run each group  separately ??
thanks
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros