Crystal Reports

$30-250 USD

已完成

已发布

超过 6 年前

$30-250 USD

货到付款

I need a crystal reports report show support ticket metrics from a sql database. You will design the layout of the report and get it approved. The two Microsoft SQL table schema's are included. Once the project is awarded data for the tables will be accessible. Also enclosed is a sample query based on a microsoft access query. Questions: We need to take into account holidays and weekends so times are only calculated based on working hours. Holidays will need to be conveniently stored in crystal reports and be editable or stored in a text file. Hours for calculations will be as follows. Time outside these hours will not be included in the calculations. -Only count business hours Monday thru Friday 7:30-5:00 -Do not count weekends -Do not count holidays Report content Ticket time average New to open Total ticket time New to open average Weekly ticket time New to open average for last 8 weeks Daily ticket time New to open average for last 7 days Ticket time New to Open grouped by tech Total time New to Open average Weekly time New to Open average for last 8 weeks Daily time New to Open average for last 7 days Ticket time New to Close Total ticket New to Close time average Weekly ticket time New to Close average for last 8 weeks Daily ticket time New to Close average for last 7 days Ticket time New to Close grouped by Tech Total ticket New to Close time average Weekly ticket time New to Close average for last 8 weeks Daily ticket time New to Close average for last 7 days Number of Tickets grouped by customer Hourly rate Number of tickets Total Hours Hourly rate

Crystal Reports

Database Administration

Database Programming

SQL

项目 ID: 16192941

关于此项目

10提案

远程项目

活跃6 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@reedsystems

Hi, I read your request. From your description, I can deduce that you need a CR report file created based on the record in a database including some fields and some logic. I understand the requirement and I can provide you with the required query and the report file. I have up to 4 years of experience using crystal reports to generate report both with desktop, web based and standalone system, so be rest assured that I can provide you with what you require.

$125 USD 在2天之内

4.8

(10条评论)

3.6

10威客以平均价$316 USD来参与此工作竞价

@codetod

Hi I am a database expert with 15 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. I am equally good with crystal reports. My suggestion is to develop a stored procedure in SQL, to give the desired output and then link the stored procedure to crystal report, so it displays the data from the database. The holidays cant be stored in crystal report, it has to be stored in a new table in the SQL database. I can show you how easily it can be added edited in SQL management Studio. Do you have Crystal reports already installed in a PC, where I can connect on team viewer and finish the job? Crystal report works are very less these days, and I do not have crystal reports installed on my PC right now. I prefer connecting to your server and doing the work there. Look forward to hear from you. Thanks Roni

$150 USD 在3天之内

5.0

(49条评论)

5.8

@fanninson45

INTRODUCTION I had done a very similar project like this recently https://www.freelancer.com/projects/php/Project-for-fanninson-11770082/ I am a database reporting analyst responsible for creating reports from the advanced database using SQL; advanced in the area of data staging and mining, and the creation of interactive reports. SHOWCASE I can start working on your project today. You only pay 30% milestone on 50% job completion. I have 100% project completion history. RECENTLY COMPLETED PROJECTS • Convert Hyperion to Crystal Report • PosrgreSQL Expert - Database Schema • Web Architecture • Asp.Net and Crystal Reports • Caspio Developer

$200 USD 在7天之内

4.9

(22条评论)

5.7

@vishnu5894

Hi, Hope you are doing well. I have expert knowledge in Crystal Reports designing and development. I have created many reports using this tool. Please message me for sample work and further discussion.

$166 USD 在2天之内

5.0

(8条评论)

3.8

@enterpriseit1

Hello, i read your project description about crystal reports developer. I have over 7 years of experience as a reports and database developer. I have developed well over 2500 reports so far using various data sources like, mysql, oracle, sql server, access, excel, etc. I have developed chart, cross tab, cube reports, sub-reports, on-demand reports using various versions of crystal reports. I can develop these reports and i can start immediately. Excellent communication skills and excellent reviews for the past projects.

$277 USD 在3天之内

5.0

(7条评论)

3.8

@cwprice99

I have over 15 years experience with crystal reports development. I have created, converted, and updated reports based on multiple database structures to include MS SQL Server, Oracle, Access, Excel, and DBF files. I have deep experience with data reporting using sub-reports, crosstabs, and all other Crystal functions and capabilities. I'm very familiar and experienced with updating or converting existing reports to various versions of Crystal Reports. I have multiple clients that I have provided Crystal Reports services with report updates, new reports, and conversion of reports to different versions. I have vast experience with all Crystal Reports versions (8.5, 9.0, XI, 2008, 2011, 2013, 2016)and also have most versions installed in my development environment. If you have current reports, or templates that you want the reports modeled after, that can save us both time for validating report requirements. I have report metric experience and background in IT support, Service Desk mgmt, ITIL certifications, and can deliver the reporting you need. I am comfortable working with reports with data saved or connecting to your system remotely for report development. I would love to help you in this effort for your reporting needs as I am available to start immediately

$350 USD 在10天之内

5.0

(4条评论)

4.0

@rschues

Hello. I am a Developer and Business Analyst, with 20+ years of experience. As a Crystal Reports software developer, I have practical experience creating complex SQL queries and connecting to the data sources such as Oracle, SQL Server, Pervasive 9, MS Access, Excel / CSV, and DB2/400. I have created reports using most versions of Crystal Reports, from Seagate Crystal Reports 8 through SAP Crystal Reports 2016 / Business Objects. I am proficient in using more complex features such as Commands (using multiple table joins), Crosstab, Drilldown, Charts, Formulas, Sub-reports, Dynamic Parameters, and Running Totals. On the database side, I have experience using Oracle SQL Developer, SQL Plus, SQL Management Studio, and Toad. Additionally, I have experience creating PL/SQL procedures, packages, triggers, tables, indexes, and views. I am a highly motivated creative thinker and problem solver, technically proficient, organized, resourceful, and professional. I pride myself on creating unique and adaptive solutions. Note: I can begin work on this assignment on 2/12/2018.

$444 USD 在3天之内