SAP Knowledge Base Article - Public

1218646 - How to delete a dynamic parameter in Crystal Reports?

Symptom

  • Unable to delete a dynamic parameter.
  • A report contains a dynamic parameter based on a List of Values (LOV) stored in the SAP BusinessObjects Enterprise Repository. When attempting to delete the dynamic parameter from the report , it fails.
  • How can you delete a dynamic parameter from a report in Crystal Reports?

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020 

Reproducing the Issue

  1. In Crystal Reports, open a report that contains a dynamic parameter.
  2. When attempting to delete it, it fails. 

Cause

  • The parameter cannot be deleted, because it reference a List of Values (LOV) stored in the SAP BusinessObjects Enterprise Repository.

Resolution

  • To delete the Dynamic Parameter in Crystal Reports:
      
    1. In Crystal Reports, open the report.
          
    2. Remove all the references of the parameter from the report. 

      NOTE: You can tell if a parameter is in used by viewing the parameter name in the Field Explorer.  If there is a green check mark next to it, then the parameter is in use. In which case, look if the parameter is used in the Record Selection, or on the report to display the values, or in a Formula,... and remove all the references.
         
    3. Right-click the parameter in the Field Explorer and click 'Edit'.
         
    4. Change the List of Values from 'Dynamic' to 'Static'.
        
    5. Click 'OK'

    6. Right-click the parameter in the Field Explorer and click 'Delete'.
         
        
      The parameter is now deleted from the report.

Keywords

DYNAMIC PARAMETER DELETE LIST OF VALUES LOV REMOVE PARAMETERS Crystal Reports Dynamic parameter List of Values , c2017271 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020