Display message when No Data Found

[system]

Hi:

I am creating a Web Intelligence report in BO-XI-R2 environment. When there is no data from the result set, I would like to display message to the users. I am trying to acheive this through alerters, but able to track no data found.

Could someone advice me on this.

Thank you before hand.

Regards,
JC

---

jchennuri (BOB member since 2007-06-13)

[system]

If there is no data for your query then BO gives a no data fetch warning after you refresh the report

---

monty4u (BOB member since 2006-12-12)

[system]

Hi

You cant hide that popup message.

you can display message “No Data in Database”

Create a cell and use this formula

=If(IsNull(Count([[Query Object Name];All));“No Data”)

make this cell position from original block top 0, left 0
remove that cell’s border

remove that block’s all tick marks from display section except show table headers.

Now you refresh that report, if that query return any value then your table will display other wise you will get BO message after thet your message will display.

Note : You can’t avoid no data fetch popup message

Mahudeswaran. K

---

mahudes (BOB member since 2006-03-06)

[system]

That’s not true. We have implemented this and we’re quite happy.

In fact, I think I’ve even posted exactly this comment before:

Actually, it’s quite easy. See this thread. It is a very small customization.

Disabling/removing the "No data to fetch" message

Hi friends, Quick question: When a query returns empty, it says "no data to fetch" or similar and one has to press the OK-button. Is there any way of disabling this feature such that if a query returns no data, then it does not notify you? thanks, plexi 8)

You’ll still get the message from the WebI query panel. But, from InfoView it works perfectly. I don’t mind this as the users are happy. Only the developers get the message. I actually think this is better.

---

Steve Krandel (BOB member since 2002-06-25)