SAP Knowledge Base Article - Public

1651124 - List of values does not prompt with data

Symptom

  • Some "On Demand"  LOV prompts do not have a list of values to select from, showing just an empty box to enter a value.
  • The same LOV prompt returns data when scheduled.  
  • On a multi node installation LOV prompts intermittently empty.

Environment

  • Crystal Reports 2008 and Business Objects Enterprise 3.1
  • SAP Crystal Reports 2011 and BI Platform 4.0
  • SAP Crystal Reports 2013 and BI Platform 4.1
  • SAP Crystal Reports 2016 and BI Platform 4.2

Reproducing the Issue

  1. Create a report with Dymamic List of values
  2. Refresh report and notice that LOV-s are empty, or sometimes filled sometimes not

Cause

  • CrystalReportsProcessingServerhas a setting, where the maximum number of records are limited. When the List of Values reaches the limit it fails to display data.   

Resolution

  • Set maximum number of records for CrystalReportsProcessingServer to 0 (for unlimited) for each nodes and CrystalReportProcessing servers in your environment
  1. Logon CMC
  2. Go to Servers->Crystal Reports Services
  3. Select CrystalReportProcessingServer -> Properties
  4. in section Crystal Reports 2013 Viewing and Modification Service set the Number of database records to 0

Keywords

Empty LOV box, Cascading parameter prompt, Dynamic Cascading Prompt, failed to populate data , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016