FireGeek21
Technical User
Is DateDiff considered an aggregrate function where you can't sum the DateDiff field? Trying to find a way to sum a number of datediff's per person (some may have one set of dates and others may have more). Need a grand total of days.
Ex:
Start Stop Days
Person 1 01/01/2010 01/15/2010 15
02/01/2010 02/20/2010 20
Person 2 01/01/2010 01/07/2010 7
Person 3 01/01/2010 01/05/2010 5
02/01/2010 02/28/2010 28
03/01/2010 03/03/2010 3
03/10/2010 366 (assume to current date)
On Person 1 looking for 35 in the footer, Person 2 should have 7 and Person 3 should have 402.
Thoughts?
FireGeek
(currently using Crystal Reports XI with Lawson 8.03)
Ex:
Start Stop Days
Person 1 01/01/2010 01/15/2010 15
02/01/2010 02/20/2010 20
Person 2 01/01/2010 01/07/2010 7
Person 3 01/01/2010 01/05/2010 5
02/01/2010 02/28/2010 28
03/01/2010 03/03/2010 3
03/10/2010 366 (assume to current date)
On Person 1 looking for 35 in the footer, Person 2 should have 7 and Person 3 should have 402.
Thoughts?
FireGeek
(currently using Crystal Reports XI with Lawson 8.03)