Hide a row in a tabular datapage report based on a calculated field

[alanhoffman]

Hi.

I have a tabular datapage that produces a report that shows 4-5 columns showing name, town etc. - and each row is for a different "Member_ID".

One of the columns is a calculated field ("Entry_Count") that uses the Select function to count the records in another table for each Member_ID.

I would like this report to hide any row where the count is zero.

Any suggestions would be greatly appreciated...

Perhaps there is  some coding for this (I assume to be placed in the header or footer).

Many thanks...

 

[cheonsa]

Hi @alanhoffman,

 

I understand that you want to hide rows based on the result of your calculated field. You need to have a custom script to achieve that. 

First, you need to add HTML Bolck, disable the HTML Editor or click the Source button. Then, paste this code:

<a id="visi[@field:UniqueID]">

<script>
var isi = document.getElementById("visi[@field:UniqueID]");
if([@calcfield:1#] = 0){
isi.parentNode.parentNode.style.display = 'none';
}
</script>

 

Remember to change the '[@field:UniqueID]' to the name of your UniqueID field and the '[@calcfield:1#]' to the corresponding name of your calculated field. 

 

The solution is similar to this article: Dynamically Change the Background of a Results Page Record. 

 

Hope this helps. 

 

-kristina

 

[Kurumi]

Hi - Just an update, here are the other ways for you to hide column in the Tabular Report:

Without Download/Sort Options:

table[id*='cbTable'] > tbody > tr[class*='cbResultSetTableHeader'] > th:nth-child(1), td[class*='cbResultSetData']:nth-child(1){

    display:none !important;
  
}

With Download/Sort Options:

table[id*='FreezeTabularHeaderObj'] > tr[data-cb-name="header"] > th:nth-child(1), td[class*='cbResultSetData']:nth-child(1), #target table:nth-of-type(1) th:nth-of-type(1), #target table:nth-of-type(2) th:nth-of-type(1){

    display:none !important;
  
}

Replace 1 with the position order of column to be hidden.