Crystal reports: using summary field in formula / summing time field in formula

crystal-reports sum crystal-reports-xi
jorrebor picture jorrebor · Oct 12, 2011 · Viewed 12k times · Source

In crystal reports I want to show the sum value of time objects, i.e. An employee worked in one month three days and on each day a variable amount of hours.

Is there anyway to sum a time field?

Or as a workaround I could use the time field as an integer, sum this and display. But then I would like to change the display format by using a formula. I cant find a way to include summary fields in a formula...

Thanks in advance

PS I am using CR 2011 (just the program not through VB or anything).

Answer

Ryan picture Ryan · Oct 12, 2011

You cannot sum a date/time field. You will have to use datediff("n",{datetime1},{datetime2}) to get a time interval between two date/time fields in minutes.

To use a summary function in a formula, you can use this sum({@YourMinutesFormula},{FieldYouAreGroupingOn})

You may omit the second parameter if you want the summation over the entire report instead of a grouping level. Check the Crystal Reports help file for more details on Sum().

Related questions

SAP Crystal Reports runtime for .Net 4.0 (64-bit)

I need a runtime for SAP Crystal Reports for .Net 4.0 (64-bit). I have been searching from the web but not getting any success. Can I get the URL from where can i download this

Read More
How to convert datetime format to date format in crystal report using C#?

i am working c# windows form application and also in crystal report.i am retriving the date from database in datetime format but i like display date only in report,Is any formula field in crystal report help for me …

Read More
Edit Crystal report file without Crystal Report software

I need to modify a static text (few words) in 3 rpt files. But I dont have Crystal Reports. How can I do it? Is there a free editor or software to be able to modify a simple text of the …

Read More