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.