Unsuppress Run Custom Report Warnings

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

There are two warning dialog boxes for custom reports. This topic describes how to unsuppress the display of these boxes in SQL Server by using SQL Server Management Studio.

By default, the Run Custom Reports dialog box appears before a custom report runs. If you select the Please don't show this warning again check box, the dialog box will no longer appear. Also by default, the Run Custom Reports dialog box appears when you open a custom report and then click a link to open another custom report. This dialog box displays the fill path to the drill-through custom report file. If you select the Please don't show this warning again check box, the dialog box will no longer appear.

Using SQL Server Management Studio

To unsuppress the main custom report warning dialog box

1. Connect to <server>\<share or drive>\Documents and Settings\<UserProfile>\Application Data\Microsoft\Microsoft SQL Server\130\Tools\Shell\reports.xml.

2. Right-click reports.xml, and then click Edit.

3. Change <SuppressWarning>true</SuppressWarning> to <SuppressWarning>false</SuppressWarning>.

4. Restart SQL Server Management Studio.

To unsuppress the drill-through custom report warning dialog box

1. Connect to <server>\<share or drive>\Documents and Settings\<UserProfile>\Application Data\Microsoft\Microsoft SQL Server\130\Tools\Shell\reports.xml.

2. Right-click reports.xml, and click Edit.

3. Change <SuppressDrillthroughWarning>true</SuppressDrillthroughWarning>to <\SuppressDrillthroughWarning>false</SuppressDrillthroughWarning>.

4. Restart SQL Server Management Studio.

See Also

Custom Reports in Management Studio
Add a Custom Report to Management Studio
Use Custom Reports with Object Explorer Node Properties