Does anyone know how to copy a report form one instance of Sugar to another?
I've attempted to find where Sugar stores the reports but have been unsuccessful so far.
Does anyone know how to copy a report form one instance of Sugar to another?
I've attempted to find where Sugar stores the reports but have been unsuccessful so far.
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.
The Reports module only need a few things to be im- and exportable.
For versions 9 and 10 I created a little install package containing 4 source files to add following funtionality to the reports module:
The package is installable and can be deinstalled after successful export/import of reports.
Harald Kuske
Principal Solution Architect – Professional Services, EMEA
hkuske@sugarcrm.com
SugarCRM Deutschland GmbH
The Reports module only need a few things to be im- and exportable.
For versions 9 and 10 I created a little install package containing 4 source files to add following funtionality to the reports module:
The package is installable and can be deinstalled after successful export/import of reports.
Harald Kuske
Principal Solution Architect – Professional Services, EMEA
hkuske@sugarcrm.com
SugarCRM Deutschland GmbH