SAP Knowledge Base Article - Public

1866131 - Limited dynamic LOV for command object Crystal Report


Dynamic list of values for Command object connected report does not populate all the values


Crystal Reports 2011

Reproducing the Issue

  1. Create command object Crystal report with hundred thousands of records
  2. Add a dynamic parameter based on Command object field
  3. Refresh the report
  4. Parameter prompt does not populate all the values


There is a Default limit of 1000 records to review for a List of Values. Crystal Reports populates only distinct values from the first 1000 records of the ResultSet


There are two workaround solutions for the limitation:

I. Follow the KBA 1218588 to increase the limit


II. Modify report:

  1. Create a separate Command object with Select Distinct clause for the value
  2. Add the new Command Object to the report and make sure the new Command is not linked to the original Command object
  3. Modify the original parameter to get values from the new Command object
  4. Make sure the new Command object fields are not used anywhere else in the report 



limit, maximum, prompt, LOV, batch, packet, Command , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem


Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011