Thread: Delete, Overwrite, or Modify an existing Custom Report

I cannot find much on this in the forum or on the web. Is there a somewhat simple process or SQL to delete a specific custom report which has errors? (before I got here). If delete is not posisble without some purge of all reports then is there a way to overwrite the report with a new report of the same name? I tried the overwrite with a report of the same name and it didn't work.

Thanks for any help.
Bill

Can you access your database using SQL Server Management Studio? If so all of the custom reports are held in the table [CustomReport].

You can delete the report either by using the report id, like this:

Code:

DELETE FROM CustomReport WHERE CustomReportID=x

where x is the number of the report.

Or:

Code:

DELETE FROM CustomReport WHERE [Name]='xxx'

where xxx is the name of the report shown in the drop down list of reports.

Thank you. The only tool I have is what is in the storefront Admin Console under Configuration>Advanced>Run SQL.

I can Insert a new custom report. Would this suggested code to delete a report run from that panel?

Thanks again
Bill

Thank you. Used the Name and it works.
Bill