Dynamically Chnaging the values of a Data Set Grid

tinujoseph

I have a requiremnet of dynamically changing the the value of a Data Set Field , on checking the value of another Data Set Field. Please find the
screen shot attached.

In the Charge commission row , CHG_PAY_AC_NUMBER will be having a value in the JSP. If the CHG_LOCAL_PAY_.. field value is 0, i want to display the value of CHG_PAY_AC_NUMBER as N/A.

The Charge commission row, itself is a table, with only Detail row.

I am using XML Data source in my Birt Design . Values will be populated from the JSP page.

Please advice where can set the JS validation for this..

Also , If i am have the fields in a Data Set , is it possible to do a validation of those fields with the fields in the Birt design table with out adding to the table?

Please advice

Thanks in advance

bhanley

Instead of placing a data item in the report and trying to change that, just put a dynamic text item in its place. From there you can use scripting to determine what text to display.<br />
<br />
Something like this:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
var txt_to_display;
if(row["col_name"] == "value"){
txt_to_display = "new value displayed";
}
else{
txt_to_display = row["original_value"];
}

txt_to_display
</pre>