• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2890
  • Last Modified:

SSRS: Exporting to a Flat File


Is it possible to export a SQL Reporting Services (SSRS) report to a flat-file rather than a comma-delimited or tab-delimited file?

1 Solution
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
The term 'flat file' means any .txt or .csv that contains data, with absolutely no formatting.
This would include comma-delimited, tab-delimited.

So ... what exactly are you trying to pull off here?
You really need to have a delimiter, Or place each data per row.
TBSupportAuthor Commented:

I'm looking for the means of exporting data without the use of tabs or comma delimiters.

You need some kind of rules for the file (which is a delimiter most of the time).
Anthony PerkinsCommented:
What you are looking for is a Fixed-width text file.  This is pretty standard in the banking industry, unfortunately this is not available in SSRS and the best you can do from SSRS is to use Xml and apply XSLT to transform it to Fixed-width.  Clearly not a happy outcome.

Alternatively you can create another report that has no headers and has the output as a single concatenated column with the right format.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now