suppressing "no data to fetch"

building reports desktopintelligence
1

How to suppress the BO Error messages. For example how to suppress “no data to fetch”

nwice (BOB member since 2002-11-20)

2

The only way is with VBA. You can supress those messages while the script runs. Otherwise, there is no way to do that.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

3

I tried checking the no of rows returned from data providers, in after refresh event, even then it’s not working…

nwice (BOB member since 2002-11-20)

4

:smiley:

If you use the following URL, this may provide you with a solution to your problem.

Thanks

Roller :crazy_face:

Roller (BOB member since 2002-10-23)

5

That’s a great tip; I’ve used that technique before. However, it doesn’t supress the “No data to fetch” message. You can only do that through VBA. The VBA line to supress the messages is as follows:

Application.Interactive = False

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

6

Hi,

Thanks for the tip, but unfortunately it won’t be useful because I have set of prompts in my report which will take user input…

nwice

nwice (BOB member since 2002-11-20)

7

Hi Roller,

Really, it’s a great tip but unfortately I could’t stop the lousy message…

nwice (BOB member since 2002-11-20)

8

Did you try a search? We’ve discussed this in the past. I found this from the loaded archives.

Cindy Clayton :us: (BOB member since 2002-06-11)