I have an ssrs report that lists all invoices paid by each check
The report is grouped by check# and exported out into a single pdf file with multiple pages.
we were in the beginning stages of automating the process by setting up a subscription to export the pdf file to a file share which seemed pretty straight forward.
We have just learned that the vendor has changed their application so now there needs to be a separate pdf file for each check. The slight twist is that there can be enough entries for a check to result in multiple pages
(fyi .... we will be using a separate process to ftp the files to the vendor)
I have done some research and looks like data driven subscription can be used but the details on how are very sketchy. (The generic msdn description)
I am using ssrs 2008 enterprise version so data driven subscription is available to me
any one know of a link that might show step by step? or perhaps a different approach
anything we come up with needs to be automated with no manual intervention