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:
- In Crystal Reports, create a new report based on Universe(UNV) datasource.
- Login to Repository and select the Universe.
- Take some Objects (Dimension, Measure) to the Result Objects area
- Then add a Dimension object to Query Filter area which is contains more than 1000 value.
- Select the Prompt operator type and check the Select only from list in Filter Editor window
- List of Values are displaying in batches and groups and not more than 1000 values are displayed
- Reproducing the Issue with @Prompt function condition object:
- In Crystal Reports, create a new report based on Universe(UNV) datasource.
- Login to Repository and select the Universe
- Take some Objects (Dimension, Measure) to Result Objects area.
- Then add a @Prompt function conditon object (which has created on Universe side) to Query Filter area which is contains more than 1000 value.
- List of Values are displaying in batches and groups and not more than 100 values are displayed
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:
- 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