I have a requirement for finding out the average effieciency of a fork lift based on the operating hours and number of cylinders used. Due to some project technical constraints, i cannot use the standard fleet management functionality to capture this report.
I am using a counter to capture the operated hours which will be divided directly by 19.6 kg (capacityof cylinder). This is simple to develop.
One more report to calculate average effciency of the forklift from a given date range has to be developed. I am not sure which table i can get the data from. In the selection screen, when i pass the date range the program should pick up the number of measurement documents updated for the given measuring point. How can i do this? Is there any table from where i can run the select query?
Thanks in advace,