How can we hide a table or cell based it on certain formula like in DeskI
I am using R3.1 version of WebI.
My query never gets the empty rows, So I have to hide them based on certain conditions.
Any ideas will be appreciated
BOLearner (BOB member since 2005-01-20)
Does this mean, that we cannot hide a cell(table) based on one condition ?
I really hope there should be the way
BOLearner (BOB member since 2005-01-20)
You can hide conditionally using a filter and then using the ‘Display’ properties. (By clearing out ‘show when empty’ check box)
Jansi 
(BOB member since 2008-05-12)
The good news is that it has made a comeback in 4.0
BO Learner:
Try this
M H Mohammed 
(BOB member since 2010-06-16)
Can you please let me know how to hide conditionally.
I am using BO R3.1 Sp3.
I have query which returns atleast 1 row ( I had union select 0,0 from dual)
in the query, to avoid -NO DATA TO RETRIEVE message from the query execution
I have a cell which displays No data available, when the query has only 1 row, and display table when the query has more than one row
BOLearner (BOB member since 2005-01-20)
Check this FAQ. This will give you an idea. FAQ: Reporter
Instead of UserResponse(), you have to use NumberofRows function in the filter. The logic is this.
Flag’s pseudocode should be this.
Flag=If(NumberofRows([dp])=0;1;0)Place the block which says ‘No data available’ and the table one over the other. And then apply the filter (flag=1) on the cell. Similarly apply a filter on the block of data (flag=0). Set both the blocks’ Display properties (uncheck show when empty check box)
Jansi (BOB member since 2008-05-12)
I am getting there but not able to drag a Flag object for the cell.
I am able to drag the Flag object onto the table filters list and can apply the filter, but when I selected the free standing cell ( which contains the NO DATA TO DISPLAY text, I am not able to drag the flag object to the filters section.
Not sure why ?
BOLearner (BOB member since 2005-01-20)