Talk with the Author
 Crystal Reports Forum : General Information : Talk with the Author
Message Icon Topic: Importing Excel - Changes from genl to num/txt Post Reply Post New Topic
Author Message
pduw123
Newbie
Newbie
Avatar

Joined: 09 May 2009
Online Status: Offline
Posts: 2
Quote pduw123 Replybullet Topic: Importing Excel - Changes from genl to num/txt
    Posted: 29 May 2009 at 4:01pm
I have a column in an Excel spreadsheet which is defined as data type 'General'.  When I import the xls to CR the column data type changes to data type 'number' if the first spreadsheet field is numeric and 'text' if it is non-numeric.  When the field is defined as one it doesn't display the other type field contents once it is imported so i get either numeric values or non-numeric values only.  I need both to report on both numeric and non-numeric data.  I tried changing the datatype to text in the excel file but it did no good.  How can I persuade CR XI or 2008 to recognize both numeric and non-numeric data?
Thanks
Paul
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.