Home > IT Answers > Microsoft Windows > Automation of SQL Report
Ramesh6363
5 pts.
 Automation of SQL Report
Microsoft Excel, SQL automation, SQL Database
Hi, I need to automate a certain report which we take from 2 different databases and paste the data in the Excel and send it to certain email IDs? can someone help me??

Software/Hardware used:
ASKED: July 25, 2008  12:11 PM
UPDATED: July 28, 2008  2:33 PM
RELATED QUESTIONS
Answer Wiki:
is it a simple or cross-tab report. if it is a simple report, it can be scheduled to run, and output be emailed to respective users. (or even sms also can be sent for a summary) but if it a cross tab, output in excel would not be possible.
Last Wiki Answer Submitted:  July 27, 2008  7:36 am  by  Jaideep Khanduja   8,200 pts.
All Answer Wiki Contributors:  Jaideep Khanduja   8,200 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

What version of SQL are you using? MS Reporting services will cover all of your requirements including export / automation / email, and this is bundled as std with SQL 2005

Squashjunkie
 325 pts.