set info in a table according to value in another table

alexis

<p>Hi,</p><p> </p><p>I'd like to display an info in a table according to a value in another table, e.g. set as visible a label in a cell (first table) according to a data set value in the second table being grater to a threshold.</p><p> </p><p>I tried with a java variable, setting the variable in the script function 'onCreate' (second table), and testing it in the script function 'onRender' (first table), but that does not work.</p><p> </p><p>Any idea ?</p>

kclark

<p>In the cell of the first table you could make it a PGV in the onCreate() doing something like this
 </p><pre class="_prettyXprint">var currentValue = parseInt(this.getValue());if(currentValue > 10000) {  reportContext.setPersistentGlobalVariable("hidePGV", "true")}</pre><p>Then in the visibility expression editor of the label in your second table you could do something like</p><pre class="_prettyXprint">if(reportContext.getPersistentGlobalVariable("hidePGV") == "true") {  true;}else{  false;}</pre>