Symptom
- Unable to add a parameter to a SQL Expression.
- Can you pass a Crystal Reports parameter through a SQL Expressions Fields?
Environment
- SAP Crystal Reports 2008
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
Cause
- By design, Crystal Reports does not allow passing a parameter value in a SQL Expression Fields.
Resolution
- To workaround this limitation, the suggestion will be to use a Command Object where you can manually write the whole SQL Query. In a Command Object, it is possible to use the parameter direcly in the SQL Query.
Keywords
SQL, Expressions, Parameter, Crystal Reports , 5270990 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016