Recover iReport template

The user has lost his iReport template file and do not want to start from the beginning.

1. In Navicat, open the table reporttemplate and identify which iReport it is.

The following query checks if the report contains subreports

SELECT
"Parent"."name" AS "Parent name",
"Parent".filename AS "Parent file",
"Child"."name" AS "Child name",
"Child".filename AS "Child file"
FROM
"public".reporttemplate AS "Parent"
INNER JOIN "public".reporttemplate AS "Child" ON "Parent".guid = "Child".parent_guid
WHERE
"Parent"."name" = 'Statistics - Land with Ordnance Details'

2. Copy the contents of the column jrxml to a new NotePad++ file and save as txt.
3. Change the file type in Windows Explorer to jrxml.
4. Open in iReport and make the changes.