<p>In my report query I have a where clause that needs to be replaced dynamically based on the data chosen in the front end.<br><br>
The query is something like :<br>
</p>
<p><em><select statement></em></p>
<p><em>where ?=?</em></p>
<p> </p>
<p> </p>
<p>I already have a code to replace the value - I created report parameter and linked to the value ? in the query. <br><br>
Example: <br><em><select statement><br>
where name=?</em></p>
<p> </p>
<p>Any value of name that comes from front end replaces the ? in the where clause - this works fine.</p>
<p> </p>
<p> </p>
<p>But now I need to replace the entire clause. Should I create two parameters and link them to both the '?' ?<br>
Can anyone help with this?<br><br>
Thanks !</p>
