Using WP and current CiviCRM. We changed a default Report Template. Is there a way to restore a default report template?
Don't know a way through the UI, but I think you could do it through SQL.
The default reports appear to be defined in
xml/templates/civicrm_navigation.tpl, which in turn gets copied into
You might make a new instance with the default settings by copying the definition:
sql/civircm_data.mysqland search for
civicrm_report_instance. Find the
INSERTstatement which corresponds to your report.
- Copy the
INSERTstatement into a text editor.
1(unless you have a special/multidomain system; then adjust accordingly).
- Open your MySQL tool (e.g.
phpmyadmin) with an appropriate user+database.
- Paste and execute the
If you want to reset the existing report and know a bit of SQL, then you can massage the
INSERT and produce an
UPDATE for the existing report.