BO schedule to generate multiple reports based on parameter

sdk development
1

I have created a webI report which takes a parameter(say customer Id) to fetch records from database and display record for that customer.

i need to generate individual reports save as pdf for all the customers using Scheduling? (I think it is Similar to the ForceCompute function in VBA with full client)

Have to get all the customer Id from Customer table, then loop through generating reports by dynamically passing customer Id to report each time.

Thanks in advance!!!

hidayatali (BOB member since 2005-02-23)

2

Look into the publishing and profiles option and do a single pass report bursting

.

haider :es: (BOB member since 2005-07-18)

3

Hi Haider,

We even thought of the single pass profiling and publishing. But in this case, the prompt paramter values change daily and number of values report needs to run is 2000+. is it proper to use the same method for this huge volume also?

Would you provide me with discussion link which i can refer.

Thanks for the help!!

hidayatali (BOB member since 2005-02-23)

4

Hi hidayatali,

Were you able to find a solution for this? If Yes what is it?

I am having a similar requirement. I need to generate around 1000 .pdf’s with Customer ID as a prompt, and then save the pdf as customer_id.pdf.

Thanks

vemurus (BOB member since 2006-08-18)

5

The SAP support site has samples available for scheduling reports w/prompts via JAVA (or .NET);. We’ve successfully used it for scheduling DESKI reports and set prompts/events/destinations…etc along the way. I’m guessing all that you would need to do is add the piece that reads in your prompt values and just loop through them, creating a schedule for each.
As far as scheduling, you could probably throw your code into a compiled program and schedule it as a program object to run whenever you need it.
:+1:

jresendez :mexico: (BOB member since 2004-05-03)