it has to be in columns, it's Excel. If your report is not in columns, the file won't be. Crystal will export the data based on what the report looks like.
Even then, it might get confused and not everything will line up in the correct column. Using the option to have a constant column width will get all the data to align correctly in the correct column, but you will end up with A LOT of columns as the column size becomes like a letter wide.
Again, Crystal is going to format the Excel file like your report, it won't magically put data into columns if they weren't in columns to start.
HTH
IP Logged
