Page 1 of 1
Storing values with in a report
Posted: Sat Sep 01, 2007 10:12 am
by Shaughn_(Guest)
I have a question, can you store a value in a report. Here is my problem,____I have a fuel use/balance report that shows the fuel purchased/used and then the meter reading when the user takes a reading. I need to subtract the first reading in the report with others to get the number of gallons dispensed.____If I could store the first reading, then when it sees the second somewhere in the report subtract from that value then I could have that total. I have drawn a blank. I just cannot figure it out.____Any suggestions?
=> RE: Storing values with in a report
Posted: Tue Sep 04, 2007 9:13 am
by kfleming
Do you need the first reading for each meter in the report? If so, is the report sorted by meter?____Kathleen__R&R Support
==> RE: Storing values with in a report
Posted: Tue Sep 04, 2007 9:25 pm
by Shaughn_(Guest)
The report is sorted by date, and not all records will contain a meter reading, they read the meter about once a week, and enter fuel use and purchase every day. ____What I did do was use the low amount and the high amount and subtracted those two numbers at the end of the report, this did give me the total between the lowest meter and the highest meter. So my problem was somewhat solved. But is there a way to store a selected value to be used later in a report?____Thanks for all of your help.____Sg__
===> RE: Storing values with in a report
Posted: Wed Sep 05, 2007 9:35 am
by kfleming
You would have to export from the first report and then use the exported data in a subsequent report.____Kathleen__R&R Support
====> RE: Storing values with in a report
Posted: Wed Sep 05, 2007 9:52 am
by Chris_(Guest)
What about storing the value initially as a ParameteRR and building that into the calculation? You^d have to do some recordkeeping between reports or when the report was done to put the more current value into the parameteRR.
=====> RE: Storing values with in a report
Posted: Thu Sep 13, 2007 8:00 pm
by Shaughn_(Guest)
Thanks, I will look in to the rrparameter.____Shaughn__