Hi All,
In BO 6.5, the reports were dynamically scheduled to File Share as PDF using VBA Macros.
Ex: I have report (abc.rep). The selection criteria are Code and Year. The code and year is provided to the report by the Macro
which reads from the database. If Code = ‘X22’ and Year=’2014’, the report is executed with this selections and another macro
runs to save this file as PDF in file share path. Here the twist is the Codes keeps changing, suppose in this month if the
Code=’X22’ and year =’2014’, next month it can be Code=’Y22’ and Year=’2014’.So this keeps changing dynamically and reports
are also saved into folders based on this. This works fine in BO6.5 using macros and BCA.
Now that we have moved few BO 6.5 report to BO 4.1. , I need to implement some logic in 4.1 to produce the results in the same manner.
Since Macros doesn’t work in 4.1, iam looking into the ways to achieve this. If anyone gone through this kind of task,
please share your thoughts.
I have gone through many posts but could not find the apt solution.
Regards
Sudhakar
If the rules for this are well defined and based on the current date, you might be able to dynamically set the parameters by creating a filter in the universe instead of using actual parameters.
If that's not possible, you may have to use either the Java or .NET SDK to schedule the report with the correct values.
-Dell
wow.. BO 6.5 Deski Reports 😊 I love deski reports because we can achieve any requirement with Macro.
BO4.1 is a different product when you compare with BO 6.5. :-(
As Dell mentioned, you can use SDK :-) you have to redesign(universe and corresponding dependent objects based on available new features in 4.1 ) if you don't want to use SDK/Macro again.
what is the business requirement and the logic for this requirement ?
who reads all those pdf's ?
wouldn't it be easier for users to receive their docs in more interactive manner ?
pdf's on file store are also not very secure solution.
So, besides SDK and Publication alternatives - maybe a new approach to business need is also warranted.
Add a comment