SAP Knowledge Base Article - Public

1396697 - Crystal Report Date Field Is Exported With Text Formatting In Excel

Symptom

Some date/time fields, when exported to Excel, are exported with text formatting

Cause

You may be exporting a "Group Name Field", which by design, are text fields.

Resolution

In the report design layout, replace the "Group Name Field" with its original data table field.

Keywords

sorting, sort, string , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2