Exporting SSRS Report to Text

Hi callenbkd ,

Thank you for sharing the details.

The behavior you are seeing is expected when exporting SSRS reports to Text/CSV format. The Text renderer does not preserve the visual layout of the report. Instead, it exports data based on the tablix row and column structure, which can cause header elements and detail rows to appear on the same line if they belong to the same data region.
For scenarios where a specific fixed-width text format is required, the recommended approach is to generate the output as one concatenated field per row, for example, a Record column created using expressions or SQL logic. The report can then use a single column tablix bound to that field so that each dataset row corresponds to exactly one line in the exported text file.
Based on the example you provided, restructuring the report to follow this pattern similar to your UNION/concatenated record example would be the most reliable way to ensure the exported file matches the expected text format.

Best Regards,
Chaithra.