NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
[[Image:IReport list.png|500px600px|center]]The user has lost an This page describes how to solve the scenario:# the iReport template '''file''', but still has been lost# the imported template has been published inside IMSMA. The user wants to make changes to the template {{IMSMANG}} so it is stored in iReport and therefore needs to recover the filedatabase. The steps to do that are the following:
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)
"Parent"."name" = 'Statistics - Land with Ordnance Details'
</pre>
[[Image:Recover ireport.png|900px|center]]<br/><li>In Navicat or 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>Copy the contents of the column ''jrxml'' (of the '''parent ''' and/or '''child /subreport''' report, as required) to a new text file using e.g. NotePad++ file.</li><li>'''Remove ''' the '''double quotes''' quotes at the very beginning '''and ''' end of the file.</li>
<li>Save it as a '''.jrxml''' file
: Click '''Save as'''.
: Enter a the old file name with the extension .jrxml: Select '''All types (*.*)''' in the Save as type field).: Save the file in the folder ''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 VIE your [[Information Management Team | GICHD IM advisor]]in case of questions on this.}}
<li>As required, re'''[[Manage Report Templates in IMSMA | Re-import ]]''' the changed iReport template into {{IMSMANG}}.</li>
</ol>
{{NavBox HubHowTo Standardizing Data Analysis and Information Reporting}} [[Category:NoPublic]][[Category:NAAVIE]]
