You can use the UpdCRDateFields tool to automatically convert all DATE and TIME fields to DATE/TIME fields in "Crystal Reports" reports, for either an Adelia environment or a directory containing .RPT files.

As well as converting the DATE type to the DATE/TIME type, the field formatting attributes are also changed so that only the DATE field is displayed.

As well as converting the TIME type to the DATE/TIME type, the field formatting attributes are also changed so that only the TIME field is displayed.

In addition, the tool generates an execution report in text format. This report:

• lists the reports processed,

• shows the following details relating to the modified reports:
• Names and locations of the converted fields (subreport or _Main report name),
• List of named formulas that must be checked to ensure they operate correctly after the fields have been converted.
• List of formatting formulas that must be checked to ensure they operate correctly after the fields have been converted (this list is presented with a Crystal Reports RDC runtime rather than a .NET runtime).

Tool syntax:

Updating an Adelia environment:

UpdCRDateFields /ENV:EnvName  /OUT:OutputFileName

Example:

> UpdCRDateFields /ENV:KBADEL /OUT:c:\tmp\report.txt

Updating reports (.RPT files) in a directory:

UpdCRDateFields /DIR:DirName  /OUT:OutputFileName

Example:

> UpdCRDateFields /DIR:d:\appli\objects /OUT:c:\tmp\report.txt

Note: As a precautionary measure, we recommend backing up the Adelia environment before using the UpdCrDateFields tool.

When the tool is run for a directory, the original versions of the modified RPT files are stored in the %TEMP% directory.

↑ Top of page