I need a program that will get all the orders that are not shipped or voided from the inv table and print them. The ship status is in the Ship_Status field and the date is in the InvDate field. All the orders should then be sorted by date with the date printed then all orders for that date indented with the ID and Ship_Status printed. Example: 07/24/2006------------------------------------------------------------------ 97073 Yet another fine shortage 97088 Box and hold 97131 Custom order 97136 Custom order 97137 Custom order 07/25/2006------------------------------------------------------------------ 97168 97194 97196 97205 Yet another fine shortage 97231 Custom order 97238 Yet another fine shortage 97247 97248 Box and hold 97251 07/26/2006------------------------------------------------------------------ 97268 Yet another fine shortage 97274 Custom order 97281 Box and hold 97291 97294 Yet another fine shortage 97301 97304 Yet another fine shortage 97326 Yet another fine shortage 97335 Yet another fine shortage 07/27/2006------------------------------------------------------------------ 97353 Yet another fine shortage 97361 Yet another fine shortage 97363 Yet another fine shortage 97387 Yet another fine shortage It should use the DSN shipping_stuff to connect to the database. The report should be printed to the windows default printer. Double clicking the shortcut should cause the report to print and the program to close without the user having to do anything else. Please ask any questions you have after reading this. Jonathan
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows XP