I forget exactly how to do this, but if you look at the cell formatting properties, I think there is a way to force a column to be a string. If that doesn't work, temporarily overwrite the first few rows with string data. I'm guessing that CR probably just looks at the first few rows when deciding the columns data type. Then create the report from the new data and go back and change it later on once it appears to work.