We were given a need to output an SSRS report as a flat file .txt format and wondered if that was possible and if so, how? Thanks.

1. If possible, save the report in word document and later manually save it into .txt file

2. If you are just getting data from SQL and need output in txt file, use SSIS.

In SSIS, use OLE DB as source. Use your underlying data source query and use Flat file as destination and generate txt file in output.

3. Few more options provided in below link:

https://go4answers.webhost4life.com/Example/get-report-text-format-ssrs-81251.aspx

SSIS is not an option because the report will be run by a user in a browser.