For-Next loops

[Hawkeye97]

Rather than repeatedly sending the same report to be processed on Broadcast Agent on a regular basis with the only difference being prompted for a sales exec variable to define each report data, is it possible to create a VB script or Report Script based on a For-Next loop that will populate the report with the variable held within a dimensional array and then sending the report to BA and then moving on to populating the next report.

I'm using BO version 5.1.2

Cheers

Hawkeye

 

[AlisonC]

Why don't you create users in Supervisor and then change your constraint to be = @variable('BOUSER') and use report bursting

 

[ATP]

See Thread393-88021 (VBA in BOB) for an example of some v4 script which reads a file, alters the report and saves the html.

v5 converted this v4 script to VBA with no problems. This is run via the BCA to publish html reports to the intranet.

When submiting the report to the BCA use the "Run Macro" option.

 

[Hawkeye97]

Thanks for the information. Looks cool and quite easy to code to be honest.

Thanks for your help

Cheers

R