Crystal Reports 2008 - WhilePrintingRecords DateDiff for all rows - need average

[hmax]

I have the results for each row, based on the following:

whileprintingrecords;
numberVar dur := datediff("s",{Command.CREATION_DATE}, {Command.CLOSED_DTTM}); //get the seconds between 2 dates

Now I need the average of all results for all rows.

Thanks!

hmax

 

[briangriffin]

Modify your formula slightly:

whileprintingrecords;
numberVar dur := dur + datediff("s",{Command.CREATION_DATE}, {Command.CLOSED_DTTM}); //get the seconds between 2 dates
numbervar counter := counter + 1;

Add an additional formula in the report footer:

whileprintingrecords;
numbervar dur;
numbervar counter;
dur/counter


You'll probably need to add this formula to the report header:

whileprintingrecords;
numbervar dur := 0;
numbervar counter := 0;

 

[pmax9999]

Hi hmax

Unless I am missing something I can see no reason why you would need to use variables at all. The detail formula could just be:

datediff("s",{Command.CREATION_DATE}, {Command.CLOSED_DTTM}

(or better still, move the calculation to the Command and have the database server do the calculation for you), and then you could just use the normal Average summary to provide that calculation in the footer.

 

[hmax]

Great suggestions, briangriffin and pmax9999. Thank you both!