Data Filtering design issue

howiejao

Hi,

In my report, I placed a simple filter on the Data Set ( row["status"].toString() in "Opened","Closed","Revised","Retired" ).
Now I need an additional filter added to above. I need filter on locationID should not be null if status = Closed.

Please kindly advise.

mwilliams

Try something like this, for the second filter's expression:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
if (row["status"] == "Closed"){
if (row["locationID"] == null){
false;
}
else{
true;
}
}
else{
true;
}
</pre>
<br />
Then, use the "Is True" operator. Let me know if this does what you're wanting.