Add reports to Cold Fusion/SQL application.

Staff performance reporting for TTG

Executive Summary

This project is to add staff performance reports and fix incorrect subtotals on the "type" report. These reports are intended to assist in measuring staff performance and utilization in the creation and updating of "issues" in the CSR database application. Technology is use is Cold Fusion with Microsoft SQL hosted internally on Windows Server with IIS. I have coded most of this application but am short on time and need some help. Remote access can be provided.

Detailed project requirements

Modify Menu (site-wide template) to include new reports and make needed database and page changes to add needed metrics like recording the date/time of an issue's closure if it is not already recorded in database.

Create the following new reports with the identified fields in tabular format. A handful of fields may be added during project - Visual reports in HTML5 with graphs - downloadable to PDF

1. CSR totals reports: Issues/updates/CSR/Date - CSR total - master report with links on name field to individual performance report

2. CSR Time of Day reports: Issues/updates/CSR/ToD (time of day) - we want to see when they are doing updates - need master report with all CSR and graphs also individual reports.

* Also need option to see this broken down by customer/agent/Overall

* Need a graph of Day with bars for each hour.

* Also pie chart with thresholds of 8-11am, 11-2pm, and 2-6pm using the number of issues opened in that time frame.

* Also need to see table/graph data for issue "updates".

3. CSR Issue Type Reports: Issue/update/CSR/type of issue/date

4. Issue Average Time to Close Reports: Overall avg time to close (all CSR), with individual reporting of that CSR user time to close.

* Need graphs

* The individual would just be a report (using selected date range) that listed the CSRs and their average time elapsed between opening and closing an issue.

* When report is selected and user is determining date range, need checkboxes for each type of issue and user can select to inlude them in report or not.

New reports requirements (overall)

* these reports will present a page where a date range is presented to user.

* There are going to be a handfull of filtering requirements added to this page during the project if needed by users

* Select date ranges for report to run

* Select issue type in issue time to close report - checkboxes for one/some/all

* Formatted with company logo like other reports

* Reports must have subtotals when applicable

* Downloadable through PDF

* Need to print on standard size paper

Skills: Cold Fusion, HTML5, Microsoft SQL Server, SQL

See more: convert php cold fusion, cold fusion html parser, writing cold fusion weird characters, coldfusion report builder 2018, coldfusion report builder tutorial, coldfusion standard deviation, cfdocument, adobe coldfusion report builder download, hourly rate cold fusion developers, cold fusion image upload, cold fusion page setup, india russia cold fusion, search ebay cold fusion, cold fusion html parse, sample cold fusion code ebay api, cold fusion social networking, making cold fusion dll, cold fusion post website script, add crystal reports setup using windows application cnet2005, cold fusion sercie scheduling application

About the Employer:
( 13 reviews ) Mount Vernon, United States

Project ID: #19701760

Awarded to:


Hello, I have +15 Years of experience in ColdFusion with Many databases like MS SQL, MySQL etc. I have worked on more than 200 CF Websites and apps. I can generate the custom reports as you want with many filter and More

$800 USD in 10 days
(30 Reviews)

16 freelancers are bidding on average $611 for this job


Hello Very interested in your project I have many years of experience in software development. Also, very familiar with Report Feature. Review my work on my profile Let's have a talk for more detail Thanks. :)

$777 USD in 10 days
(8 Reviews)

Hello. My experiences range from building responsive mobile sites that work well cross-browser to building scalable sites for the financial services industry. With flexible working hours, I always keep communicat More

$500 USD in 15 days
(5 Reviews)

Hi, I am an Adobe certified in ColdFusion and working in CF for last 12 years. I assure you that the work will be done very professionally, according to your requirements and in given time frame. Looking forward for More

$600 USD in 7 days
(22 Reviews)

Hi there. I'm confident in any part of Web development. [login to view URL] Promise high-quality and bug-free. Let's make a great experience. Best regards. Alyona.

$600 USD in 10 days
(10 Reviews)

Hi, I’m very confident in cold fusion. I’m very interested in your job and wanna dive in to your job right now. Let’s discuss more about your job in chat room. I’ll wait your contact Thank you.

$555 USD in 10 days
(8 Reviews)

Hello, Can we discuss in detail ?Do you have any timeframe? We welcome you to join hands with us as we think we are capable enough to start this project and we give you surety of answering all your queries. We are More

$500 USD in 21 days
(1 Review)

have been working with CF for past 14 yrs. which version of CF are you using? cfchart will be good enough to handle your requirement.

$777 USD in 15 days
(10 Reviews)

Hello Sir, This is Manoj Patle , 7+ years experienced ColdFusion developer, I own a team of developers expert with different technologies and ability as well. We worked on 100+ project of ColdFusion for support More

$666 USD in 10 days
(19 Reviews)

I believe in providing good quality code and services with security. I am a Web Security Researcher, ColdFusion and Php Web Developer & Bug Bounty Hunter at HackerOne, BugCrowd, BountyFactory and many other Independ More

$250 USD in 1 day
(4 Reviews)

Hello, After reading over your job post, this looks like a perfect fit for my skill sets. I have made many websites using ColdFusion and MSSQLSQL Server(ver.2000/2005/2008/2012/2014). I have wrote APIs for mobile a More

$750 USD in 10 days
(3 Reviews)

ear, I have 6+years of rich experience with several complex and easy projects alone or with a team, I liked your project details and already done and completed successfully with an UK clients offsite. Please share mor More

$500 USD in 7 days
(0 Reviews)

Hello, I hope you are doing well! I am glad to say that we have worked on similar projects for our clients. You will get benefits of the same experience team which saves your time and cost. Job Understanding: -I More

$615 USD in 10 days
(1 Review)

I am an experienced CF developer with 7 years along with SQL and i can help you doing this project.

$750 USD in 30 days
(0 Reviews)

I have 14 years of experience in SQL SERVER DEVELOPMENT. I have worked with cold fusion applications. can build the app in 3 days for you.

$388 USD in 5 days
(0 Reviews)

I have been developing in CF since 1994 when I was working with Jeremy Allaire to showcase this new tech. I've been CF and SQL work ever since. I'm comfortable in most of the CF frameworks (Fusebox, ColdBox, Model-Glu More

$750 USD in 21 days
(0 Reviews)