BusinessObjects Board

How to Suppress No Data to fetch error in Deski

building reports desktopintelligence
#1

Hi Friends,

Please let me know Suppress No Data to fetch error in Deski. I have to data providers & two prompts are also there. If i use below macro, its SUPPRESSING prompts also.

Dim DP As DataProvider

Private Sub Document_BeforeRefresh(Cancel As Boolean)
Set DP = ActiveDocument.DataProviders(1)
Application.Interactive = False
DP.Refresh
Application.Interactive = True
End Sub

Is there any other way to hide the no data message.

Thanks,
narinder

narinderk (BOB member since 2008-08-14)

#2

Check this in Designer FAQ for other methods.

Jansi :india: (BOB member since 2008-05-12)

#3

Hi Jansi,

One more problem is i am using Sybase now. i dont think there is any dummy table like Dual in oracle.

Regards,
Narinder

narinderk (BOB member since 2008-08-14)

#4

I didn’t try it at least once. But if that is the case, you can then go for the fourth way of suppressing the no data message. i.e. by displaying User defined message.

Jansi :india: (BOB member since 2008-05-12)

#5

Yes, Sybase has dual too.

Damocles :uk: (BOB member since 2006-10-05)