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


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

Skills: Angular.js, ASP.NET, C# Programming, Java, Microsoft SQL Server

See more: sql server 2005 project assignment, software package sql server crystalreport project vbnet, sql server 2005 project, sql server automatic tuning, sql server 2017 query performance tuning, how to create a dashboard in sql server reporting services, sql server vnext, azure sql automatic tuning, automatic index management sql server 2017, sql server 2017 automatic tuning, sql server 2017 release date, 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

About the Employer:
( 36 reviews ) RIO DE JANEIRO, Brazil

Project ID: #18953307

13 freelancers are bidding on average $201 for this job


Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$250 USD in 3 days
(21 Reviews)

Please connect back I have some queries to discuss..!! Hello, Hope you are doing well..!! I have great passion with Laravel, Codeigniter, CSS, HTML, Javascript, JQuery, Wordpress, PHP, NODE.JS, AWS Cloud Hosti More

$155 USD in 3 days
(7 Reviews)

Hello Friend, I have read your project requirements. We are familiar with all required technologies and we have expertise resource to start with your project. We have 4+ year experience in design and development More

$155 USD in 2 days
(11 Reviews)

Hi,Dear. Time is going and I'm RUNNING! I have many development experiences,getting work about . As I am interested in your project, I've read the project description and definitely can develop your task. If I hire More

$477 USD in 3 days
(3 Reviews)

I am an experienced Web and Software Developer, and I am very interested in your job post. I have an excellent experience in MVC,.Net Core, ASP.NET, C#, Linq, Entity Framework, MySQL, MSSQL, REST API, JSON, HTML5, A More

$222 USD in 7 days
(4 Reviews)

Hi There! Would you please share more about the project? I am really interested to work with you for long. Best Regards, Abhishek

$155 USD in 3 days
(2 Reviews)

I am new on this website, I don’t have that much reviews to put my profile on top but I have a vast experience of around 12 years in working with technologies. I am Microsoft certified developer. I have a go More

$30 USD in 3 days
(1 Review)

Need Web Development or Business Growing? My experiences range from building responsive software design that work well cross-browser to Business Goal. I am glad to provide full solution to you. We Are in House of Web More

$155 USD in 3 days
(1 Review)

Respected Sir, Greetings of the Day! I am Subham Das. I have 8+ years of competitive experience in web application development using ASP.Net MVC, Angular JS and SQL server. Recently completed projects by More

$277 USD in 10 days
(1 Review)

I am a database/MSBi/Solution architect and have more than 14 years of experience in IT industry. If you are looking any support from Java then I am not best fit for this project. But if you are looking SQL, SSRS, SSIS More

$222 USD in 3 days
(1 Review)

Hello, I have read out your requirements that you need a webapp. We are a Team of 6+ years experience 25 Dedicated Professional developers who are very good at designing and Building [login to view URL] have worked on More

$200 USD in 3 days
(0 Reviews)

Hello, I read your job proposal carefully, and I want to help you bring this to life. With many years of industry experience, I am able to build like any well-rounded full-stack engineer with a focus on mobile de More

$155 USD in 3 days
(0 Reviews)

Hi, I am glad to propose your project. I will complete your job ASAP. I am a web developer. I have rich experience with WordPress, React, NodeJS, Django, Grails, Laravel, SQL, HTML5, CSS3, JQuery ... for 8+ years More

$155 USD in 2 days
(0 Reviews)