On a ssrs 2012 report server, I want to setup a data driven subscription where the results are emailed to various users. I would like to send the email messages to the various users by running a t-sql 2012 script and not actually generating an ssrs 2012 report. The email message will either contian the information that is incorrect and/or an attached excel spreadsheet will display the information that is not correct. The email messages will be sent to each person that is associated with the unique school.
Is this possible? If so, would you show me how to setup the data driven email messages by using t-sql 2012 only with code and/or links to refer to?
If this is not possible, would you tell me how to setup the ssrs 2012 report where a datadriven subscription is used and the report is emailed to the applicable user?