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.
The reports being mailed out have to be small in size as most customers have a limit on the size of attachments which can be sent out on the company network. So only the main report sheets should be their in the report being sent. Data sheets have to be deleted.
Please share your skill set and detail of projects done in the past while responding. Would be great if you can share snapshot of reports created in Excel, if any.
If data is missing for any record/ hour/ date then it has to be copied from last populated record.
I am getting offers from people who are into writing project reports or articles. This is not about project report or data entry. This is a report which has to be made in MS-Excel using data stored in SQL Server. This project needs advanced coding in VBA and SQL.
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.