November 30, 2010 at 9:39 am
I have an SSRS report that generates a progress report for parents with a simple .NET web application so the parent can log in and run the report for their student(s) on demand. We have a new request from some of our schools to have a single-click application for the principal to email all of the progress reports home where the parent has authorized email communication for their student. (We understand the security implications here and the parents have signed an authorization to allow us to do this.)
I can easily identify the students/parents in a simple query that would be emailed and then direct the rest to the principal to print and send home with the student. Since I'll be building a simple .NET web application for the principal to use, I'm thinking it best that the application simply calls a stored proc that does all of the work. I need to know how to call the SSRS report from a stored procedure, have it generate the report in .PDF format and then email it to the parent. I'm not sure how to call an SSIS package from a .NET application so I'm hoping that the stored proc route will work.
Ideas?
April 21, 2011 at 12:06 pm
Hello, this is very similar to something I need to accomplish, were you successful? I'm at the beginning of my search process...thanks.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply