Symptom
- How to change the batch size?
- Crystal Reports dynamic prompt list of values are displayed in blocks of values. How to change the number of values per block?
- Dynamic Parameter Lists of Values are displayed in a list of pages, is there any way to change the number of values displayed per page?
- When refreshing a report in Crystal Reports, or in SAP BI LaunchPad, Dynamic Parameter shows the List of values in batches, how to display the List of Values in one single list instead of multiple groups?
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
- In Crystal Reports designer, create a report off any data source.
- Create a a Dynamic Parameter, and add it to the report.
- Save the report to the SAP BusinessObjects Enterprise Repository.
- Refresh the report in Crystal Reports, or in SAP BI LaunchPad.
When prompted by the parameter, notice that not all values displayed in one list, it displays in multiple batch.
How to only show one list with all the values?
Cause
- Large list of values for dynamic parameter are displayed in batch of 200 values.
Resolution
- There is no option to turn off the functionality of displaying dynamic parameter list of values in batch, but it is possible to increase the number of values per batch by modifying the following options:
- For Crystal Reports: PromptingLOVBatchSize
- For the SAP BusinessObjects Business Intelligence Platform: crystal_max_number_list_of_values
Therefore, to display all the values in one batch, increase the value of the batch to be greater than the maximum number of values you expect for your largest list of values.
WARNING The following resolution involves editing the Microsoft Registry. Using the Microsoft Registry Editor incorrectly can cause serious problems. Use the Microsoft Registry Editor at your own risk. For more information see the SAP Knowledge Base Article 1323322
- For Crystal Reports designer:
- Close the Crystal Reports designer.
- Open the Microsoft Registry Editor. ( regedit )
- In the Microsoft Registry Editor, navigate to the following path:
HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\ReportView
- Modify the value for the option: PromptingLOVBatchSize from the default value of 200, to a greater value like: 5000
- For SAP BusinessObjects Business Intelligence Platform 4.1, 4.2 and 4.3: ( Server )
- Login to the Central Management Console (CMC)
- Go to Servers.
- Right click on the server: "Report Application Server", and select "Properties"
- In the "Properties" window, increase the value for the option "Batches(Records)", from the default value of 200, to a greater value like: 5000
- Restart the Report Application Server.
- On the SAP BusinessObjects BI Server, navigate to the folder corresponding to the web application server used:
- For Tomcat:
<Installation directoty>\Program Files(x86)\ SAP BusinessObjects\Tomcat6\webapps\BOE\WEB-INF\config\default\
- For Netweaver Java:
<Installation directoty>\j2ee\cluster\apps\sap.com\BOEWEBAPPJAVA\servlet_jsp\BOE\root\WEB-INF\config\default
- Open the file: crystalReports.properties, in a text editor.
- Find the option: crystal_max_number_list_of_values
- Set the value of the above option from the default of 200, to a greater value like: 5000
- Save the file.
- Restart the Web Application Server.
- For SAP BusinessObjects Enteprise XI 3.1
- Login to the Central Management Console (CMC)
- Go to Servers.
- Right click on the server: "Report Application Server", and select "Properties"
- In the "Properties" window, increase the value for the option "Batches(Records)", from the default value of 200, to a greater value like: 5000
- Restart the Report Application Server.
- Stop the Web Application Server. ( Tomcat )
- Edit the web.xml from the below location:
<Install Drive>:\Program Files\Business Objects\Tomcat55\webapps\CrystalReports\WEB-INF\web.xml
- Search for the section:
<context-param>
<param-name>crystal_image_uri</param-name>
<param-value>crystalreportviewers</param-value>
</context- param>
- Add the following section after the one above:
<context-param>
<param-name>crystal_max_number_list_of_values</param-name>
<param-value>5000</param-value>
</context-param>
- Save the web.xml file.
- Restart the Web Application Server. ( Tomcat )
Keywords
CR, BOE, LOV , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , 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