pass parameter to stored prodedure from crystal reports

[sreedivya]

Hi All
I am trying to create crystal reports. In this concern i have created a command which execute a stored procedure. This stored procedure takes three parameters which in turn i want to pass it from .aspx page. when i click on button parameters should pass to that stored procedure.
for example

exec sp_example @date='{?selecteddate}'

here date (varchar in stored procedure) and selected date (string type i selected) whenever i am adding this command in add command (which is there field explorer -> database fields) it's saying failed to open a row set.

syntax error for converting datetime to string.

if you have any idea please do reply.

[debasisdas]

You need to convert to proper type before processing.