Завершен

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.

Навыки: SQL, Excel, Excel VBA, Excel Macros

Показать больше: 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

О работодателе:
( 5 отзыв(-а, -ов) ) Edmonton, Canada

ID проекта: #31938435

Поручен:

(0 отзывов(-а))
0.0

31 фрилансеров(-а) готовы выполнить эту работу в среднем за $480

(253 отзывов(-а))
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 Больше

$700 CAD за 10 дней(-я)
(308 отзывов(-а))
7.9
(163 отзывов(-а))
7.6
(122 отзывов(-а))
6.7
(339 отзывов(-а))
6.6
(81 отзывов(-а))
6.3
(43 отзывов(-а))
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 Больше

$350 CAD за 5 дней(-я)
(83 отзывов(-а))
6.2
(37 отзывов(-а))
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 Больше

$860 CAD за 7 дней(-я)
(43 отзывов(-а))
5.2
(12 отзывов(-а))
4.9
(14 отзывов(-а))
4.2
(14 отзывов(-а))
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 Больше

$250 CAD за 1 день
(2 отзывов(-а))
3.5
(3 отзывов(-а))
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 за 7 дней(-я)
(1 отзыв)
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 Больше

$450 CAD за 5 дней(-я)
(1 отзыв)
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 Больше

$450 CAD за 5 дней(-я)
(1 отзыв)
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 Больше

$450 CAD за 3 дней(-я)
(2 отзывов(-а))
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 Больше

$630 CAD за 7 дней(-я)
(0 отзывов(-а))
0.0