Edit a data alert in Alert Designer

Applies to: ✅ SQL Server Reporting Services (2016) ❌ SQL Server Reporting Services (2017) ✅ SharePoint ❌ Power BI Report Server

For content related to previous versions of SQL Server Reporting Services (SSRS), see SQL Server 2014 Reporting Services.

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.

Note

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.

Screenshot of 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.

Edit a data alert definition in Data Alert Designer

  1. In Data Alert Manager, right-click the data alert definition that you want to edit and select Edit.

    The alert definition opens in Data Alert Designer.

  2. Update the rules, schedule settings, and email settings. For more information, see Data Alert Designer and Create a data alert in Data Alert Designer.

    Note

    You cannot choose a different data feed. To use a different data feed, you must create a new data alert definition.

  3. Select Save.

    Note

    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 Generate data feeds from reports (Report Builder and SSRS).

More questions? Try asking the Reporting Services forum