Automation of SQL Report

5 pts.
Tags:
Microsoft Excel
SQL
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??

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Squashjunkie
    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
    325 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following