"No Data to retrieve" Pop up block

[system]

Hi Guys,

How can i block “No Data to retrieve” pop up in BO WebI XI R2 reports?
I have some reports that has multiple data providers and if report doesnot get data from any of the data providers, report throws this message. We do not want our users to see this message.
I appreciate your help.

Thanks,
J Wood

---

wood (BOB member since 2006-06-05)

[system]

FAQ: Reporter

How can I supress the ‘No Data To Fetch’ message? There are multiple methods of supressing the ‘No Data To Fetch’ message. Programmatically… If you copy this code into the ThisDocument module, it should work. To implement the code, you will need to have your Report which gives you the No Data to fetch message open. Click on Alt + F11, and the Visual Basic Editor will open. On the left hand side you should see a list of all the documents you have open. Under the name of the documen…

---

zack (BOB member since 2007-08-02)

[system]

Please correct me if I am wrong. This solution is for FC only. It does not work on WebI.

---

substring (BOB member since 2004-01-16)

[system]

@substring

Please correct me if I am wrong. This solution is for FC only. It does not work on WebI.

I dont think it will give a pop up in WebI.

---

bobjkb (BOB member since 2004-03-19)

[system]

@Forum Associate

I dont think it will give a pop up in WebI.

Yes it does.

---

zack (BOB member since 2007-08-02)

[system]

All,

This question has been asked several times and if you search there is an answer somewhere here on BOB. The only broblem with the solution is that it will disable all messages from BO not just the no data retrieved message. This includes all errors.

Markus

---

Markus Lowry (BOB member since 2007-03-30)

[system]

@substring

Please correct me if I am wrong. This solution is for FC only. It does not work on WebI.

There are several solutions outlined in the FAQ linked previously; only one of them requires VBA. The others related to specific query structures which can be built in Webi, and therefore can be used for that platform.

---

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

[system]

We fixed this as follows:

Go to \Program Files\Business Objects\Tomcat\webapps\businessobjects\enterprise115\desktoplaunch\viewers\cdz_adv\language\en\scripts and open viewer.js in a text editor.

Look for the following function: displayNoDataToFetch
This funtion has only 1 line of code. Prefix that with // to comment it.

The popup will not display after this change.

---

Farhan Jaffery (BOB member since 2005-08-27)

[system]

In my humble opinion, completely disable the popup is not a good thing. The users will misinterprete that as really no data. In the example that Dave has pointed, there is always a chance the user has typed in the wrong input parameter. Therefore, it is better to provide a meaningful message than no message at all.

Just my $0.02.

---

substring (BOB member since 2004-01-16)

[system]

I agree that the users need to know that the data might not have returned due to the parameters selected for that report or due to security restrictions. We opted to display this information as a message on the reports rather than in the generic popup.

---

Farhan Jaffery (BOB member since 2005-08-27)