How to set a value of a variable into a table cell?

dap · May 12, 2016

Hello everyone!! 
I'm newbie using BIRT and I have a question for all of you experts!! 
I've created a table with 4 columns "A","B","C" and "D", column "D" is empty, I mean, no data, aggregation or text is in there whilst "A", "B" and "C" have an element from Data Set related to them. 
I'm trying to set a value from "A" into the column "D" through a script only if "B" and "C" meet a condition. This is the script (written over Cell "D"): 
cB = this.getRowData().getColumnValue("B"); 
cC = this.getRowData().getColumnValue("C"); 
if ((cB== 0) && (cC==1)) 
{ 
vA = this.getRowData().getColumnValue("A"); 
 
} 
As you can see I was able to write the condition and get the value from "A" if that condition is true, but I don't know how to set the value of "vA" variable into the cell "D". 
I hope you can help me. 
Thanks in advance.

kclark · May 12, 2016

Hi dap, if I understand the question correctly then you should be able to set a persistent global variable and then reuse it in your other column. I haven't tested this but using your example it should look something similar to this
<pre class="_prettyXprint _lang-">
cB = this.getRowData().getColumnValue("B");
cC = this.getRowData().getColumnValue("C");

if ((cB== 0) && (cC==1))
{
vA = this.getRowData().getColumnValue("A");
reportContext.setPersistentGlobalVariable("vA", va);
}
</pre>
Then, assuming the cell you want to add the value into is a label, you could use something like this, though it should be similar with a data element
<pre class="_prettyXprint _lang-">
this.text = reportContext.getPersistentGlobalVariable("vA");
</pre>

dap · May 13, 2016

<blockquote class="ipsBlockquote" data-author="kclark" data-cid="143837" data-time="1463076091">
<div>
 
Hi dap, if I understand the question correctly then you should be able to set a persistent global variable and then reuse it in your other column. I haven't tested this but using your example it should look something similar to this
<pre class="_prettyXprint _lang-">
cB = this.getRowData().getColumnValue("B");
cC = this.getRowData().getColumnValue("C");

if ((cB== 0) && (cC==1))
{
vA = this.getRowData().getColumnValue("A");
reportContext.setPersistentGlobalVariable("vA", va);
}
</pre>
Then, assuming the cell you want to add the value into is a label, you could use something like this, though it should be similar with a data element
<pre class="_prettyXprint _lang-">
this.text = reportContext.getPersistentGlobalVariable("vA");
</pre>
</div>
</blockquote>
 
 
Hi kclark,
 
Thanks for your help!!, I was able to display the value into the "D" cell but, correct me if I'm wrong, the displayed value is a string type, right?. If so, how can I convert the String value to a Time value so that I can take it to make some maths with it?????
 
Regards.

Clement Wong · May 17, 2016

Or you can create a new binding for Column D. You will be able to create an expression, and do the tests you need and return the appropriate data type that you need.

How to set a value of a variable into a table cell?

Comments

Categories