Hi, Still working on this **** report, its getting to be beyond a joke now. Its format just changed again (you all know the score).

The first problem i want to deal with is to get a count of the short stops we are having.

I have set up a running total that is like so

Field to summarize = tblDowntime.DTCLevel3
Type of Summary = Count

Evaluate

Formula = {tblDowntime.Duration} < 900 (this in seconds so Less than 15 Mins)

Reset

Change of field = tblCoilData.BatchName (this is the works order Number)

Before I put this in i get the correct values except no short stops data so:

Rod Number, Rod Weight, Scrap, EC Stops, Coil Weight

This gives me normally 4 results as follows

544124, 1,9882, 0.00, ,19882
544125, 1,9452, 44, , , 19408
544126, 1,9452, 44, , , 19408
544127, 1,9452, 44, , , 19408

When i put the running total into my report i get

544124, 1,9882, 0.00, 1,19882
544124, 1,9882, 0.00, 2,19882
544124, 1,9882, 0.00, 2,19882
544125, 1,9452, 44, 0, 19408
544126, 1,9452, 44, 0 , 19408
544127, 1,9452, 44, 0 , 19408

I cant understand why it would do this. i know that on Rod Number 544124 there were 2 short stops, i only want to show it like the top version with a total of the short stops

How is this done

Regards

Steve