How to pass parameters in crystal report using SQL command database Expert
<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>