automate report export

I have a report that has a parameter for each agency that I deal with (500
total agencies). I was just told that I have to run this report for each of
the 500 agencies and export the results to a PDF file or files. After getting
back up on my chair, I started to research how I may automate this and have
come up empty handed.
Does anyone know of a script that I may use to pass in a parameter from an
array or sql cursor to my report and export the results?
Thank you in advance!!!Open the report in the Report manager.
Go To the "Subscriptions" Option
Select "New Data_Driven Subscription"
This is a good place to start with.
--
THANKS & PLEASE RATE THE POSTING.
--RAVI--
"Carl Henthorn" wrote:
> I have a report that has a parameter for each agency that I deal with (500
> total agencies). I was just told that I have to run this report for each of
> the 500 agencies and export the results to a PDF file or files. After getting
> back up on my chair, I started to research how I may automate this and have
> come up empty handed.
> Does anyone know of a script that I may use to pass in a parameter from an
> array or sql cursor to my report and export the results?
> Thank you in advance!!!|||thanks! that doesnt work for me since I am not storing my access credentials
locally. I am looking into passing in parameters via URL. That looks
promissing, if I can just figure out the whole Rendering thing.
thanks!
"Ravi" wrote:
> Open the report in the Report manager.
> Go To the "Subscriptions" Option
> Select "New Data_Driven Subscription"
> This is a good place to start with.
> --
> THANKS & PLEASE RATE THE POSTING.
> --RAVI--
>
> "Carl Henthorn" wrote:
> > I have a report that has a parameter for each agency that I deal with (500
> > total agencies). I was just told that I have to run this report for each of
> > the 500 agencies and export the results to a PDF file or files. After getting
> > back up on my chair, I started to research how I may automate this and have
> > come up empty handed.
> >
> > Does anyone know of a script that I may use to pass in a parameter from an
> > array or sql cursor to my report and export the results?
> >
> > Thank you in advance!!!|||Carl, if you still need this, we are doing it.
let me know via here and I will send you what we have.
"Carl Henthorn" wrote:
> thanks! that doesnt work for me since I am not storing my access credentials
> locally. I am looking into passing in parameters via URL. That looks
> promissing, if I can just figure out the whole Rendering thing.
> thanks!
> "Ravi" wrote:
> > Open the report in the Report manager.
> > Go To the "Subscriptions" Option
> > Select "New Data_Driven Subscription"
> >
> > This is a good place to start with.
> > --
> > THANKS & PLEASE RATE THE POSTING.
> > --RAVI--
> >
> >
> > "Carl Henthorn" wrote:
> >
> > > I have a report that has a parameter for each agency that I deal with (500
> > > total agencies). I was just told that I have to run this report for each of
> > > the 500 agencies and export the results to a PDF file or files. After getting
> > > back up on my chair, I started to research how I may automate this and have
> > > come up empty handed.
> > >
> > > Does anyone know of a script that I may use to pass in a parameter from an
> > > array or sql cursor to my report and export the results?
> > >
> > > Thank you in advance!!!|||Hi Jeff,
We have created a process to automatically render reports to PDF on a
monthly basis as well. Our issue is timing. Have you had any issues
concerning the amount of time it takes to render a large number of reports?
We took one report with an average of 10 pages and ran it for 600 clients.
The process took 1 hour. We have a total of 30 reports and 1600 clients.
This will take weeks to create all of them.
Any help is greatly appreciated.
Thank you
Scott Torres
"Jeff Ericson" wrote:
> Carl, if you still need this, we are doing it.
> let me know via here and I will send you what we have.
> "Carl Henthorn" wrote:
> > thanks! that doesnt work for me since I am not storing my access credentials
> > locally. I am looking into passing in parameters via URL. That looks
> > promissing, if I can just figure out the whole Rendering thing.
> > thanks!
> >
> > "Ravi" wrote:
> >
> > > Open the report in the Report manager.
> > > Go To the "Subscriptions" Option
> > > Select "New Data_Driven Subscription"
> > >
> > > This is a good place to start with.
> > > --
> > > THANKS & PLEASE RATE THE POSTING.
> > > --RAVI--
> > >
> > >
> > > "Carl Henthorn" wrote:
> > >
> > > > I have a report that has a parameter for each agency that I deal with (500
> > > > total agencies). I was just told that I have to run this report for each of
> > > > the 500 agencies and export the results to a PDF file or files. After getting
> > > > back up on my chair, I started to research how I may automate this and have
> > > > come up empty handed.
> > > >
> > > > Does anyone know of a script that I may use to pass in a parameter from an
> > > > array or sql cursor to my report and export the results?
> > > >
> > > > Thank you in advance!!!