Hiding the blank cells in Webi report - BO 4.0

[Former Member]

Hi,

I have created a webi report in which i have used different types of blocks

1) Form table

2) Verticle table

3) Horizontal table.

so now in real time there chances that some of the blocks will not have any data.(i.e it displays blank cell) in the report.

so now i have to hide only the blank cells and not the table headers.that means though the cells are blank i have to display headers.

what formatting changes i need to achieve this in Webi Report.

If anybody does this please let me know the step by step logic in detail.

Thanks in advance.

Regards,

Naga Nanda Kishore.

[Former Member]

Hi,

We cannot hide specifc cells in WebI, however we can choose to whether to display or not empty measure values and empty dimension value.

So you need to select the desired block-> Right Click  and Select Format Table-> Uncheck Show rows with empty dimension values or Show rows with empty measure values whichever is required to be hidden.

Hope this helps.

Regards,

Manpreet

[jyothirmayee_s]

Hi,

Right click on the table format>> under General tab>> Uncheck the options whichever suits your requirement.

Thanks,

Jothi