I am using Crystal Report ver 2011, I have an excel file and text tab delimited version of the same excel file.
I want to use this excel file or text tab delimited version as data source for my Crystal report.
Problem is that excel file have one filed that has numbers in and I need it in Crystal report as text field. I am using it for connection with another table in report.
How to get this excel file as data source in crystal and change number field to text type filed in Crystal report?
I need some way that will ask not to much of playing with and changing excel file or at least very little.
I know for method of putting some alphabet character in filed at the end or beginning of the filed or putting comma as first character in the filed.
Is there any other way to get excel number filed converted to text type filed in Crystal report. I tried to reformat it as text field but it is not working again in crystal I see it as number type field when I set up new connection to that file.
With text file tab delimited is there any other way except setting ODBC and system DNS