Schedule your own reports

Can i in reporting services 200 create some application that loops through and generates the reporting services report and email to the recepiant I specify in the mini application. I do not want to schedule the job in reporting services as the person receiving the email will be different each time based on criteria. If anyone knows the syntax to generate a report and pass the parameters, email and format it would be much appreciated

Lee,

You can using the Reporting Service Web API or you can write .NET code to generate our report, connect with System.web.mail. to email it, and you can use the render of the response to give for different type whether it's HTML, EXCEL and etc...

Here's a URL to get you going:

http://www.codeproject.com/sqlrs/SQLRSViewer.asp