How to suppress "no data to fetch" warning message?

[Former Member]

Hi All,

We must have come across such scenario in which we get this warning message when our query does not return any data.

In some scenarios, this message is not acceptable for customers and they wish to suppress it.

Speaking about this warning message, it is By-Design in BusinessObjects and cannot be suppressed by checking or un-checking any option in BusinessObjects XI 3.x;  however, it is possible to avoid it.

There could be multiple approaches to achieve this;  however, according to me, least expensive approach is to create a Dummy object and insert a Combined Query. (for users who does not have right to edit SQL; however, can create objects in universe)

For example, let’s take below scenario:

Report is not returning data due to an unsatisfied condition applied:

In order to avoid this, create a Dummy object as follows:

Choose any table under Tables which you are using in First Query and assign it to Dummy object.

NOTE: This will only work if the first query in combined query is returning Character type data.

Add a  combined query using UNION operator and insert this object as follows:

The query will look like this NOW:

(

SELECT

<table_name>.<column_name>

FROM

  <table_name>

WHERE

  <table_name>.<column_name>=  '124'

UNION 

SELECT

  ' '

FROM

  <table_name>

)

After running the query, "no data to fetch" warning message wont come anymore as it will return blank as result.

What if first query is returning numeric value??

In this case, we can define the Select statement of our Dummy object as an integer say 1 instead of  ' '(space). This will create a Numeric Dummy object.

However, this will return 1 as result on report.

How to handle this?

Put an alerter in the report which will return a blank space and assign it to the specific column which is returning 1:

I hope this will be useful for users who have just started working with WebIntelligence.