Just figured it out on my own. In the formula, I just need to replace the {field} value with currentfieldvalue.
//WhilePrintingRecords;
//NumberVar TotalSec := CURRENTFIELDVALUE;
//
//NumberVar Hours := Truncate (Remainder ( TotalSec , 86400) / 3600) ;
//NumberVar Minutes := Truncate...
Hoping you all can help again.
I have a crosstab on a report footer of my report. It displays users by row, date by column and calculates the average time by seconds. I'm looking for it to display the average time by seconds as a hh:mm:ss format.
Example of how it displays now...
Thanks for replying, Charliy.
I'll see if I can explain my issue more clearly if I can display it.
Currently, I'm pulling data and grouping it by week (Sunday-Saturday). The group header is displaying the first day of the week (Sunday), like below
Item Count
09/01/2013...
Hoping someone can help me out.
I'm running a report that is grouping data weekly. Crystal Reports always displays dates by the beginning of the week (Sunday). I'd need it to display the end of the week (Saturday) without modifying the grouping of data for that week. By that I mean, the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.