Here's the scenario: I created several reports in the production instance and the actions to include or force to an update set are not available for security purposes. I'm now needing to migrate the reports to another instance.
Solution:
Source instance:
1. Open sys_report table in list view and filter the reports you want to migrate.
2. Start at the top of the list and open the first record.
3. From the page header menu, choose Show Latest Update.
4. Copy the XML payload to Notepad++ and save it. (I saved it as the report name)
Destination instance:
1. Create an update set and set it to current. (I used Global scope)
2. Open sys_report table in list view.
3. Right-click on list header and choose Import XML.
4. Pick your file and import.
Make sure all the reports you're migrating are being captured in the update set. You probably won't want to go through this again...
Enjoy!
