Insert "no data to retrieve" message into a report

[system]

Hi,

We have multiple data sources providing data to a Webi report. There is a potential that one data provider sometimes doesn’t have any data and so returns a “no data to retrieve” pop up.

What we would like to do is flag this message into the report in a cell. So the message “Query X has no data to retrieve” would appear in a specific cell in the report…

Is there any easy way to achieve this?

---

buffalotom99 (BOB member since 2017-03-24)

[system]

Could you count the number of instances of some variable from Query X, and show that message when the count is zero?

---

mikeil (BOB member since 2015-02-18)

[MarkP]

120×120 10.4 KB

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…