Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SunnyDee
Yak Posting Veteran
79 Posts |
 Posted - 2013-10-30 : 14:29:11
|
| I am trying to generate a report which can then be saved as a text file with a pipe delimiter. Since SSRS does not have a text file output option, the users are saving the report in Excel and then saving to a text file.The report design is one field in a one column tablix that has all of the fields strung together with the "|" separating each field. It looks fine when opened in Excel. The issue is the line feeds and white spaces.The first version of the report did not have line feeds. I added a trim function and the Chr(10) function. This resulted in extra white spaces.How can I get the report to export to Excel with the correct formatting? And I know this would be better in SSIS. Due to business reasons, the file must be accessible via a SSRS report. Thanks! |
|
|
|
|
|
Exporting to Text File From SSRS