Find Jobs
Hire Freelancers

SSRS Report - Ticket Status Report

$30-100 USD

Completed
Posted about 12 years ago

$30-100 USD

Paid on delivery
I am looking for someone skilled in using SSRS to create this and multiple other reports that are needed. This report will contain a list of all tickets that are not currently in a "closed/canceled/completed" status at the top. Then will have a section at the bottom showing tickets that have been "closed/completed" within the last 5 days. The data generated needs to come from existing SQL views as much as possible since the SQL views never change. Data drawn from actual tables need to be identified as we may need to update in the future when the system is upgraded. The report needs to include the following data for each ticket: * Ticket Number * Ticket Summary * Ticket Description * Ticket Contact * Contact Phone * Ticket Status * Assigned Resources * Date & Time of Last Ticket Update * Last Ticket Update When running the report the user needs to have the following choices presented: * Company - A list of all company with open tickets or tickets closed in the last 5 days * Grouping - The Ability to have the tickets grouped by "Ticket Status" NOTE THAT CLOSED/COMPLETED TICKETS SHOULD ALWAYS BE SEPARATE from the rest of the ticket data. * Sorting - The ability to have the report sorted by "Ticket Number" ASC/DESC, "Last Update Date & Time" ASC/DESC ## Deliverables Sample of desired report attached. Please note this IS NOT exactly what I want as some of the requirements are missing. Before this project is complete we will need to reun this report agains multiple customers to see what sort of data we receive. Project will be paid if report formatting and functionality is achieved as requested and that data is accurate. * * *This broadcast message was sent to all bidders on Thursday Mar 22, 2012 12:03:42 AM: Please make sure you have posted a bid for this project. Coders with no bid will not be considered. Also, please ask any relevant technical questions. This is how I know that you are capable of performing this work. Thank you.
Project ID: 2716909

About the project

9 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$40 USD in 193 days
5.0 (3 reviews)
2.5
2.5
9 freelancers are bidding on average $56 USD for this job
User Avatar
See private message.
$50.15 USD in 193 days
4.8 (84 reviews)
5.7
5.7
User Avatar
See private message.
$100 USD in 193 days
4.7 (16 reviews)
4.1
4.1
User Avatar
See private message.
$60.35 USD in 193 days
4.8 (10 reviews)
3.5
3.5
User Avatar
See private message.
$80 USD in 193 days
5.0 (1 review)
1.8
1.8
User Avatar
See private message.
$29.75 USD in 193 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$60 USD in 193 days
5.0 (1 review)
0.1
0.1
User Avatar
See private message.
$10 USD in 193 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$70.55 USD in 193 days
0.0 (1 review)
0.0
0.0

About the client

Flag of UNITED STATES
Kansas City, United States
5.0
1
Member since Feb 29, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.