Advanced reporting in MS-Excel

Closed

説明

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.

スキル: クリスタルレポートの専門家, エクセル, 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