Print Page | Close Window

Access / Excel field format incorrect

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14626
Printed Date: 28 Apr 2024 at 10:56am


Topic: Access / Excel field format incorrect
Posted By: obeone
Subject: Access / Excel field format incorrect
Date Posted: 09 Oct 2011 at 4:34pm
Hello Everyone,
 
Hope someone can help me, I'm using Crystal Reports v10 with a simple report that gets data from a MS Excel 2007 spreadsheet. All the cells in the spreadsheet are TEXT format, but when I create a new report in CR10, and link the spreadsheet, CR10, insista on setting any field which contains numbers to a numeric field type.
 
Would anyone know how to change or stop CR10 from changing field types?
 
"Format Field" does not allow me to change the type from Numeric to Text?
 
Cheers


Print Page | Close Window