customize report based on software
$250-750 USD
Paid on delivery
custom report building according to criteria written on attachment below
the software has a blog for query writing instruction .attached below and what is needed is to write a query that reflect the report i want
the look should be changed to look similar to report sample attached
on the excel report template it has sheet one which has the report schema for daily and monthly total , each page consist for one driver and violation he made
the second sheet is the monthly summary for all driver consists of totals and max an min violations committed
criteria is
1- Seat belt error to be recorded every time the engine is start working but the seat are not in place while the car speed are above 10 km/hr. and this error to be continually recorded every 1 min of driving at a speed above 10 km/hr.
2- The speed limit is 90 km/hr. ( higher speed ) and recorded as below criteria .
A- Over the speed limit for 5 second period will record 1 error then if the speed stay over the speed limit the tracker will record an error every 5 second cumulatively .
B- If the speed pass the speed limit for ( 0 – 10 ) km / hr. it will recorded an error every 5 second .
C- If the speed pass the speed limit for ( 11 – 20 ) km / hr. the device must recorded a double error for every 5 second .
D- If the speed pass the speed limit for ( 21 – 40 ) km / hr. the device must recorded 3 error every 5 second .
3- Over 130 km/hr. the device must record 4 errors every 5 second
4- Over riving record an error the RPM needle reach 4500 RPM and stay for more than 2 seconds while the car speed are zero .
5- Harsh breaking as the built in equation from the system to record an error . ( the calibration to be done by trail the average between peak break and high break )
6- Harsh acceleration as the built in equation from the system to record an error.( the calibration to be done by trail the average between peak accelerate and high accelerate )
7- The light is on to record an error if the car reach a 5 km/hr. speed and the cars lights was off to be measured upon the system internal time ( from the complete sunset ( after the clock sunset by 30 min ) till 30 min before the sun raise )
8- Excessive idling to record an error if the engine was on and the car speed was zero for 15 minutes continually time interval .
9- Harsh turning to be record an error as the device equation and after being calibrated by trail the average between the peak turning and max turning ).
these articles should be read
[login to view URL]
[login to view URL]
Project ID: #17707930
About the project
11 freelancers are bidding on average $489 for this job
Hello! We are interesting your project very well and full time devlopers. We have great skill in design and php. Our price and period is negotiable. Employee’s satisfy is my happiness ! Let's go ahead with me ! More
Hey !!! I checked your attachments and want a discussion with you. As per the description you shared i am highly interested to get started on the project as I am having 5 years experience as a JavaScript Developer. More
Hi sir I am Hasan Jack and I can help you with this job and I would like to discuss more about this project as it completely relevant to my skills. Looking forward to hear from you. Best Regards, Hasan Jack
Respected. We had reviewed your requirement and able to start work. Let me know when you pfere to start work ! We had already done similar project with ERP. Looking forward to hear you back. Have a good More
I have experienced more than 3 years.C# ,vb.net ,sql server , crytal report ,devexpress report experience 3 years
We can use USE open Source BIRT Report for your requirements. Please let me know if you need any Demo for the report.