BusinessObjects Board

Message Boxes

building reports desktopintelligence
#1

Hi.
We want to develop the simple apllication something like BCA for sceduling and refresh reports.For this case we wrote VB macro and run this one with BO document in silent mode from command line.
This macro has refresh some reports one after another.
The silent mode prevent the pop up of all message boxes and BO errors.
Now we are checking any way to develop this application in VB or VB.NET.
Is there any way to turn off the message boxes of BO reporter like ‘No data to fetch’ or any another one.

Thank you

sinale (BOB member since 2003-01-13)

#2

If you haven’t looked at this FAQ look inFAQ Reporter… There is a post by Cindy on ways to avoid No Data To Fetch Message…

Sridharan :india: (BOB member since 2002-11-08)

#3

Hi,Sridharan.
Thank you for you response.The code from Cindy’s topic help me to avoid the message box “no data to fetch”, but BO and DBMS errors still appear.
How I prevent the error messages?

Thanks

sinale (BOB member since 2003-01-13)

#4

Are you setting interactive mode to false?

Does this need to move to the SDK forum?

Dave Rathbun :us: (BOB member since 2002-06-06)

#5

yes

sinale (BOB member since 2003-01-13)

#6

Which method did you use from that??? Also can you post the Error Message that BO Displays???

Sridharan :india: (BOB member since 2002-11-08)

#7

Hi.
I am using the Cindi’s code :

Private Sub Document_BeforeRefresh(Cancel As Boolean)
Set DP = ActiveDocument.DataProviders(1)

Application.Interactive = False
DP.Refresh
Application.Interactive = True

End Sub
For the test I maked the mistake in my universe and exspect not to see any error.
The above code prevent the BO message “no data to fetch” but error like
“Connection or SQL sentence error(DA0005)” still appear.
I want to turn off all messages and errors becouse when I refresh the reports in my application
and some one report get error all another reports would not refresh until the user not closed the error message

sinale (BOB member since 2003-01-13)