Hiding a table and/or cell based on fomula

building reports webintelligence
7

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 :india: (BOB member since 2008-05-12)