Description field in Subscriptions Table

The Description field in SQL Server 2005 Reporting Services just defaults to "Send e-mail to email@.domain.com" (obviously a dummy e-mail address) when you create an e-mail subscription. You cannot edit the Description when you select "Edit" beside a subscription.

The Description may be edited directly in the Subscriptions table under the ReportServer database but this is not end-user friendly.

I thought of using an add/update trigger to set the Description to the "Subject" out of the Extension Settings field. The Extension Settings field is XML so you would have to parse the Subject out of there first. The "Subject" is the e-mail Subject for the e-mail that is sent to the subscriber and it much more adequately describes the report.

My boss understood what I wanted to do but wanted to make sure in the industry literature that the product was not that lacking. Hard to believe that you cannot directly edit the Subscription Description through the web browser interface - would love for someone to prove me wrong.

Hello,

I'm wondering why you are wanting to change the description of a subscription? The description tells you what the subscription does, "Send email to..." for emails, or "Save as..." for files.

For adding a description to the report, you could set it in the properties of the report itself.

You can change the description directly, but it is reset after the subscription is updated.

Jarret

|||

Well, the reason that I want to change the Subscription Description is that I have ten of them that say the same thing - you cannot tell one from the other unless you click on edit. This is not the Report Description

What we are going to do is add a trigger that fires when an update or add takes place and we will set the description equal to the parsed subject from the Extension Settings. Well, unless someone comes up with a better idea.

Thank you very much for responding.

William

|||I have solved the problems by modifying the CreateSubscription and UpdateSubscription stored procedures so that they parse the Subject out of the ExtensionSettings column and then set the Description equal to the parsed substring.sql