Lukket

Make a reporting screen for our webapp and some sql improvements and corrections

Project involves 3 parts:

1) Fixes and improvements to our MS SQL stored procedure

2) Creating a reporting page to show the results of the stored procedures.

Our webapp uses : C# [login to view URL] webAPI MVC MS SQL 2017 on AWS Gitlab

3) Begin to elaborate and create new more eficient AND BETTER LOOKING reports based on the data from our stored procedureS output.

(1) SQL

a) add to our Stored Procedure 3 rows of data on top.

i) 1st row is the header name for that column that should be used when we output to

screen/pdf/excel

ii) 2nd row of data is a descriptive row with explanations of all the columns so that the developers who work on this project will know the contents of each column of data.

iii) inglish translation of the current column name in portugues so that we can start translating these names to make it easier for international developers to participate in our development.

b) change a series of formulas in our stored procedures where we have identified erros in the calculations made that populate the outputted data (we'll deliver a detailed doc with the exact changes to be made).

(2) We should be able to select the report (stored procedure) from the screen or input the name of the stored procedure to run and option to select the date for the report when this is necessary.

results on screen should basically mimic an excel spread sheet in terms of layout and functionality.

Basic requirements for on screen visualization are basically excel functionalities.

i) Freeze top row ALWAYS and option to freeze more - the headers need to always be on top and visible when we scroll down to see data results so that we always know what data is in each column.

ii) Freeze columns

iii) Be able to sort and filter like a simple excel spreadsheet.

iv) use pivot table functions to elaborate dynamic reports

Output should be to screen/pdf/excel

A VERY IMPORTANT basic rull is that we always like the reporting page to be as clean as possible and if there are selection boxes (to select dates and other filtering options) these should always "hide" on top after we have made our selection so that we view ONLY THE DESIRED DATA.

You can download the db below and also the current excel to our 2 basic stored procedures that we will work on and a word doc to have an idea of the type of simple corrections we need to the stored procedures. We will show the errors in the excel spreadsheet and you will make the modifications to the SP to correct the output.

Gitlab & details [login to view URL]

webFC Homol [login to view URL]

user: [login to view URL]

pass: freelancer

Evner: Angular.js, ASP.NET, C# Programmering, Java, Microsoft SQL Server

Se mere: sql server 2005 project assignment, software package sql server crystalreport project vbnet, sql server 2005 project, free lance work, freelancer id, work as a freelancer, angular 2 freelance, join freelancer, freelancing it projects, freelancer angular 4, freelance jobs, sql server mobile project example, screen scrape sql data tables, sql database free project, deploy sql express database project, sql server demo project asp, sql ssis free project, sql server save project, sql code store project, modifications improvements database project

Om arbejdsgiveren:
( 36 bedømmelser ) faridabad, India

Projekt ID: #18956367

9 freelancere byder i gennemsnit $430 på dette job

fullymagento

WHY WE FOR YOU.. -90 days assistance -PMS SYSTEM - 100% on-time delivery - Excellent Communication Skills - Flexible to work in client timings - Support available for 18 hours a day (Monday to Saturday) +5:30 GM Flere

$1055 NZD in 20 dage
(6 bedømmelser)
4.3
kusal77

I am a Dedicated Senior .Net Developer and Database Administrator with 20 years of experience in Web/ Windows and Android Developments,Administration, Project Management System analysis, and Database Developments Flere

$277 NZD in 3 dage
(5 bedømmelser)
3.1
udalcorpo

Respected Sir, Greetings of the Day! I am Udal Kumar Bharti. I have 8+ years of competitive experience in web application development using ASP.Net MVC, Angular JS and SQL server. Recently completed proj Flere

$250 NZD in 10 dage
(1 bedømmelse)
1.9
sikarwarrupam90

Hello dear, I am interested in this job. I have 4 year experience in development. My main expertise is in Angular.js, C#, MVC, MVVM, WPf/WCf, Entity Framework. I have gained good experience in WPF which i used in De Flere

$222 NZD in 10 dage
(0 bedømmelser)
0.0
ZoonetoInfosoft

Hello Sir. Greetings & Regards. We are a India based IT services provider company since decades we provide our services domestics as well as international market. We have a 20+ in house team of ninja's derringers D Flere

$222 NZD in 15 dage
(0 bedømmelser)
0.0
sujithpalakkal

Hello, I see that you have some maintenance work on your website, I would be happy to work on your project. I should be upfront about my lack of experience in Freelancer, but I have strong development experience Flere

$250 NZD in 10 dage
(1 bedømmelse)
0.0
filmonefrem

Hello BizTech, I am applying for the C# developer position. I have 8+ years of experience with Visual Studio, C#, VB, ASP.NET, Entity Framework and SQL Server development. I have also used TFS in small team environm Flere

$261 NZD in 7 dage
(0 bedømmelser)
0.0
yotink522

Greetings for you. I am a individual Database programmer and have 5 years of experience in the industry. When you want to start this project ? Skills : Microsoft SQL Server Maintenance, Transact-SQL Programming, Flere

$944 NZD in 7 dage
(0 bedømmelser)
0.0
$388 NZD in 25 dage
(0 bedømmelser)
0.0