<p>Hello,</p>
<p> </p>
<p>I have to make a birt report with about 4 variables which should be used in query but not in standard way:</p>
<p>select * from table where field1=? and field2=? and field3=? and field4=?</p>
<p>but I need some conditions e.g.</p>
<p>if (var1 == null) {</p>
<p>select * from table where and field2=? and field3=? and field4=?;</p>
<p>}</p>
<p>if (var2 == null) {</p>
<p>select * from table where and field1=? and field3=? and field4=?;</p>
<p>}</p>
<p>etc...</p>
<p>It is possible to make such dynamic "where clause" in Birt ?</p>
<p> </p>
<p>I use Eclipse BIRT Designer Version 2.6.2.<br><br>
Thanks in advance for any help<br><br>
Adam<br>
</p>
<p> </p>
