IBM Enterprise Records, Version 5.1.+            

Creating a report

IBM® Enterprise Records includes more than 41 reports that provide a statistical view of different activities performed by users.

An administrator can create a new report, in addition to those included in IBM Enterprise Records. For a list of all available reports, see Report configuration and prerequisites.

To create a report, complete these general steps:

Create new report criteria

Before you create new report criteria, review the ReportDefinitions.xml file because you can use existing criteria for your new report.

To create new report criteria

  1. On the Content Engine server, open Enterprise Manager (EM).
  2. Create a new Content Engine property template in Enterprise Manager, using the Create a Property Template Wizard. For details about creating the property template, see the Content Engine online help and the context-sensitive help in the wizard.
  3. After you complete the wizard, navigate to the Other Classes/Custom Objects/Report Holdings in Enterprise Manager.
  4. Add the new property template in the Report Holdings class.
  5. Add the new criteria to the ReportDefinitions.xml file. See Modifying ReportDefinitions.xml.

Design a new report

  1. On the reports server, start Crystal Reports Designer.
  2. Select the Create a New Report option to invoke the Reports Creation Wizard.
  3. When the Wizard prompts you to create a connection between the database and Crystal Reports, select Create New Connection - JDBC to connect to the Content Engine database.
    Note: The connection settings are configured in the CRConfig.xml file during IBM Enterprise Records installation. See the IBM Enterprise Records Installation and Upgrade Guide.
  4. When the Wizard prompts you, enter the following:
    • Data Source (the object store you need to access).
    • User ID and password of an account with access rights to the Data Source.
  5. After the wizard connects to the Data Source and displays a list of all of the classes in the object store (such as ElectronicRecords, Events, Folders, and others), select one or more of the classes, as needed for your new report.
  6. Create a query based on the classes you selected in the wizard.

    If you want to include new criteria, enter parameter fields that exactly match the symbolic names you created for the new criteria.

    Your report will use the query to generate report results. For more information about using Crystal Reports Designer, refer to the Crystal Reports Designer online help.

  7. Save the new report in the same location as the Crystal Reports Application Server, using one of the following naming conventions:
    • "Summary report name.rpt"
    • "Detailed report name.rpt"

    For example, if the report name is "classification action" then save the report as "Summary classification action.rpt" or "Detailed classification action.rpt." IBM Enterprise Records requires each report to have two versions: Summary and Detailed. Therefore, you must create two Crystal Report templates for the same report name: one for the Summary report and the other for the Detailed report.

    The path for the location of the Crystal Reports Application Server is:

    <install drive>:\Program Files\Business Objects\Business Objects Enterprise 12.0\Samples\En\Reports.
  8. Exit from Crystal Reports Designer.

Modify ReportDefinitions.xml

  1. On the web application server where IBM Enterprise Records runs, use an XML editor to open the ReportDefinitions.xml file, located in the configuration folder for IBM Enterprise Records. The default location is <ier_install_path>\Config.
  2. Add a new value to the array that corresponds to the data model used in your FPOS, and make other required changes to the xml file. For more information, see Adding a report to ReportDefinitions.xml.
  3. Restart the web application server where IBM Enterprise Records runs for the changes to take effect.

Add report to PRB file

  1. On the server where IBM Enterprise Records is installed, browse to <ier_install_path>\RecordsManager\WEB-INF\lib.
  2. Use a text editor to open the server.strings.<language>.<country>.prb file for your environment in the p8RecordsManagerResources.jar.
  3. Enter the following text strings in the PRB file:
    • localizationKey="server.report_title.n"=report name, where report name is the title of the report that IBM Enterprise Records displays.
    • localizationKey="server.report_desc.n"=description, where description is text that IBM Enterprise Records displays, briefly describing the purpose of the report.

      n is the id value specified in the data model array in ReportDefinitions.xml. For more information, see Adding a report to ReportDefinitions.xml.

  4. Redeploy the IBM Enterprise Records application. For information about redeploying IBM Enterprise Records, see the IBM Enterprise Records Installation and Upgrade Guide.
  5. Restart the web application server where IBM Enterprise Records runs for the changes to take effect.


Feedback

Last updated: August 2011
create_report.htm

© Copyright IBM Corporation 2011.
This information center is powered by Eclipse technology. (http://www.eclipse.org)