How to export/import custom reports

[jmichiels]

Hello,

I have a lot custom reports and I like to make a backup or export report settings (not the results).
How can I do that?

[Susan_A · Accepted solution]

You can either:

• Copy the SQL queries of the individual reports. Hit the pencil shaped edit button next to the report under Reports\View All Reports and copy the SQL statement at the bottom of the report builder.
  
• Export all custom reports at once by following these instructions. This will only work if your database is hosted in SQL Server.
  
• Back up your entire database by following these instructions. All reports are stored in the database. If you have a database backup, you have a backup of your reports as well.