Data Set Filter Logic

mishra_yogita

<p>Hi All,<br>
     I have an report in which 'short' is an parameter. That contains three values 'null','Yes' and 'short' which are passed into coulumn 'shortqty' of dataset and if null and yes pass to the shortqty then it will shows all values of shortqty and if short passed then all values of shortqty will display except 'blank' and '0'.<br>
 I have wirte below code into filter of dataset with in clause.<br><br>
if (params["Short"].value==' ' && params["Short"].value==' Y' )<br>
{<br>
row["SHORTQTY"]<br>
}<br>
BUt for third case it is not working.</p>

JFreeman

<p>How about something like this:</p>
<pre class="_prettyXprint _lang-js">
if(params["Short"].value == "short"){
if(row["SHORTQTY"] != "" && row["SHORTQTY"] != "0"){
row["SHORTQTY"];
}
}
</pre>