SAP Knowledge Base Article - Public

1845161 - List of values prompt empty for Dynamic Parameter, as well as Static Parameter, in Crystal Reports

Symptom

  • No List of Values (LOV)
  • Parameter has no drop-down list.
  • Parameter prompt box empty in Crystal Reports.
  • Parameter with a Dynamic List of Values, and Parameter with a Static List of Values, does not display any values when prompted.
  • Parameter prompt screen window "Cancel" and "OK" button does not do anything when clicking on it.

Environment

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

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Add a Dynamic Parameter, or a Parameter with a static List of Values.
  3. Add the parameter to the report.
  4. Refresh the report.
  5. Notice th Parameter prompt box does not have any values.
    Also, the "Cancel" and "OK" button are not functional.

Cause

  • Parameter prompt screen in Crystal Reports uses JavaScript to display the list of values, and buttons.
  • The reason it does not display any List of Values, and the buttons are not functional on the parameter prompt screen, it's because scripting is disabled on the computer.

Resolution

  • Enable Active Scripting in the Internet Options:

    1. In MS Windows, open the Internet Options

      1. In MS Windows search bar, search for: Internet Options
      2. In the search result, click on: Internet Options
           
    2. In "Internet Properties", select the tab "Security"
        
    3. Under "Select a zone to view or change security settings", select: "Local intranet"
        
    4. In "Security level for this zone", click on "Custom level..."
         
    5. In "Security Settings - Local Intranet Zone", scroll down to the section: "Scripting"
        
    6. Under "Scripting", enable the option: "Active Scripting"

    7. Click "OK"
        
    8. Back to "Internet Properties", click: "Apply"

    9. Then click: "OK"                             
            
  • NOTE: If it does not help, contact your IT Administrator, as this setting can be controled by your company global setting, and they may have chosen to disable scripting.

Keywords

CR, LOV , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

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