Show when empty option to hide the row

building reports webintelligence
1

Hi

I have selected the show when empty option under the Display properties to hide the row, its not working. Will it hide only when the table has defined with null and it wont work for the value 0…? If so, how to hide the rows for the value having 0 using alerter…? Dont want the filter to be applied on the report. Its Webi Report.

Regards
Siva.M

looksmee :uk: (BOB member since 2006-02-08)

2

When no rows are coming, but still if you want to show the table/block, then we have to select ‘Show when empty’ check box.

But if the row persists even with 0’s, it will be shown. The only way to come out of it is to apply filters and make them bringing no rows when having 0’s.

As far as I know, through alerters, we can format the cells or rows or replace a column with another.

Applying filter is the only way to hide the rows, I’m afraid. But why don’t you want to apply filter?

Jansi :india: (BOB member since 2008-05-12)

3

Hi Jansi

Thanks for your reply, we just looking something to do using the Alerter.

Regards
Siva.M

looksmee :uk: (BOB member since 2006-02-08)

4

Even if you go with the alerters, you won’t be able to Hide or remove rows. But for sure you can assign some values on empty rows and filter those values.
:slight_smile:

aniketp :uk: (BOB member since 2007-10-05)

5

Agree, Do we have any other workaround to hide the row as i posted in my previous question…?

Regards
Siva.M

looksmee :uk: (BOB member since 2006-02-08)

6

As far as I know, only filter can help you. You can design your variables in such a way that you can apply filter on that variable and get your required data.

Rest I apologize, I don’t know. :frowning:

aniketp :uk: (BOB member since 2007-10-05)