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, excel macro write xml file, excel macro read text file, excel macro browse print file path, excel vba write xml file, file manager web open source, excel import parse resx file, file host script open source, web file management system open source, open locked file, excel vba create xml file, excel j2me read xls file, convert excel csv tab delimiter file cnet, network file permission error trying open file created, open locked access file

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
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
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
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
hardevr

A proposal has not yet been provided

₹1250 INR за 3 дні(-в)
(0 відгуків(-и))
0.0
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
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
₹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
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
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
₹1300 INR за 1 день
(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
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