Exporting file to text from RS

  • I really need some help.  I am attempting to export a fixed length file from RS and cannot figure out how to make that happen.  Any ideas????

    Thanks,

    Angi

  • You could create a view or stored procedure that concatenates your data fields into a single result column (of the length you need), and then render a report as a CSV file using that view or stored procedure to provide data to the report.

    Alternatively, you might be able to do such a file export directly from SQL Server, bypassing Reporting Services.

  • Unfortunately, I think to get a fixed length text output from report server, you will have to write your own export extension.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply