title: Birt Report Parameter as WHERE-Clause
body: <p>I have a BIRT-Report in which I want to show a certain amount of data (Hi Capt. Obvious). So far so good. Now the data lies within a MSSQL database and I'm connecting to it with a jdbc driver, this all works perfectly. </p>
  
  <p>The problem is now that I want to pass a "query" Report parameter to this report. I know how to pass parameters to a report in the following fashion:
  Query:</p>
  
  <pre><code>SELECT * FROM table WHERE field = ?
  </code></pre>
  
  <p>And then you define the parameter in the Dataset-Parameters.</p>
  
  <p>Now what I want to do is the following:</p>
  
  <pre><code>SELECT * FROM table ?
  </code></pre>
  
  <p>Where my parameter contains something like</p>
  
  <pre><code>WHERE field1 = 'xyz' AND field2 = 2
  </code></pre>
  
  <p>The problem is that BIRT automatically adds a single quote in the beginning and in the end of every String-Parameter so that the final query looks so:</p>
  
  <pre><code>SELECT * FROM table 'WHERE field1 = 'xyz' AND field2 = 2'
  </code></pre>
  
  <p>This leads to MSSQL not being able to handle the query for obvious reasons.
  How can you fix this?</p>
  
  <p>Thanks in advance</p>