I have to first check the availibility of data related to parameter and then generate and delivery the report via mail. Hi Nilkanth, Do you mean you need to prevent report with empty data being sent? If so, one possible workaroud is to use data-driven subcription. I would suggest you read the blog How to prevent empty reports from being sent as part of SQL Reporting Services subscription at: http://blogs.msdn.com/b/bimusings/archive/2005/07/29/445080.aspx For more information about Data-Driven Subscription, please refer to: http://msdn.microsoft.com/en-us/library/ms159150.aspx Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Sure. Write a Windows Forms or ASP.NET application that uses the ReportViewer control. This way you can run any code you need to before launching the report. See Chapter 14 of my 7th Edition for a detailed discussion of this control.__________________________________________________________________ William Vaughn Mentor, Consultant, Trainer, MVP http://betav.com http://betav.com/blog/billva http://www.hitchhikerguides.net Hitchhikers Guide to Visual Studio and SQL Server (7th Edition) Please click the Mark as Answer button if a post solves your problem!

I am not sure if there is any option available with Reporting Services itself, but, did you try playing around with the job that the schedule creates? You can try creating a job that checks the data availability and kicks this(reporting services subscription) job based on the result of the first job.

Hello, I am managing schedule notifications sucessfully via mail. In one pf my Report delivery which is also parameterised I have to first check the availibility of data related to parameter and then generate and delivery the report via mail. I do not knpw where can I check the availibility of data for related parameter and then generate it other wise terminate the schedule for this session. Can any one tell me how can I achive this? I am using SQL Server 2008 Std. x64 edition. Nilkanth S. Desai