Guys, I currently am using Crystal 11 Professional. I am trying to export a very simple report to a comma delimited file. But when I opened up the report it is showing extra commas. Here's how the report look like:
Group Header 1 InvoiceNo InvoiceDate blankspace Cust ID
Detail CustPO BlankSpace ItemID
I supressed all other sections. 1 problem is that when I export this to comma delimited (.csv) straight from crystal the information will wrap. So CustID is not the end of the first row - rather CustPO is showing next to Cust ID and all other information from the detail section. Basically the end result should look like:
Inv123,092506,,12345
ABC,,ItemXXX
Inv456,092406,,13578
XYZ,,ItemYYY
and it is not. The ABC will go right after 12345, etc.
I then tried exporting it to excel first and then save it as comma delimited which seem to work. However, I found out that I'm getting extra commas because the number of columns on the odd rows don't match with the even row. Thus, by default it's adding another blank column on the even row.
Any ideas will be highly appreciated. Thanks.
DT
Group Header 1 InvoiceNo InvoiceDate blankspace Cust ID
Detail CustPO BlankSpace ItemID
I supressed all other sections. 1 problem is that when I export this to comma delimited (.csv) straight from crystal the information will wrap. So CustID is not the end of the first row - rather CustPO is showing next to Cust ID and all other information from the detail section. Basically the end result should look like:
Inv123,092506,,12345
ABC,,ItemXXX
Inv456,092406,,13578
XYZ,,ItemYYY
and it is not. The ABC will go right after 12345, etc.
I then tried exporting it to excel first and then save it as comma delimited which seem to work. However, I found out that I'm getting extra commas because the number of columns on the odd rows don't match with the even row. Thus, by default it's adding another blank column on the even row.
Any ideas will be highly appreciated. Thanks.
DT