THIS TOPIC APPLIES TO: SQL Server Reporting Services (2016) SQL Server Reporting Services (2017) SharePoint integrated mode Power BI Report Server
For content related to previous versions of SQL Server Reporting Services, see SQL Server Reporting Services 2014.
You open the data alert definition that you want to edit from Data Alert Manager. Only the user that created the alert definition can edit it. For more information about opening Data Alert Manager, see Manage My Data Alerts in Data Alert Manager.
Reporting Services integration with SharePoint is no longer available after SQL Server 2016.
The following picture shows you the context menu on a data alert in Data Alert Manager.
The following procedure includes the steps to open the alert definition for editing in Data Alert Designer from Data Alert Manager.
To edit a data alert definition in Data Alert Designer
In Data Alert Manager, right-click the data alert definition that you want to edit and click Edit.
The alert definition opens in Data Alert Designer.
You cannot choose a different data feed. To use a different data feed, you must create a new data alert definition.
If the report has changed and the data feeds generated from the report have changed the alert definition might no longer be valid. This occurs when a column that the alert definition references in its rules is deleted from the report or changes data type or the report is deleted or moved. You can open an alert definition that is not valid, but you cannot resave it until it is valid based on the current version of the report data feed that it is built upon. To learn more about how data feeds are generated from reports, see Generating Data Feeds from Reports (Report Builder and SSRS).
More questions? Try asking the Reporting Services forum