DAS - not refreshing the reports

scheduling Broadcast Agent (BCA)
1

Hi all,

We are using DAS to schedule our reports… DAS is not refreshing our
reports… we are using custom scripts… did anybody face the same
problem??? any clues or ideas???

Thanks

Regards
Nandhini

Listserv Archives (BOB member since 2002-06-25)

2

Sorry to ask this. Did you select the ‘Refresh’ action before attaching
custome script. Or do you have ‘ActiveDocument.Refresh’ in your script.
Actually what does you script do?

Vasan

Baton Rouge International, Inc
Data Warehousing and OLAP Consulting Division
http://www.bri.com

-----Original Message-----
From: Sundararajan, Nandhini (Mastech)
[SMTP:nandhini.sundararajan-eds@EDS.COM]
Sent: Thursday, April 01, 1999 1:52 PM

Importance: High

Hi all,

We are using DAS to schedule our reports… DAS is not refreshing our
reports… we are using custom scripts… did anybody face the same
problem??? any clues or ideas???

Thanks

Regards
Nandhini

Pls report bounces in response to postings to
BUSOB-L-Request@listserv.aol.com
Web archives (24 hrs. a day now!): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in
BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
====================================

Listserv Archives (BOB member since 2002-06-25)

3

Hi vasan,

Our main script actually gets the user inputs for conditions, then deletes
the existing conditions (added due to previous execution) and then adds new
conditions to the report. Then we are saving the report and closing them
using activereport.save and activereport.close…

Then we are executing this custom script(DAS)… The code follows:

Sub Main
Dim Doc1 as BODocument
Dim Hour As BOHourly
Dim DAOpt As BoDocAgentOption
Dim Result As Long

Set Doc1 = Application.Documents.Open("pdd") 'pdd is the report that had

been saved with the new conditions
Set DAOpt = Doc1.DocAgentOption
DAOpt.Server = “test”
DAOpt.CustomScript = “c:\Program Files\BusinessObjects\Scripts\Das”
DAOpt.StartDate = “04/01/99”
DAOpt.EndDate = “04/02/99”

DAOpt.Title = "TestDAS - Hourly - Normal - No Overwrite"
DAOpt.Priority = 3 'Normal
DAOpt.Overwrite = False
DAOpt.ScheduleMode = 2 ' Hourly
Set Hour = DAOpt.Hourly
Hour.FromHour = "9:00:00 AM"
Hour.ToHour = "4:00:00 PM"
Hour.MinutesAfterHour = 20
Result = DAOpt.Send

Doc1.Close

End Sub

Thanks & Regards
Nandhini

Listserv Archives (BOB member since 2002-06-25)

4

Nandhini,

Do you have following lines in ‘Das’ script which you attach with report:

ActiveDocument.Refresh
ActiveDocument.Save

It’ll be better if you can send me that scripts also

Vasan

Baton Rouge International, Inc
Data Warehousing and OLAP Consulting Division
http://www.bri.com

Hi vasan,

Our main script actually gets the user inputs for conditions, then deletes
the existing conditions (added due to previous execution) and then adds
new
conditions to the report. Then we are saving the report and closing them
using activereport.save and activereport.close…

Then we are executing this custom script(DAS)… The code follows:

Sub Main
Dim Doc1 as BODocument
Dim Hour As BOHourly
Dim DAOpt As BoDocAgentOption
Dim Result As Long

Set Doc1 = Application.Documents.Open("pdd") 'pdd is the report that

had
been saved with the new conditions
Set DAOpt = Doc1.DocAgentOption
DAOpt.Server = “test”
DAOpt.CustomScript = “c:\Program Files\BusinessObjects\Scripts\Das”
DAOpt.StartDate = “04/01/99”
DAOpt.EndDate = “04/02/99”

DAOpt.Title = "TestDAS - Hourly - Normal - No Overwrite"
DAOpt.Priority = 3 'Normal
DAOpt.Overwrite = False
DAOpt.ScheduleMode = 2 ' Hourly
Set Hour = DAOpt.Hourly
Hour.FromHour = "9:00:00 AM"
Hour.ToHour = "4:00:00 PM"
Hour.MinutesAfterHour = 20
Result = DAOpt.Send

Doc1.Close

End Sub

Thanks & Regards
Nandhini

Listserv Archives (BOB member since 2002-06-25)

5

Regards
Nandhini Sundararajan
EDS, St. Louis
Phone : 314 - 344 - 5189 (work)

Listserv Archives (BOB member since 2002-06-25)