Ok, I have this data:
CompanyName ContractNumber Territory Part_Number AlertQuantity MAS90Quantity
---------------------- -------------- ---------- ----------- ------------- -------------
EXXONMOBIL RESEARCH 100309 PAS 28655A 2 3
SOURIAU USA, INC. 100396 PAS 28655A 1 3
PEARSON VUE 100519 PAS 28655A 1 3
PEARSON VUE 100519 PAS 28655A 1 3
PEARSON VUE 100519 PAS 28655A 2 3
NASSCO 100029 SVC 28655A 1 1
NASSCO 100029 SVC 28655A 1 1
NASSCO 100029 SVC 28655A 1 1
NASSCO 100029 SVC 28655A 1 1
I have grouped the report by Territory, Part_Number, and ContractNumber. I created a running total field on Part_Number and had it reset on the change of the Part_Number group.
When the report runs, I get:
CompanyName ContractNumber Territory Part_Number AlertQuantity MAS90Quantity
---------------------- -------------- ---------- ----------- ------------- -------------
EXXONMOBIL RESEARCH 100309 PAS 28655A 2 3
SOURIAU USA, INC. 100396 PAS 28655A 1 3
PEARSON VUE 100519 PAS 28655A 1 3
PEARSON VUE 100519 PAS 28655A 1 3
PEARSON VUE 100519 PAS 28655A 2 3
5
You can see that there are a total of 7 for territory PAS, yet the running total is coming up with 5. I have no clue how to 'debug' this. The data's correct, and the running total field is very simple.
Some direction would be nice.
Thanks
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
