SSRS Export to text format creates extra carraige return at the end of a file
-
Friday, February 08, 2013 3:51 AM
I have a report with a simple table. There is one header row and one data row. When I export it to at text file, the file has an extra carraige return at the end of it. Is there a way to prevent that?
The output is tab delimited text file. The data and the tabs are good. It is just that an extra carraige return is added to the bottom of the file.
Example:
23456789 01/18/2013 118.8100 PURCHASE 01/18/2013 02/07/2013;
56789456 01/10/2013 107.3500 PURCHASE 01/10/2013 02/07/2013;
69853698 01/30/2013 118.8100 PURCHASE 01/30/2013 02/07/2013;Has anyone ever run into this?
Thanks,
Sarah
Sarah B
All Replies
-
Friday, February 08, 2013 10:12 AM
Hi,
Try as per below:
1. select the Report
2. Press F4 and propery will be opened ( Remember the property of report not body)
3. In the property Pane make the 'ConsumeContainerWhitespace' to true.
Hope this will work.
Thanks,
Rana
-
Monday, February 11, 2013 2:48 AMModerator
Hello,
Do you means that the report gat an exact blank row after export to CSV? If so, this is a known issue and as per my knowledge, there is not fix relate to the issue, please refer to the following feedback. You can try the workaround as Robert post.
https://connect.microsoft.com/SQLServer/feedback/details/557655/ssrs2008-extra-blank-line-in-csv-files-created-by-csv-renderer-on-export-of-reportRegards,
Fanny Liu
If you have any feedback on our support, please click here .
Fanny Liu
TechNet Community Support- Proposed As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Thursday, February 14, 2013 1:41 AM
- Marked As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Friday, February 15, 2013 1:10 AM


