Wednesday, February 18, 2015

Capital projects Unable to open/edit report templates

If you want to edit or change reports, let me give you some basic information which will help you customize them as per your choice.
Our report templates are based on jasper reports. For more information on jasper reports, refer to the following :
Our templates are populated via DQL queries in the template which are processed through a custom datasource(refer to the tutorials to understand better) that we provide to our template.
You can use the iReport designer to edit the report templates. The iReport designer version you have to use will depend on the version of the jasper reports jar that is being used in your setup.
To find out the jar version, look for "jasperreports" within the Documentum\<jboss version>\server\DctmServer_MethodServer\deploy\ServerApps.ear\DmMethods.war\WEB-INF\lib.
The version number stated there will determine what iReport Designer is compatible with EPFM.eg. jasperreports-3.7.4.jar will use iReport Designer 3.7.4.
To edit the template, you can export the template to any temp location. It will be exported in the form of a .ecsfr file. You can simply open this file using any archiving/compression(like winzip or winrar) tool to view its contents.
Look for the .jrxml file within the .ecsfr file.for eg. "Late-PendingTransmittals_001.jrxml". The .jrxml file is the report template which is populated with data.It is basically the design of the report.
It is this .jrxml file that you will need to edit using the iReport Designer.
The iReport designer will basically have to be used for designing the layout of the report. Refer to existing report templates to see how they use DQLs to populate themselves.

Once you've created a proper report template, package in a .ecsfr file(basically zip it using winzip/winrar and change the extension to .ecsfr), once this is done, import the report template.

No comments:

Post a Comment