Warning
Potential for Data Loss: The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure or unfamiliar with any complex steps detailed in this article, please contact Product Support Services for assistance.
Issue
Deleting reports built in Reports Builder using Building Operation WebReports
Environment
SmartStruxure Building Operation running Reports Server and Microsoft Report Builder
Cause
Reports built using SQL interface such as Microsoft Report Builder cannot be deleted using the Manage Reports in Building Operation WebReports
Resolution
Building reports on the SQL side must be deleted on the SQL side.
From the first screenshot below, you can see that when using WebReports, in the Manage Reports tab, custom reports which are made are considered System Reports and the Delete button is grayed out.
Here I have created Top Alarms Test 1 report, which has been selected.
Using SQL Server Management Studio, I penetrate to the tb.ReportGroups and see the isSystemOwned is True for the report Top Alarms Test 1
The isSystemOwned is changed to False for the selected report(s) Top Alarms Test 1
Viewing WebReports, in the Manage Reports tab, the Top Alarms Test 1 report is selected and the Delete option is available.
