Will not Summarize...Help!!! Ken Hamady 1

[Moonmouth]

Here's the problem...

Here's the formula

if {nnm_event_detail.trap_name} = "OV_Node_UP" and Previous ({nnm_event_detail.trap_name}) = "OV_Node_Down" then
{nnm_event_detail.event_timestamp} - Previous({nnm_event_detail.event_timestamp})

this formula is ment to calculate the difference in time when a Server goes down and back up. The formula works, it does the correct calculations, but the problem is that I can summurize this formula field( so I can get the total time for each server).

I tested a simple formula... sum(@TimeDiff) ..and the error msgs is: the summary / total running field could not be created.

The funny thing is when use the chart expert I can use the formula and I can have it summurized...the results shows up in a graph...and the results are correct.

Both fields that I am using are Number format and I also tried it with the EvaluateAfter () function....same results...

I am using Crystal Reports 8.5
Ken if you're out there...help...(or anybody else) :->

thanks

 

[paulmarr]

Moonmouth,

Your problem seems to be occuring because of the Crystal Reports 3 Pass System. Most reports have 3 passes - and during each pass, different parts of the report are calculated and created. Grand totals and summaries are calculated during the first pass, but group selection filters the data again in pass #2. If your summary fields are in a group selection report - you'll have to use a running total instead.

The graph works because it is calculated after group selection and running totals.

Another possibility would be to add WhilePrintingRecords to your formula.

I hope this helps.

Cheers,

paulmarr@arcom.com.au