Copy reports from Test to Prod

Hi Chris,

Reports are stored in the saved_reports table in the database. As long as your test and prod instances have the same custom fields, relationships, and modules created, then you should be able to extract the desired reports from the database table in test and insert them on prod with no issue.

Chris Bourgeois,

One of the features of a SugarLabs tool that I built years ago called "SystemData" allows to export/import Reports (and many other System Data entities). You can find the latest version here: https://github.com/sugarcrmlabs/SystemData 

It is an as-is tool (without support/maintenance) but definitely worth looking into it.

As a side note, you might have Teams unique combinations assigned to a Report record, which might need to be exported together with the record as well. This tool does that part as well, if you do export/import Teams as well.

Cheers

Chris Bourgeois,

One of the features of a SugarLabs tool that I built years ago called "SystemData" allows to export/import Reports (and many other System Data entities). You can find the latest version here: https://github.com/sugarcrmlabs/SystemData 

It is an as-is tool (without support/maintenance) but definitely worth looking into it.

As a side note, you might have Teams unique combinations assigned to a Report record, which might need to be exported together with the record as well. This tool does that part as well, if you do export/import Teams as well.

Cheers