InfoSphere Enterprise Records, Version 4.5.1.3+              

Modifying main report 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 main report to make it compatible with Content Engine 4.0.x, complete the following steps:

  1. From main report, select Database > Database Export.
  2. Right-click Command in the Selected Tables area, and select Edit Command.
  3. In the Modify Command dialog box, modify the query by inserting TOP 1 after SELECT and remove the condition TRUE=FALSE And from the where clause in the query statement. Modifying the command will make it compatible with Content Engine 4.0.x.
    SELECT RF.DateCreated From RecordFolder RF where TRUE=FALSE And
    RF.DateCreated >={?start_date} And RF.DateCreated <= {?end_date}
    SELECT TOP 1 RF.DateCreated From RecordFolder RF where
    RF.DateCreated >= {?start_date} And RF.DateCreated <= {?end_date}
  4. ClickOK in the Modify Command dialog box.
  5. In the Enter Values wizard, provide appropriate values for the indicated parameters and click OK.
  6. Select Database > Verify Database.
  7. In the Enter Values dialog box, enter values for the fields, and click OK. To enter values correctly, follow the instructions in see Guidelines for entering values during report generation.
  8. Verify that the Database dialog box displays the following message, and click OK.
  9. In the Enter Values dialog box, click OK.
  10. Select File > Save to save the report template.


Feedback

Last updated: November 2010


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