Dear All,

I developed one dynamic column (matrix) report. while export to excel it 's show same output as SSRS have. but while exporting CSV pivot column not coming as same as Excel and SSRS screen. data is moving to rows.

could you please guide me how resolve this issue.

please see below screen shot :--

Hi Akhil, 

According to your description, when exporting to CSV and EXCEL, the two layouts have different behavior, right? 

In Reporting Services, when exporting to excel, the matrix and table will be rendered with layout in BIDS. But when exporting to CSV, the matrix will be rendered as a table. It is because CSV rendering extension renders reports as a flattened representation of data from a report in a standardized. So CSV display data to one-dimensional. This working mechanism is by design in Reporting Services. 

Reference:
Exporting to a CSV File (Report Builder and SSRS)

If you have any question, please feel free to ask. 

Regards, 
Shrek Li

Thanks Shrek Li !!

I have one question

as per your reply we can not achieve same layout as BIDS in export CSV. it is limitation

Regards,

Akhilesh