SAP Knowledge Base Article - Public

1218588 - How to increase the number of values for dynamic parameter list of values (LOV) in Crystal Reports? [Video]

Symptom

  • Dynamic prompt not populated with all values.
  • List of Values (LOV) is not showing everything.
  • Dynamic Parameter does not display all the values in the List of Values (LOV).
  • How to modify the maximum number of values available in a dynamic parameter in Crystal Reports?

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013   
  • SAP Crystal Reports 2016
           
  • SAP BusinessObjects Enterprise XI 3.1
  • SAP BusinessObjects Business Intelligence Platform (BI) 4.0
  • SAP BusinessObjects Business Intelligence Platform (BI) 4.1
  • SAP BusinessObjects Business Intelligence Platform (BI) 4.2

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Create a dynamic LOV parameter containing over 1,000 values.
  3. Insert the parameter on the report.
  4. When refreshing the report, notice it only display a maximum of 1,000 values.
               
    This is also true after saving the report to the SAP BusinessObjects BI Platform and viewing the report in InfoView or SAP BI Launchpad.

Cause

  • For performance reasons, the maximum number of values that are returned for a List of Values (LOV) in Crystal Reports is set to 1,000.

Resolution

  • To increase the maximum number of values for a List of Values (LOV), you can either:
     
    • Increase the value for the Registry Key: MaxRowsetRecords; or
    • Add the environment variable: BOE_CRLOVMAXSIZE
         
        
  • Registry Key Solution
      
    To increase the maximum number of values for a List of Values (LOV), set the registry key: MaxRowsetRecords, to a value greater than 1,000:

    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
       
    1. Open the Microsoft Registry Editor (regedit)
         
    2. In the Microsoft Registry Editor, navigate to the path corresponding to the version of the product used:
             
      • Crystal Reports 2008:   
               
        • 32bit version of MS Windows: 
          HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV   
                   
        • 64bit version of MS Windows: 
          HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV
                
                           
      • Crystal Reports 2011, 2013, 2016:
             
        • 32bit version of MS Windows: 
          HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV
             
        • 64bit version of MS Windows: 
          HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV
             
                         
      • Crystal Reports for Visual Studio 2010:
           
        • 32bit version of MS Windows: 
          HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions\LOV
           
        • 64bit version of MS Windows: 
          HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions\LOV
             
                            
      • SAP BusinessObjects Enterprise XI 3.1:
           
        • 32bit version of MS Windows: 
          HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV
            
        • 64bit version of MS Windows:
          HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV
                 
            
      • SAP BusinessObjects Business Intelligence Platform 4.0, 4.1, 4.2:
                   
        • 64bit version of MS Windows:
          HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV
               
                    
      • NOTES:  Add the key: LOV, if it is not present. 
               
                  
    3. Add the String value: MaxRowsetRecords
              
    4. Set the value of: MaxRowsetRecords to the maximum number of records in the table where the values are stored. 
                                       
      IMPORTANT NOTES:
      The higher the number of values set, the longer it will take to see the dynamic parameter prompt screen. In brief, it impacts the performance.
      - The value 0 (unlimited), or any value less than 1, will not work with BusinessObject Enterprise XI 3.1 or SAP BI 4.0, 4.1 and 4.2 (including Crystal Reports Server), you must specify a value equal to or greater than 1.
                      
    5. For the change to take effect, restart the application.
      • For Crystal Reports: close and reopen Crystal Reports.
      • For SAP BusinessObjects Enterprise 3.1 and SAP BusinessObjects BI 4.0, 4.1 and 4.2, restart the Server Intelligent Agent (SIA)
         
         
            
  • Environment Variable Solution for SAP BusinessObjects Enterprise or for the SAP BusinessObjects Business Intelligence Platform
    1. In MS Windows, create a system environment variable named: BOE_CRLOVMAXSIZE
         
    2. Set the value of: BOE_CRLOVMAXSIZE, to the maximum number of records in the table where the values are stored. 
          
      For example 5000:
               
          BOE_CRLOVMAXSIZE = 5000
                   
      IMPORTANT NOTES:
      The higher the number of values set, the longer it will take to see the dynamic parameter prompt screen. In brief, it impacts the performance.
      - The value 0 (unlimited), or any value less than 1, will not work with BusinessObject Enterprise XI 3.1 or SAP BI 4.0, 4.1 and 4.2 (including Crystal Reports Server), you must specify a value equal to or greater than 1.
      - This will override the registry key value if present.
            
    3. For the change to take effect, restart the application, restart the Server Intelligent Agent (SIA)
       

 

Media not computed.

See Also

  • To modify the maximum number of values available in a dynamic parameter list on UNIX system, see to the SAP Knowledge Base Article 1219715
         
  • The registry key: MaxRowsetRecords, does not affect the List of Values returned when a report is based off:
    - Universe or 
    - SAP BW BEx Query.
       
    For Universe List of Values, see the SAP Knowledge Base Article 1195974  
    For SAP BW BEx Query, there is no option to increase the List of Values.

Keywords

Parameter, LIST OF VALUES, LOV, PICK LIST, PICKLIST, NUMBER OF VALUES, CASCADING, Crystal Reports Dynamic and cascading prompts Parameter pick list limitation limit max MaxRecordsReturned,  MaxRowset, , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016