Crystal Reports How To — SQL command — no value given for one or more required parameters

Crystal Reports How To — SQL command — no value given for one or more required parameters

This is a stupid question, but when you edited the Command, did you add the parameter object in the right-hand pane of the command editor? If so, did you then add the parameter into the SQL by double-clicking it from the right-hand pane?

Other issues to consider — what type of database and connection do you have? I had a client a few months ago that was using DB2 with an ODBC connection. Whenever I tried to modify a Command to add a new parameter, Crystal Reports would crash. I had to jump through hoops in order to get it to work. We were able to eventually resolve the issue by installing a service pack.

Reference: https://www.experts-exchange.com/questions/26490081/crystal-report-SQL-command-no-value-given-for-one-or-more-required-parameters.html