Display custom field like "No data from table" when user prompt doesn't get results

[yogananda]

In Webi Report designed with custom query objects, when there is no data I need to display custom field as (No data in each column) in the design table.

This is when no data found from the DB table.

[mhmohammed]

Hi Yogananda,

Hiding the Actual table, and showing a Blank table with the text "No data to display" can be one option. You'll have to follow the below steps:

1. Update the properties of Actual Table by right clicking on it -> go to Format Table -> General -> Check the box for Hide when Empty.
2. Create a Blank Table which should be identically similar to Actual Table in terms of number of columns, formatting and so on, and manually type in the text as "No data to display" in the rows and columns as needed.
3. Update the properties of Blank Table by right clicking on it -> go to Format Table -> General -> Check the box for Hide when the following formula is true: and write the formula as =Numberofrows([Query 1]) <> 0. But instead of Query 1, write the number of the query you have.

Let us know if that works!

Thanks,
Mahboob Mohammed