Skip to Content
0
Former Member
Dec 17, 2014 at 10:11 AM

Crystal reports exports to CSV from multiple details section

371 Views

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