1942272 - Incorrect data type when reporting off a MS Excel spreadsheet in Crystal Reports

Numbers displays as string.
Date displays as string.
Columns defined as number or date in a MS Excel spreadsheet, are defined as string data type in Crystal Reports.

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

CR, incorrect data type, numeric, number, date , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Visit SAP Support Portal's SAP Notes and KBA Search.