Completed

Build a form in Excel for report generation

A Synapse data warehouse contains a view called "Job Yeild" which hold information about project cost transactions and different budgets against those jobs.

We require a form to be built in Excel which will allow the user to select key parameters like:

- Company

- Job Number

- Budget Type (Budgets available depends on what types of budgets are available for the Job)

- Posting From / To Date

- "Get Data" button

Once the user enters their parameters, and hits "Get Data" the report must be returned. In the background a connection to the synapse data warehouse should be created along with the query string with the selected parameters from the form . The report must be formatted as per the sample which will be provided. If the user wants to rerun the report they should be able to enter new parameters into the form and hit the "Get Data" button to refresh the query with new parameters and return the report formatted correctly.

Skills: SQL, Excel, Excel VBA, Excel Macros

See more: build data entry form excel, excel report form, excel based report generation, visual basic excel report generation, report generation excel charts text, report generation excel vba, excel report generation, excel report generation sql server, data report generation current form vb6, build form controlled report excel repost, sales tax report form excel, report generation dashboard using excel, student report form excel, excel build form, our company uses a ussd based mobile money transfer system in africa for crossborder remittances and we require some updates and, freelance build excel report, automate excel report generation

About the Employer:
( 5 reviews ) Edmonton, Canada

Project ID: #31938435

Awarded to:

(0 Reviews)
0.0

31 freelancers are bidding on average $480 for this job

(253 Reviews)
8.2
bouslimi1979

Hello, The project is well described. I need to check the Job Yield and see how we can get a connexion to get the data based on a http request. which will depend on the parameters entred by the user. After that we can More

$700 CAD in 10 days
(308 Reviews)
7.9
(163 Reviews)
7.6
(122 Reviews)
6.7
(339 Reviews)
6.6
(81 Reviews)
6.3
(43 Reviews)
6.0
kevivu

Hi There, I have reviewed your requirements carefully and I can definitely start immediately. Also I am 100% available during EST (New York Time) hours. But I have couple of questions on requirements, please ping me More

$350 CAD in 5 days
(83 Reviews)
6.2
(37 Reviews)
5.7
abhinovpankaj

Hi, We have a team of enthusiastic and hard working [login to view URL] experience of varying from ~ 13 years to ~5 years in providing solutions for plugins,add-ons for all the Microsoft office products(Office , excel More

$860 CAD in 7 days
(43 Reviews)
5.2
(12 Reviews)
4.9
(14 Reviews)
4.2
(14 Reviews)
3.8
varimaxanalytic

Hi! I am really interested in this job. I’m data scientist working remotely with various analytical companies. I’m offering best quality and highest performance at a price we are both comfortable with. I can complete More

$250 CAD in 1 day
(2 Reviews)
3.5
(3 Reviews)
2.8
oleksdevr

To complete your task, knowledge of visual basic and excel macros are neccessary. I am ready to start immediately. Let us discuss soon.

$650 CAD in 7 days
(1 Review)
2.6
Shablu4u

Hi, I have a deep understanding and experience in Excel VBA. ****************************************************************** I'm sure to complete this project with high quality on time. Looking forward to hear mor More

$450 CAD in 5 days
(1 Review)
1.5
nasonkanjirawaya

Dear Client, I am an excel data expert with hands-on experience working on excel projects, and would like to help you with this project. I will build you an excellent form that will be generating the reports as you re More

$450 CAD in 5 days
(1 Review)
1.3
lisapuma02

"Build a form in Excel for report generation " Hi, there. I hope you are safe from covid-19. I am a creative and professional Database and database convert application developer having more than 5+ years of professiona More

$450 CAD in 3 days
(2 Reviews)
1.0
temaural

Dear Client, I am a specialist in data entry as I have been working in this field for about five years. Expertise in Data entry and excel, also have proficiency in MS Office, Google analytics and QuickBooks and fast t More

$630 CAD in 7 days
(0 Reviews)
0.0