Good Evening,
I have been given the task of producing a single VA report which can be filtered (on multiple data-items) 200+ times and use AMO to present the resulting visualisations in Excel using Add-In for Microsoft Office, which will then be converted to a PDF for consumption.
The users do not want to manually change the filters or manually convert the reports to PDF.
Is there a way, using only a vanilla install of VA 7.3 (i.e. no OA, no EG, etc.), to produce a result in the above manner?
I have read http://support.sas.com/resources/papers/proceedings16/SAS3500-2016.pdf and gather there is a way to create VBA code that interacts with the AMO, but I may be "barking up the wrong tree", given that the paper is discussing OA also.
Any help or ideas would be greatly appreciated.
Thank you in advance.
Scott
... View more