Reporting on Support Tickets / Billing Reports
Greetings. I have two MS SQL 2000 Server databases that need some relatively simple reports created that are accessable via web page or email. I am not concerned about he language used but .NET or ColdFusion are preferred. Below is a basic idea of what needs to be done. I have attached a MS Word document that describes the databases and exact deliverable. I have also included some (not pretty) sample reports created in excel to at least give a starting point.
_** Create reports to measure technician metric summaries on support tickets. The following need to be measured via a web based report. It will also need to be sent in Weekly Format via email. The default report output should be for the past 7 days but it should be easy to choose a month or year or to step back week by week. A custom date range should also be a selection.
create reports to measure technician billing. A Daily summary for each technician of time billed to Helion and to clients will need to be tototalled. It will also need to be sent in Weekly Format via email. The default report output should be for the past 7 days but it should be easy to choose a month or year or to step back week by week. A custom date range should also be a selection.
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).
Windows 20003 Server R2
.NET or ColdFusion MX 6.1
Email Report must be HTML
Web Based reports