IS Delete Custom Report

Version: Interprise Suite 2007 SP 5.3.4

Problem:

How to delete a custom created report in IS.

Solution:

IS does not provide the ability to delete a custom report.  Run the following SQL script to delete a report directly from the database.  As always, backup your database and review/test this SQL for safety.

declare @ReportDescription varchar(255), @ReportCode uniqueidentifier
set @ReportDescription = 'Your Report Description Goes Here'
select @ReportCode = ReportCode from SystemMenuReportDescriptionTemplate where ReportDescription = @ReportDescription
select * from SystemMenuReportDescriptionTemplate where ReportCode = @ReportCode

delete SystemMenuReportDescriptionTemplate where ReportCode = @ReportCode
delete from SystemUserRoleMenuReport where ReportCode = @ReportCode
delete SystemMenuReportTemplate where ReportCode = @ReportCode