I got it. It was telling me exactly what was wrong, but I guess I'm kind of dense.
I revised the avgmpg statement to read as follows:
numbervar avgmpg;
numbervar milesum;
numbervar fueltot;
whileprintingrecords;
if fueltot > 0 then
(
avgmpg := milesum/fueltot
)
else
(
avgmpg := 0
)
We have...
No. I have the accumulator in the details. The error kicks back to the avgmpg formula. It is the only one that won't work with the details hidden. I placed it in the vehicle # group footer. I even recreated the entire report from scratch to make sure that there wasn't something left over from my...
I'm glad my wife doesn't like those shows, but I admire your methods to get out of watching.
I can't thank you enough for what you've done so far. I'm going to tell everyone I couldn't have done it without CoSpringsGuy, but most likely I'll get all the glory.
Anyway, everything works except...
So one more caveat. Any ideas how to total this new "difference" column? I've read and tested some 3 part variables with no luck. I don't know if it is because of the suppression techniques involved or not. I really just need to find the differences between the odometer readings, total them, and...
CoSpringsGuy,
Thank you! That works well. I do have the vehicles grouped, but I tested it out and it works fine for all of them. I knew there had to be some way of having it pull most all of the data, but not displaying all of the data, I just couldn't put my finger on it until you mentioned...
I'm trying to figure out a formula that will assist with a fleet gas report. The report displays data as follows:
Vehicle #|Date of Fillup|Amt of Fuel|Odometer at fillup|Difference|MPG
1 |12/31/12| 10.00 | 30,000 | __ | 50
1 | 1/1/13 |...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.