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.
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.
Retrieving data ...