Reports - Tabular - Configure Results Page Fields

[danielg05]

If I have a set of results, but I would like the value in one column (yes/no) as a condition for the next column to appear; could I do something like the following?  But is there a way to work around not having rules on this type of report?.

Suppose a no value appeared adjacent to a value in the following example with states, how can I hide one or many others?

https://howto.caspio.com/datapages/reports/result-set-layouts/

 

Would the following be a start?:

<script>
if("[@field:Account_show]" == "Yes"){
document.getElementById("[@field:Account_value]");
}
else if ("[@field:Account_show]" == "No"){
document.getElementById("[@field:Account_value]").hide();
}
</script>

 

 

[Franchiser]

I will suggest using calculated fields with SQL statement to filter the record.  

 

Example SQL code to filter a record base on the end user selection.

****  Select Account_value from table_name where target.Account_show=[@field:Account_show]

Example SQL code to filter a record with all the yeses "YES" to display.

*** Select Account_value from table_name where target.Account_show=1

I believe Account_show is a Yes/No field and it will be rendered as boolean, boolean rendered YES as 1.

 

Hope this helps.