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:
- Select .
- Right-click Command in the Selected
Tables area, then select Edit Command.
- 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.
- 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.
- Click OK.
- Repeat the above steps for each sub-report.
- From one of the sub-reports, click Formula Workshop from
the toolbar.
- Expand the Formula fields, then
click the Eventname field, and replace all
instances of Command.OIID with Command.ClassDescription.
- Click Save and close.
- Repeat the above 3 steps for each sub-report.
- Right-click Command in the Selected
Tables area, and then select Edit Command.
- In the Modify Command dialog box,
delete the following field (including the comma) from the Select statement,
and then click OK. EV.OIID,
- 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.
- Repeat the above 3 steps for each sub-report.
- Select .
- 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.
- Verify that the Database dialog box
displays the following message, and click OK.
- In the Enter Values dialog box, click OK.
- Select and save the report with the same file
name.
- When prompted to replace the file, click Yes.