How to DELETE a standard report (that I created as test as administrator)?

First I try to just delete the report…
image

Then I try to edit “Is Standard” field…

image

image

If the UI will not allow deletion, you could delete the report manually from the server.

Here is an example SQL query, showing all ERPNext reports:

SELECT 
    name, idx, report_name, ref_doctype,
    reference_report, is_standard, module,
    report_type
FROM
    v13testdb.tabReport;

You can find the specific report, then delete from the database. As always, we should be careful when deleting using SQL (use transactions, take a backup first, etc.)

Finally, for standard reports, make sure you clean-up your App’s JSON (delete the report’s data files, if any)

1 Like