Schedule Tasks on BO Reports

[Benouche]

Hello,

I'm looking for a solution for scheduling 'Refresh and Export to Text' in BO.

I know BO provides the Broadcast Agent which performs those tasks, but it seems the license is very costly.

The solution then is to create a script in VB and to launch it thru the Windows utility for scheduled tasks.

Could you please detail the procedure for creating such programs ?
Does somebody have some script performing this ?

Any Help/Hint is hotly welcome,

Thanks in advance,

Benouchka.

 

[funkmonsteruk]

Benouceh, i had the same problem. Someone provided me with this code for the report which you want to automatePrivate Sub Document_Open()
Dim Doc As Document
Dim Rep As Report

Set Doc = Application.Documents.Item(1)
Doc.Refresh
Doc.Save
Doc.Print
Set Rep = Doc.Reports.Item(1)
Rep.ExportAsText("C:\Path to your file\YourReportName1&quot
Doc.Close

Application.Quit

End Sub

When this report opens it will refresh save and export you can obviously use another naming format if you want to distinguish your reports.

The next step is to add the report as a schduled report on your PC.

Select to run BO and finish the command line with the report name.

See if this works................