How To Hide Records In The Report Based On Calculation

[Michelle]

Hi all, 

 

If someone knows how to hide some records on the Tabular report if Calculation => 5 for example? 

 

 

[Aurora]

Hi Michelle, 

 

You could use this script : 

<div id="visi[@field:Your_Unique_ID]">
</div>

<script>
var isi = document.getElementById("visi[@field:Your_Unique_ID]");
var calc="[@calcfield:1]";

if(calc >= 5){
isi.parentNode.parentNode.style.display = 'none';

}
</script>

Add an HTML block to the Report Page and paste the code above. 

 

Regards, 

 

Aurora