NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
Follow the steps below to recover the iReport template.
<ol>
<li>In case the report has subreports and those need to be changed, it is important 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"INNER JOIN "public".reporttemplate AS "Child" ON "Parent".guid = "Child".parent_guidWHERE"Parent"."name" = 'Statistics - Land with Ordnance Details'</pre>[[Image:Recover ireport.png|900px|center]]<br/><li>In Navicator pgAdmin3, open the table ''reporttemplate'' and identify which iReport it isthe one for which the file is missing. Reports can be identified by their name.</li><li>Copy the contents of the column ''jrxml'' of the '''parent''' and/or '''child/subreport''' report to a new text file using e.g. NotePad++ file and save as .</li><li>'''Delete''' the '''double''' quotes at the very beginning '''txtand'''end of the file.</li><li>Change Save it as a '''.jrxml''' file: Click '''Save as'''.: Enter the old file name with the extension .jrxml: Select '''All types (*.*)''' in the Save as type field).: Save the file in Windows Explorer to the folder '''jrxml'C:\IMSMAng\iReport\Templates''.</li><li>Repeat step 3 - 5 for each iReport that needs to be recovered.<li>Open the saved file(s) in iReport and make the required changes.</li> {{Note | If there are subreports, the report will not run inside iReport, as it will not find the subreports(s) - unless all the subreports are also saved as .jrxml files and the references from the main to the subreports are updated. Contact your [[Information Management Team | GICHD IM advisor]]in case of questions on this.}} <li>'''[[Manage Report Templates in IMSMA | Re-import]]''' the changed iReporttemplate into {{IMSMANG}}.</li>
</ol>
{{NavBox HubHowTo Standardizing Data Analysis and Information Reporting}} [[Category:NoPublic]]
[[Category:NAA]]