Create Report

I will need a report in vb6 designed using the Data report and Without using the DE. This must be created through Using vb6 Code only( It uses an Access 2000 Database backend). The user will need to find information from three tables. He/she will input a range of dates onto a vb6 form, or click on a monthview control( not the calendar control) and pull up the information by each individual EmployeeID ( EmployeeID is the last name of the Employee)Or they will click on monthview control and all employees will appear on the report. The user will want to find tickets by dates and other information such as giftcertificates, CashBalance, ExpirationDate, ServiceName ,EmployeeID's and CustomerName- ( ie:CompanyName and contactname)associated with that EmployeeID or TicketID. There could be many EmployeeID's on any Ticket as some tickets are split between multiple employees.( See OrderDetails2). Very Important: Need the sum of CashBalance( Orders ) GiftCertificate( Orders) SalesPrice( OrderDetails2) ------------------------------------------------- I will provide the database to the coder who successfully bids on this project. It is not a complicated project for an experienced coder who understands joins in SQL and that the report can be encapsulated and a coder who understands unbound reports. --------------------------------------------------- Take Customer, Orders and OrderDetails2( services ) Need the following information on a report. --------------------------------------------- COmpanyName + ContactName from Customers --------------------------------------------- From Orders I will need: CashBalance GiftCertificate PurchasedFor ExpirationDate ------------------------------- TicketID From OrderDetails2 EmployeeID from Orderdetails2 -------------------------------- Need the sum of CashBalance GiftCertificate The sum will be by CustomerID and TicketID and by range of date. -------------------------------- Please see zip for full description ## Deliverables 1) Complete and fully-functional working program and complete source code of all work done. 2) 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 vb6