Закрито

Advanced reporting in MS-Excel

Our data gets stored in SQL Server through a software and we have to provide daily, shift wise, weekly, monthly and yearly reports using that data. These reports have to be auto-emailed at given time every day. Till now I've been doing this myself using VBA but keep getting errors like "Query timeout", "Excel file you are trying to open is locked" etc and at times Windows Task scheduler or 3rd party scheduler doesn't work so reports are not generated. I need someone who is an expert in VBA and SQL both.

Навички: Crystal Reports, Excel, SQL, VB.NET

Показати більше: open locked file win32, open locked file, open locked access file

Про роботодавця:
( 0 відгуки(-ів) ) Gurgaon, India

ID проекту: #12166465

17 фрілансерів(-а) подали заявки на цю роботу; середня заявка - ₹3401

kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Webscrapping projects, hence i ca Більше

₹7222 INR за 3 дні(-в)
(66 відгуків(-и))
5.7
vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have excellent knowledge and experience of retrieving data from SQL, manipulate it and creating reports of these dat Більше

₹6000 INR за 3 дні(-в)
(31 відгуків(-и))
4.3
₹1300 INR за 1 день
(4 відгуків(-и))
4.0
₹1300 INR за 1 день
(3 відгуків(-и))
2.1
bhavinpokiya

Hi there, I’d like to be considered for this project. I’m a software developer with a strong background developing projects like All Lines Insurance Suits, Online Shopping, Library Management System, WCF services fo Більше

₹2777 INR за 9 дні(-в)
(0 відгуків(-и))
0.0
feminsaneesh

Sir, i am expert in reporting using crystal report and also once created u can mail it easily. i have done this work already in my project. but i am working in vb.net. please message me so that i can share my works.

₹1250 INR за 20 дні(-в)
(1 відгук)
0.0
hardevr

A proposal has not yet been provided

₹1250 INR за 3 дні(-в)
(0 відгуків(-и))
0.0
anandsabale

Hi, I work in MIS & Analytics Consulting and run a professional set up from Pune, India. I have worked extensively on Excel VBA and SQL while creating advanced reporting. Your issue about emailing could be solved Більше

₹1300 INR за 5 дні(-в)
(0 відгуків(-и))
0.0
RoxanneTimbas

I am hardworking, trustworthy and industrious type of person. I always make sure to meet deadlines. I never choose to do things later if I can finish them now. I am very resourceful and knows how to solve problems with Більше

₹850 INR за 1 день
(0 відгуків(-и))
0.0
₹1300 INR за 1 день
(0 відгуків(-и))
0.0
eknathkanade

Will do the project within 1 weak and give result with best of my knowledge and expreerince. i will assure about accuracy.

₹1300 INR за 1 день
(0 відгуків(-и))
0.0
tudormth2008

www.tstratulat.com/site1.html....d3.html....g4.html....question1.html....question2.html....question3.html

₹1500 INR за 0 дні(-в)
(0 відгуків(-и))
0.0
p9technologies

Dear friend, Can we built the application in ASP.NET instead of VBA achieving the same effect? I'm a 14+ years experienced professional developing application for windows and web platform using technologies such Більше

₹11111 INR за 15 дні(-в)
(0 відгуків(-и))
0.0
starangel2015

Hey There !! We have seen the job post of yours and very interested to start work with you as we have delivered out the similar kind of web applications and we completely understand the subject of yours and what is Більше

₹1300 INR за 1 день
(0 відгуків(-и))
0.0
Sundaram87

Hi We have done your requirements in many clients which will trigger mail in preset time. The same mail will have an attachment of excel sheet in your format. we have successfully implemented through sql only. we don Більше

₹1500 INR за 5 дні(-в)
(1 відгук)
0.0
mascotsoft4

Dear Client, Greeting of the day ahead !!! Thanks for providing us opportunity to place bid over the project and communicate with you. I am a serious bidder here and i have already worked on a similar project befor Більше

₹1750 INR за 6 дні(-в)
(0 відгуків(-и))
0.0
₹1300 INR за 1 день
(0 відгуків(-и))
0.0
warrenbain

I am a very experienced VBA developer with multiple projects completed in Access, Excel, Word, Project and Outlook. Of most relevance here would be work I did for an investment partnership to perform share analysis on Більше

₹15000 INR за 3 дні(-в)
(0 відгуків(-и))
0.0