I have a SSRS report that retrieve it information from a table. This table gets truncate and repopulate every time when key value is change. This process is being done via a stored procedure because it will be easy for easy to modify in the future.
I would like to know if the following can be done:
1.Can the SSRS report for a Stored Procedure?
2.If it can be call, how to write it to a file with the key value as the file name with a specific path?
3.And the last step is the email out with a body in the email and attachment? The email is going to the key value (email address). Is there an enough time between creating the file and sending the email or should it create all the files first then email. We will be using Database Mail on SQL Server.
Version of SQL Server is 2008.