NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
[[Image:IReport list.png|500px|center]]
The user has lost his an iReport template '''file ''', but still has the imported template inside IMSMA. The user wants to make changes to the template in iReport and do not want therefore needs to start from recover the beginningfile.The steps to do that are the following:
<ol>
<li>In Navicator pgAdmin3, open the table ''reporttemplate'' and identify which iReport is the one for which the file is missing. Reports can be identified by their name.</li><li>In case the report has subreports and those need to be changed, it isimportant to also locate the subreports.</li>: The following query checks if the report contains subreports(enter the correct report name in the WHERE clause of this query)
<pre>
SELECT
"Parent"."name" AS "Parent name",
"Parent".filename AS "Parent file",
"Parent".jrxml AS "Parent JRXML",
"Child"."name" AS "Child name",
"Child".filename AS "Child file","Child".jrxml AS "Child JRXML"
FROM
"public".reporttemplate AS "Parent"
"Parent"."name" = 'Statistics - Land with Ordnance Details'
</pre>
<li>Copy the contents of the column ''jrxml'' (of the parent and/or child report, as required) to a new NotePad++ file , '''remove the double quotes''' at the very beginning and end of the file, and save it as a '''txt.jrxml'''.</li><li>Change the file type in Windows Explorer to (click '''Save as''', enter a file name with the extension .jrxml, and select '''All types (*.*)'''in the save as type field).</li><li>Open the saved file in iReport and make the required changes. Please note that if there are subreports, the report will not run inside iReport, as it will not find the subreports(s) - unless all the subreports are alos saved as .jrxml files and the references from the main to the subreports are updated. Contact VIE in case of questions on this.</li><li>As required, re-import the changed iReport template into IMSMA.</li>
</ol>