I have added drivers and vehicles to my application.
I have also created the Driver Login event rule.
I am able to create a Event Rule report based on driver login for all events. For the event report. I can see the driver name as a string
See Image attached.
I am also able to create a Trip and Idle (Detailed) report of my vehicles.
See image attached.
What I want to achieve is to create a Report that is similar to Trip and Idle (Detailed) but I want to be able to show the driver name as a string for the vehicle in that report.
I am not very sure how to go about creating such a report.
Below are approaches which I thought is possible.
1. Write my own SQL code which joins the related tables and put that SQL code as new a data provider. After that, I can create a new kind of report based on the new data provider. The problem in this approach is. I cannot see connection between the users table and the other tables(example reportv3_data_store ) inside the database system.
2. Try and manipulate the existing data provider like eventprovider and distance01provider such that I can somehow include the driver name
3. Create some sort of even rule in my application for the vehicle start and stopping and combine it with my driver login event rule. With all these event rules combined. I generate a Event Rule report which fulfills 3 events of vehicle start, stop, driver login. Then the report generated will achieve the outcome I want.
I am not sure if my approaches are logical. I hope to hear more suggestions on how I can create the report I want.
Thank you in advance.