Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All.
I have been searching through the Community for an answer to a much asked question: "How can I automate the production of individual PDFs from a Banded report?"
The answer mainly is to use Publisher, but in this case that is not possible, so I am asking the question again in the hope that there are new answers!
My requirement is that I have a report that is set to band over "Area" and there are 15 different areas. I have now been tasked to send a regular report to each of these areas, i.e. an individual slicew of the banded report. I would quite like to automate this process and am fairly familiar with VB so the use of code is a possiblity.
I am willing to accept some form of 'Brute Force' solution rather than an elegant bit of programming!
My idea of a brute force solution is to pull an area name into a variable, then run the report using that variable, looping through the 15 areas one at a time until all of the reports are saved.
Any ideas / solutions gratefully accepted!
Thanks.
Hi James,
Did you ever get to the bottom of this? I've got a similar issue.
Thanks