title: How to pass parameters in crystal report using SQL command database Expert
body: <p>I want to generate report by selecting the date from ~ To and want to pass those value to variable x and y written at the end of the query </p>
  
  <pre><code>SELECT accounts.invoice, tempClient.name, tempClient.businessName,
  tempClient.contactNumber,accounts.total, accounts.remaining
  FROM accounts
  INNER JOIN tempClient
  ON accounts.clientCode = tempClient.id where accounts.[dateTime] between ?x and ?y
  </code></pre>
  
  <p>Like</p>
  
  <p><a href="https://i.stack.imgur.com/jhY0q.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jhY0q.png" alt="Like This and try to save"></a></p>
  
  <p>But it gives me the error</p>
  
  <p>saying </p>
  
  <p><a href="https://i.stack.imgur.com/29Bxi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/29Bxi.png" alt="Please Help Thanks"></a></p>