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

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.
thanks!
sqlcuriousAsked:
Who is Participating?
 
Nico BontenbalConnect With a Mentor Commented:
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:
http://msdn.microsoft.com/en-us/library/dd239329.aspx (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.
0
 
Nico BontenbalCommented:
I'm afraid these are the only options you can set when rendering to pdf:
http://msdn.microsoft.com/en-us/library/ms154682.aspx

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.
0
 
sqlcuriousAuthor Commented:
Yes, thats exactly right, I have a location parameter and I want a separate pdf for each location, how can that be achieved?
Thanks!
0
 
sqlcuriousAuthor Commented:
Thanks for the reply, my ideal solution is to create separate pdf files but this is an alternative solution.
0
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.

All Courses

From novice to tech pro — start learning today.