Hi All,
I need to generate a CSV file from crystal reports. In the report I have a header row for column headers and data in 2 details sections. When I export it to CSV it doesn't keep the required formatting. Data from both the details sections comes in one single row.
I insert a formula for newline character at the end of first details section. After this data from details section comes in 2 different rows but rows from 2nd section appears shifted to the right.
Though it looks alright in EXL/TXT/PDF formats.
Expected is
Header1, header2, header 3
row1,row1,row1
row2,,row2
row3,row3,row3
row4,,row4
now appears as
Header1, header2, header 3
row1,row1,row1
row2,,row2
row3,row3,row3
row4,,row4
I am using crystal reports 2013 sp1. Is it version specific issue?
Is there a way to correct it?
thanks in advance