SAP Knowledge Base Article - Public

1200183 - How to use a parameter in a SQL Expressions Fields in Crystal Reports?

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