Завершено

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

Квалификация: Cold Fusion, HTML5, SQL-сервер Microsoft, SQL

Показать больше 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

О работодателе:
( 13 отзыв(-а, -ов) ) Mount Vernon, United States

ID проекта: #19701760

Поручен:

arigam

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 Больше

$800 USD за 10 дней(-я)
(25 отзывов(-а))
6.2

18 фрилансеров(-а) в среднем готовы выполнить эту работу за $605

TakaAlex

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 за 10 дней(-я)
(8 отзывов(-а))
6.5
JinTaiZhe

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 Больше

$500 USD за 15 дней(-я)
(5 отзывов(-а))
5.7
miftkhar

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 Больше

$600 USD за 7 дней(-я)
(22 отзывов(-а))
5.5
oneginaalyona

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

$600 USD за 10 дней(-я)
(10 отзывов(-а))
5.3
grigorywazin

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 за 10 дней(-я)
(8 отзывов(-а))
4.8
HongCStar86

Hello! I am a FULL-STACK expert with 8 years' experience of web development. I recommend angular for your UI. My core competency lies in Angular, React and Python and Node.js. I have 5+ years' experience of Angul Больше

$555 USD за 10 дней(-я)
(9 отзывов(-а))
4.3
Lultu

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 за 15 дней(-я)
(10 отзывов(-а))
4.0
Geniusteam

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 Больше

$500 USD за 21 дней(-я)
(1 отзыв)
4.1
mnjpatle

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 Больше

$666 USD за 10 дней(-я)
(19 отзывов(-а))
4.7
dreammate0621

Hello! I am a developer. I have checked your project description and interested. If you hire me, I am gonna do my best for your project. I guarantee the good result. I will wait for your reply. Thank you.

$555 USD за 10 дней(-я)
(6 отзывов(-а))
3.8
kovirijagdish

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 Больше

$250 USD за 1 день
(2 отзывов(-а))
1.7
rahulvyas08

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 Больше

$750 USD за 10 дней(-я)
(3 отзывов(-а))
1.7
shemymohamed10

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

$750 USD за 30 дней(-я)
(0 отзывов(-а))
0.0
bizmanas

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 за 5 дней(-я)
(0 отзывов(-а))
0.0
jhubers

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 Больше

$750 USD за 21 дней(-я)
(0 отзывов(-а))
0.0
krishaweb

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 Больше

$615 USD за 10 дней(-я)
(1 отзыв)
2.9
codebid88adom199

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 Больше

$500 USD за 7 дней(-я)
(0 отзывов(-а))
0.0