Count Or Running Totals Really Not Sure !

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

SteveSo you only want one row per rod number? Are you grouping on that and printing in the group footer?|||No, i am not grouping it is just in details, i tried to group but then it screwed my totals for coil wieght. instead of doing 8 Ton per day we ended up with 40 Ton (mmm That looked good but was way out)

Regards

Steve|||Hi, Thanks for your reply i realised that i was not surpressing the details of the report causing me to get some strange results

Regards

Steve

COUNT Expression Values

Hello,

I am trying to create totals of the different values of a certain expression in the Report Footer. Currently I have the expression in a group which gives me a running subtotal of the 4 different values of the expression. Now I need 4 running Totals of the 4 different value subtotals. I tried placing some code in the Report Properties but I had a hard time trying to code visual basic within the editor.

Any info is helpful.

I answered my own question. I didn't need any coding. It was basically creating new fields and applying the calculations to the new created fields.

COUNT Expression Values

Hello,

I am trying to create totals of the different values of a certain expression in the Report Footer. Currently I have the expression in a group which gives me a running subtotal of the 4 different values of the expression. Now I need 4 running Totals of the 4 different value subtotals. I tried placing some code in the Report Properties but I had a hard time trying to code visual basic within the editor.

Any info is helpful.

I answered my own question. I didn't need any coding. It was basically creating new fields and applying the calculations to the new created fields.sql