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

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

or

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