need to configure the pdf export option to create separate pdf’s -SSRS

Posted on 2011-05-12
Last Modified: 2012-06-21
Hi experts, I need to configure the pdf export option to create separate pdf’s for a given input parameter?

for example for a given location if I get some output pages, I should be able to configure the pdf export option.
Pls help.
Question by:sqlcurious
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    I'm afraid these are the only options you can set when rendering to pdf:

    I'm not sure what exactly you need though. Do you have a report with a location parameter, and do you want a seperate pdf for each location?
    If you have SQL Server 2008 standard or higher you could schedule the report once for every location so (for example) every night the reports are exported to a folder, or emailed.

    Please provide some more information about what exactly you need.

    Author Comment

    Yes, thats exactly right, I have a location parameter and I want a separate pdf for each location, how can that be achieved?
    LVL 22

    Accepted Solution

    Well it is not possible to configure the report in such a way that when the user clicks the export to pdf button one pdf is created for each value of the location parameter.
    The closest thing is a document map. This will give you bookmarks in the pdf. See: (the 'To add unique group values to a document map' section)
    You could export a report with a document map to Excel. In Excel (2007 or higher) you could write a macro that saves each sheet as a separate workbook.
    If you want it completely automated you could use subscriptions (SQL server Standard or higher), or create your own vbs script (for example) that creates a pdf for each location.

    Author Closing Comment

    Thanks for the reply, my ideal solution is to create separate pdf files but this is an alternative solution.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now