SSRS: Email Report Subscriptions and the Greyed Out To Field Fiasco

You are creating a report subscription to Email, then you notice the To field is greyed out and you are unable to edit.   We assume you have setup your Reporting Services SMTP successfully because the Email option was available when you created your subscription.
Locate your RSReportServer.config file on the server where Reporting Services is installed.   Take a backup of this file and keep the backup in a safe place.    Now edit the RSReportServer.config file and search for the tag SendEmailToUserAlias – change the value from True to False so this line should look as follows.
<SendEmailToUserAlias>False</SendEmailToUserAlias>
Once edited, save the RSReportServer.config file.  There is no need to restart your Reporting Service service.  Try creating your report subscription to Email again.    The To field should now be unlocked and editable.

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s