I am having an issue with crystal reports changing the data field type based on the information in my .csv file. The field is for zip codes and when the report is generated for addresses in the US it defines the field as a number and Canadian zip codes result in a String[255] definition.
Is there a way that I can force Crystal Reports to always see that field as a string, or would I need to figure out some logic to handle both cases?
Is there a way that I can force Crystal Reports to always see that field as a string, or would I need to figure out some logic to handle both cases?