Summary:

Sage CRM does not currently have a user interface option for removing report categories. A user may have a requirement to remove a report category created in error, or to delete one that is no longer used.

Report categories can be removed by running the following SQL, then carrying out a metadata refresh:

declare @targetCategory nvarchar(120)
set @targetCategory = N'OLD REPORT CATEGORY'

-- Reassign existing reports to the General category
update Custom_Reports set Repo_Category = N'General'
where Repo_Category = @targetCategory

-- Remove the report group
update Custom_Captions set Capt_Deleted = 1
where Capt_Code = @targetCategory and Capt_Family = N'ReportCategory' and Capt_FamilyType = N'Choices'

update Custom_Captions set Capt_Deleted = 1
where Capt_Code = @targetCategory and Capt_Family = N'ReportCatDesc' and Capt_FamilyType = N'Tags'

update Custom_Tabs set Tabs_Deleted = 1
where Tabs_Caption = @targetCategory and Tabs_Entity = N'ReportsTabGroup'
go