I have a report that when exporting to CSV format, is missing data rows. Oddly, when exporting to Excel format, the rows are present.

I have tried setting all data elements to "Output" versus "Auto" as this was stated as a possible solution for missing "columns", but I am missing rows.

Hi KL_Mast,

According to your description, when you export the report to Excel, all data are exported, but data rows are missing in CSV render, right?

In Reporting Services, DataElementOutput controls which report item data appears when a report is rendered by a data-only renderer (CSV or XML). If we set the value of this property as Auto, data renderer will think which should output. If the item is a text box with a constant value, such as a label, the item does not appear (NoOutput). In your scenario, please set the value of this property to Output, the data renderer will obey the setting, export the data element.

If issue persists, please try to create a simple report without any other settings, check if data row will missing when exporting to csv.

Reference:
DataElementOutput Element (RDL)

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

Best regards,
Qiuyun Yu

Are you sure report doesnt have any filter expressions set based on the Globals!RenderFormat.Name ?

Further to below advice I would suggesting checking the no. of records displayed in a page. Do you have records spread across multiple pages? That could be a possible reason as well......

Regards,

Faizan.

Qiuyun Yu,

Please read my entire post before replying. As stated, I had already changed all data elements to "Output" which did not resolve the issue.

Hi KL_Mast,

I may have a misunderstanding in my last reply.

In your scenario, have you tested other report in CSV and Excel render, you could use this way to narrow down the issue. If only this report comes across the issue, as Visakh mentioned, would you please check if you have specified filter expression for a dataset, data region or group based on Render Format Name built in field?

Best regards,
Qiuyun Yu