Guys thanks a lot for our replies, maybe I hadn't explain my inquiry in details, I will explain as follows:
Currently in Reporting 3.0 / TR1001 Trip&Idle Daily Report, the Start Time and End Time show the first point of the day and the last point of the day (that the server has received from the vehicle). But as per our customers requests, we want to modify the report so that Start Time shows the First Ign=ON and the End Time shows the Last Ign=Off of the day.
Considerations: Our trackers send Ignition signals and mapped in the device mappers. So Ign is a signal that exist in gate messages. / secondly: we have set the trackers to send updates at every 5 minutes during 24 hours, even while their Ign is off and they are stopped. This is customer's request and we can not touch this policy.
So the only way is to make a new Data Provider similar to Distance01 and replace the Distance01.SamplingStart and SamplingEnd with Ign related fields but I couldn't make it.
Please note that I am an experienced MS Sql developer and you can communicate with me with technical expressions please.