nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to check the data element visibility

noe-su

Hi,
On my data element (dataSetRow["invest_amt"]) I have a visibility expression and on render I have a javascript statement.
My problem now is that it executes the javascript also if it is not visible, so I like to extend the javascript statement with something like "if (this.isVisible()){}".

Visibility expression:
row["allocn_typ_cd"] != "INVEST" && row["allocn_typ_cd"] != "INVEST_YRC"

Javascript:
if (reportContext.getPersistentGlobalVariable("invest_amt")){ 
var subtotal = 0 + parseFloat(reportContext.getPersistentGlobalVariable("invest_amt")) + parseFloat(this.getValue()); 
} 
else{ 
var subtotal = 0 + parseFloat(this.getValue()); 
} 
reportContext.setPersistentGlobalVariable("invest_amt",subtotal.toString());

Find more posts tagged with

Comments

pricher

Hi,
 
The onRender method should not excecute if the element is not visible. Can you send your report design?
 
P.

noe-su

The report design has to many other things in to send but I try to explain more detailed.
 
I have a table connected with the dataset NQ_positions.
I have tree columns: "Name", "Investment", "OTC"
The name is taken as dataSetRow["name"]
The investment and the OTC is taken from the same value: dataSetRow["invest_amt"]
 
On the Investment I have the visibility expression: row["allocn_typ_cd"] != "INVEST" && row["allocn_typ_cd"] != "INVEST_YRC"
On the OTC I have the visibility expression: row["allocn_typ_cd"] != "OTC" && row["allocn_typ_cd"] != "OTC_YRC"
 
On the Investment I have the onRender
if (reportContext.getPersistentGlobalVariable("invest_amt")){ 
 var subtotal = 0 + parseFloat(reportContext.getPersistentGlobalVariable("invest_amt")) + parseFloat(this.getValue()); 
} 
else{ 
 var subtotal = 0 + parseFloat(this.getValue()); 
} 
reportContext.setPersistentGlobalVariable("invest_amt",subtotal.toString());
On OTC I have the onRender
if (reportContext.getPersistentGlobalVariable("otc_amt")){ 
 var subtotal = 0 + parseFloat(reportContext.getPersistentGlobalVariable("invest_amt")) + parseFloat(this.getValue()); 
} 
else{ 
 var subtotal = 0 + parseFloat(this.getValue()); 
} 
reportContext.setPersistentGlobalVariable("otc_amt",subtotal.toString());
 
Later I have somewhere the dynamic text
parseFloat(Math.round(reportContext.getPersistentGlobalVariable("invest_amt") * 100) / 100).toFixed(2);
and
parseFloat(Math.round(reportContext.getPersistentGlobalVariable("otc_amt") * 100) / 100).toFixed(2);
 
And the Problem is that all OTC Amounts are hidden, so they should be 0 but getPersistentGlobalVariable("otc_amt") gives the same value back as getPersistentGlobalVariable("invest_amt").
 
....
but when I read my explanation... I think I know the reason... Maybee I should not use the same variable name "subtotal" in both render scripts

noe-su

I did now add an always invisible dynamic text above my problem.
As Text I did use:
if (row["allocn_typ_cd"] != "INVEST" && row["allocn_typ_cd"] != "INVEST_YRC"){ 
 "is NOT visible"; 
 reportContext.setPersistentGlobalVariable("isVisible","false"); 
} 
else{ 
 "is visible" 
 reportContext.setPersistentGlobalVariable("isVisible","true"); 
}
And I did wrap my Problem in:
if (reportContext.getPersistentGlobalVariable("isVisible")=="true"){ 
 //execute my Code
}
 
 
Ugly solution, but it did solve my problem.