InfoSphere Enterprise Records, Version 4.5.1.3+              

Modifying sub-reports query (V3.7 to V4.5.1 only)

You can modify the Crystal Reports query of the main report to make it compatible with Content Engine.

To modify the query of the sub-reports to make it compatible with Content Engine 4.0.x, complete the following steps:

  1. Select Database > Database Expert.
  2. Right-click Command in the Selected Tables area, then select Edit Command.
  3. In the Select statement, add the EV.ClassDescription field after the EV.OIID field, and then click OK. When editing this field, be sure to apply the appropriate syntax required by the SQL statement.
  4. In the Enter Values wizard, provide appropriate values for the indicated parameters. To enter values correctly, follow the instructions in see Guidelines for entering values during report generation.
  5. Click OK.
  6. Repeat the above steps for each sub-report.
  7. From one of the sub-reports, click Formula Workshop from the toolbar.
  8. Expand the Formula fields, then click the Eventname field, and replace all instances of Command.OIID with Command.ClassDescription.
  9. Click Save and close.
  10. Repeat the above 3 steps for each sub-report.
  11. Right-click Command in the Selected Tables area, and then select Edit Command.
  12. In the Modify Command dialog box, delete the following field (including the comma) from the Select statement, and then click OK. EV.OIID,
  13. In the Enter Values wizard, provide appropriate values for the indicated parameters and click OK. To enter values correctly, follow the instructions in see Guidelines for entering values during report generation.
  14. Repeat the above 3 steps for each sub-report.
  15. Select Database > Verify Database.
  16. In the Enter Values dialog box, enter values for the fields, and click OK. To enter values correctly, follow the instructions in Guidelines for entering values during report generation.
  17. Verify that the Database dialog box displays the following message, and click OK.
  18. In the Enter Values dialog box, click OK.
  19. Select File > Save As and save the report with the same file name.
  20. When prompted to replace the file, click Yes.


Feedback

Last updated: November 2010


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