We require a report written with Crystal Reports which reports on data stored in an Access 2000 db. We will provide the dB and all sample data once the bid is accepted. dB contains driver delivery information such as Route#, Invoice#, Date/Time delivered, etc.
The report needs to run from a Visual Basic app so please include that with the finished product. A simple form with plain buttons & text boxes is fine. We will integrate the report into our own VB app. Your app is simply to demonstrate the the report can be called with parameters from VB. The focus is the report (*.rpt) file, not the VB app. The vb app can be "thrown together", no problem.
The design of the report is largely up to the coder. It should accept a date range & a route number to be reported on. The report should then show all stops the driver made for the given date range (sort by time within date, DESC) and the time between each stop. Sould also show a summary at the bottom with the average time between stops and the longest interval for the day. If a range of dates is entered, report should page break on date.
1) Complete source code for the fully-functional working program & report.
2).rpt file for the described Crystal report.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
Win98+,Visual Basic 6, Crystal Reports 8, Access 2000