SAP Knowledge Base Article - Public

2181815 - How to display more than 1,000 values for a prompt for reports created in Crystal Reports based on a Universe?

Symptom

  • How to show all the values in the prompt, instead of batch of 1,000?
  • How to display more than 1,000 Values in one single drop-down list for a parameter prompt, instead of groups / batches, for reports created in Crystal Reports based on a .UNV Universe?
      
        
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
      
  • SAP BusinessObjects Business Intelligence platform 4.1
  • SAP BusinessObjects Business Intelligence platform 4.2
  • SAP BusinessObjects Business Intelligence platform 4.3

Reproducing the Issue

  • Reproducing the Issue with Dimension object:
    1. In Crystal Reports, create a new report based on Universe(UNV) datasource.
    2. Login to Repository and select the Universe.
    3. Take some Objects (Dimension, Measure) to the Result Objects area
    4. Then add a Dimension object to Query Filter area which is contains more than 1000 value.
    5. Select the Prompt operator type and check the Select only from list in Filter Editor window
    6. List of Values are displaying in batches and groups and not more than 1000 values are displayed
         
      CRFilter_Editor.png CRBatchesGroups1.png

 

  • Reproducing the Issue with @Prompt function condition object:
    1. In Crystal Reports, create a new report based on Universe(UNV) datasource.
    2. Login to Repository and select the Universe
    3. Take some Objects (Dimension, Measure) to Result Objects area.
    4. Then add a @Prompt function conditon object (which has created on Universe side) to Query Filter area which is contains more than 1000 value.
    5. List of Values are displaying in batches and groups and not more than 100 values are displayed
         
      CR_PromptCondi.png

Cause

  • By design, to ensure a list of values shows in the parameter prompt window in a timely manner, batch of 1,000 values are shown. 

Resolution

  • To display all the values for a parameter, instead of showing batch of 1,000 values, perform the following:
    1. Increase the 'PromptingLOVBatchSize', value as per the SAP Knowledge Base Article: 1652210
       
    2. Increase the ' QPMaxLOVSize' value, as as per SAP Knowledge Base Article: 1706213

  • After increasing the values, when being prompted by a Universe parameter, it will show all the values in the prompt dop-down.

Keywords

SAP Crystal Reports 2011, CR2011, SAP Crystal Reports 2013, CR2013, Prompt, condition, filter, LOV, groups, batches, universe, UNV, increase, maximum, limitation, 200, 1000, , 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