Hide Table Column When Blank Value Under Tabular Report

[vdb@telenet.be]

Problem:

under Tabular format there is no 'hide on blank value"

I can only work under Tabular because of the agregation function (sum).

 

 Report -> tabular -> Results page fields

 

So hide the colums(fields) where the value is blank

 

Can someone help me please?

 

Thank you

Bart

 

 

 

[ShWolf]

Hi,

 

Unfortunately, there is no "Hide if blank" feature for the Tabular report.

You can use JS, but if you will hide column fields it will broke report's markup.

[Jan]

Hello Mel,

 

Do you want to hide cells, records or columns?

To hide records, you can use a View and the Is Not Blank filter.

To hide columns, you can use the last script (that should be placed in the Footer) from this topic.

 

I hope, it helps.

[scribblemilk]

Hi Jan,

 

I have a similar problem but one that the script you suggest would work for Mel wouldn't be suitable for me, in essence I have a Tabular Report with a number of columns that may or may not hold blank values (all the way down) way they are blank (all the way down) i'd like to hide the columns, I'm very new to Javascript so am unable to re-intrepret the script you posted, so am hoping for some help.

 

I've added an aggregation row that counts non blank fields, that way any column that has a zero in the aggregation row is a column I want to hide, ideally I'd then want to hide the Aggregation row as it serves no purpose other than to identify the coulmns to hide.

 

Any help i can get on this would be greatly appreciated.

 

Jase

[cheonsa]

Hi all, 

 

I found a similar post about hiding columns if empty. You may check this for reference: 

 

 

Regards,

kristina

[Kurumi]