Export Of Data In The .CSV Format With Column Headings On Top
I'm trying to export data in the .csv format from a report (Crystal Reports XI Release 2). When I export the data, the heading appears in the first few columns on the left hand side (i.e. columns "A" thru "G") for every row, rather as a column heading on top. These header describe the data beneath it. I tried various combinations of export options. The file needs an extension .csv (or .xls) for the tool that uses the data. Any suggestions how I can accomplish this ?
Try using the Excel Data Only format. With this you will get an .xls extention and the coloumn headings will not be repeated with each new row.
Let me also check if there are any settings in CSV format to avoid the repeating headers.