Find Jobs
Hire Freelancers

Custom SSRS Reports from SQL Data - Time Sensitive

$250-750 USD

Terminado
Publicado hace más de 8 años

$250-750 USD

Pagado a la entrega
We have three reports that need to be written to specifications. These reports must be completed in 7 business days FIRM. If you cannot complete this in 7 business days or less do not accept the project. I will hold you to the completion date. I have three reports that need to be made. Two of them are simple table reports, the third is a little more complicated. Review all requirements and examples before bidding. Please view Excel file for examples. Feel free to recommend style changes and ideas. Helion_Client_Identity - Table that contains primary Keys. ClientID, ParentID, and the client names. Will be used for all three reports. Pull names from here. Kaseya_AssetData - All workstation and server data. VMware_Host_Data - VMware Server Data Excel file with examples and table creation scripts included. Workstation Summary Report: 1. When report is ran, display a drop down to select the Parent or Client that we want. a. The drop down should pull the names from the Helion_Identity_Table. b. Alphabetize the drop down by parent ID, with the Client IDs under each parent. c. If the "Parent" is selected, The report should include data for every client under the parent ID. d. If the Child is selected, it should only show data for that Child site. The Excel file shows the report we want to see. This graph shows all of the workstations for a client, and a projection of when they should be replaced. Filter on [OSInfo] not like '%server%' Y axis - The "ship date" field from the Kaseya table determines the values. a. "Refreshed" Column - Count of ship date by year. The X-Axis is a projected replacement based on the Ship Date column. a. Black box will always be around the current year. b. Red values are when "Ship Date" + 5 = Year c. The $ amount in the boxes is $850 * Count of PCs to replace Store the 850 as a variable that I can go change in the future. d. Show the Dollar amount on the year the machine should be replaced. If the replacement occurs before the current year, place the value in the current year box. For example: if a machine was purchased in 2006, it should be replaced in 2011. Show red in 2011 - 2015, and the replacement cost in the 2015 box. e. Anything without a ship date can be included in the unknown column. Workstation Detail Report: Drop down selection when report is run allowing us to select the Parent or client Like previous reports. • If the parent is selected, show data for parent and all clients associated to the parent. • If a client is selected, show only the client site information. • Source workstation data from table [Kaseya_AssetData] • Display results in a nice table report. • Sort by ship date, oldest to newest. • If the Ship Date is older than 5 years highlight the entire row in light red (The "BAD" color in Excel.) • Show the columns listed in the attached Excel file. Server Detail Report Drop down selection when report is run allowing us to select the Parent or client Like previous reports. Find any servers in the VMware table associated to the ParentID [Client Name] in VMware_Host_Data contains the ParentID. Use [Host] as the Computer name Find any servers in the KaseyaAssetData associated to the parentID or ClientID under that parent. Display combined results in Table view (Columns shown in Excel file) VMware servers will always be under the parent ID. Show the Client servers listed under the client name. Highlight (Or have colored icons. Show me what is possible) by [Warranty Expiration] and [Ship Date]. • Green - If server is 4 years old or less [ship date] and the warranty has not expired. • Yellow - If server is 5 years old and the warranty has not expired • Red - If the server is older than 5 years OR the warranty is expired. VMware servers will not have a ship date or warranty date. You do not have to color code them.
ID del proyecto: 8109574

Información sobre el proyecto

7 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi, I am Nallakumar. I have more than 8 years of experience in developing SSRS reports. Please have a look at my past projects, I have complete lot of SSRS report works including the recent one for ConnectWise database. I can do these reports in less than 2 days for first look and next day, I will incorporate your comments and give the final deliverable. Displaying Clients under Parents named in dropdown is not possible in SSRS. We can display list of Parents name in first drop down and the selected Client name in another drop down with All option as default option. Variable for price ($850) can be stored in a report constant and I will let you know how to modify the same. Thanks, Nalla
$526 USD en 3 días
5,0 (8 comentarios)
4,7
4,7
7 freelancers están ofertando un promedio de $644 USD por este trabajo
Avatar del usuario
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$823 USD en 8 días
4,9 (283 comentarios)
7,4
7,4
Avatar del usuario
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$741 USD en 7 días
4,9 (62 comentarios)
5,7
5,7
Avatar del usuario
Hi, I can deliver these 3 reports to you as a Windows application developed with Delphi and FastReports (and not SSRS) within 2-3 days. Deliverable will include Windows compiled application (EXE) + complete Delphi XE7 project source code. To start work, I will need a backup of the SQL Server database so that I can set it up on my workstation. Good quality work done. Thanks for considering my bid. Bests, Larry
$400 USD en 3 días
4,9 (30 comentarios)
5,5
5,5
Avatar del usuario
Having more than 11 years of experience in banking /finance /accounting, business analysis, Data analysis, process re-engineering, Bookkeeping, copy typing, Web research, Social media marketing, lead generation, etc. Expert in MS office, which includes powerpoint presentation, mail merge, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills.
$600 USD en 7 días
4,9 (27 comentarios)
4,7
4,7
Avatar del usuario
Hi, I have got team of experts with sql and report generation. Looking forward to work on this project.
$750 USD en 7 días
5,0 (38 comentarios)
4,6
4,6
Avatar del usuario
Respected Sir i can develop the SSRS reports in the stipulated period. will be using SQL Server 2008 (as it is setup on my system) can develop them in 2012 also Warm Regards vnb400
$666 USD en 10 días
4,7 (41 comentarios)
5,0
5,0

Sobre este cliente

Bandera de UNITED STATES
Timonium, United States
5,0
14
Forma de pago verificada
Miembro desde nov 19, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.