Hi Forum,
I have a Query with a solution for the same but not sure of the complexity of the same.I would like to get the expert comments on the following approach: -
Requirement: From ‘N’ number of BO reports user can select any ‘n’ number of reports and get the refreshed report in Single PDF file.
Approach : Let us create a single report containing all the possible reports as TABS.Now before the refresh user will be prompted to select the report tabs he want in his final report.Once he selects the tabs, remaining tabs will be deleted and the report containing only selected TABS will be refreshed and converted into single PDF file.
Doubts: Whether it is possible by VBA macros to achieve this approach?If yes can somebody provide me the sample code for the same.
Your help will be highly appreciated !!!
Cheers,
Rajeev Dhawan
rajeevw (BOB member since 2005-06-14)
(BOB member since 2002-06-20)