Export multiple reports to separate folders in pdf format

  • Is it possible to export multiple reports into different folders? Sort of looping through a dataset of ID's then, exporting a report using the ID as a parameter.

  • Try this series of articles (the link to the first article is in this article I am posting).

    http://jasonbrimhall.info/2011/11/29/ssrs-export-part-2-export-data-source/

    I show how to export both the data sources (part 2) and the reports (part 1).

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Thanx.

  • I just read the rest of your problem title and had only gone off the description in your post.

    Exporting reports as pdf to different folders is a different thing.

    Sounds like you need to setup schedules to distribute each report you want to export. I don't know a programmatic way to do that and it is a manual process.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • What about data driven subscriptions?

  • NineIron (2/12/2014)


    What about data driven subscriptions?

    What version of SQL Server are you running (e.g. Standard, Enterprise)?

  • 2008 R2

Viewing 7 posts - 1 through 6 (of 6 total)

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