CODEWITHSUNDEEP
sql-serverreporting-services
aman
aman

Reputation: 3

SSRS data fetch and email

I want to know how can we send automatically email of the 'select' query results of User database with sql server. As i have to send few reports on daily basis to HO for as per status reports. Kindly help me through..

Thanks

Upvotes: 0

Views: 77

Answers (1)

Abhishek
Abhishek

Reputation: 2490

You should look into Subscriptions and Delivery part of SSRS. Link here - Subscriptions In delivery scenarios look for E-mail. Also if you are sending those reports to a fixed HO then normal standard subscriptions will do for you, else if your HO changes based on sql query then look for data-driven subscriptions.

Upvotes: 1

Related Questions