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.
17 freelancers are bidding on average ₹3401 for this job
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.