Hi,

I have an rdl file having four text box arranged one below the other,but while exporting to CSV formate I faced two issues,

1) textboxname is coming in the CSV report,is any way to hide the text box name while exporting to csv format?

2)4 text boxes in 4 rows ie arranged one below the other in report designer,is coming as 4 columns in CSV format, I need four rows of data instead of that

Can You help?

Regards

Jon

http://blogs.msdn.com/b/robertbruckner/archive/2009/01/20/take-another-look-at-csv-rendering-in-rs-2008.aspx

For 1 I am not aware of this option.

Hello,

As for the first question, SQL Server Reporting Services render a report to CSV format with text boxes' name as columns' name. This behavior is by design. To workaround this issue, you can try to export the report to Excel and then rename the exported Excel file to .csv

Regards,
Fanny Liu