Hi, I have a subscription in ssrs that sends an email to bunch of people every morning. But the issue si that I do not want an attachement in the email if the query does not return any values. I also want to change the subject line of the email that gets sent out. Is it possible to do this in SSRS via subscription?

To send report attachment only if data exists , Please follow this link . http://blogs.msdn.com/b/bimusings/archive/2005/07/29/445080.aspx To change the subject line of the email , You will have to configure it using "Get the value for database" option ensuring your query has own customised subject . select ID, EmployeeName , EmployeeName+' your Report ' as Subject from TableName Thanks . Rajkumar Yelugu

Thank you. But I am not confused about the steps to take. Is there anything else that can be done. Thank you.