Post reply

Multiple output files

  • October 27, 2014 at 6:38 am

    #312570

    I need to produce multiple output files from a single report run. Breaking on a customer number. Is that possible with SSRS?

  • October 27, 2014 at 8:29 am

    #1754948

    Hi Bill,

    This is possible but not through the standard export feature. Hopefully you are using Enterprise Edition?

    If so you can create a Data Driven Subscription to generate the reports. Using Windows File Share as the destination the query you create can specify the filename and path which are passed like parameters to report manager.

    You can write a query to generate the customer numbers to be passed to the report and the desired output name for each files

    e.g.

    SELECT

    CustomerNumber,

    CAST(CustomerNumber AS VARCHAR(255) + '.csv' As [Filename],

    '\\mypc\c$\exports' As [Path],

    'CSV' As [RenderFormat]

    FROM Customers

    The subscription will then iterate over the customer list running and exporting for each value.

    HTH

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

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