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:
- From main report, select .
- Right-click Command in the Selected
Tables area, and select Edit Command.
- 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}
- ClickOK in the Modify
Command dialog box.
- In the Enter Values wizard, provide appropriate values
for the indicated parameters and click OK.
- Select .
- 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.
- Verify that the Database dialog box
displays the following message, and click OK.
- In the Enter Values dialog box, click OK.
- Select to save the report template.