Report Subscription Issue
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?
October 26th, 2010 9:16am
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
October 26th, 2010 11:06am
Thank you. But I am not confused about the steps to take. Is there anything else that can be done. Thank you.
October 28th, 2010 3:23pm