SSRS CSV Export

(0) Share

Report

Posted on by JGarcia123

516

I am developing a comma delimited export from an SSRS report. The SSRS report design consists of two lines per record. The first line is in a group header and the 2nd is the detail line. The report displays on screen properly and exports into excel file as two lines per record.

However when exported directly into a CSV file, the result is a single line per record. Is there any way to force the CSV export to produce two lines. Is there a flag or other item that can be embedded in the report that would force the carriage return?

Please advise. Thank you.

*This post is locked for comments