Jump to: navigation, search

Crystal Report Default Value Records

Software product name Performance DNA
Version Number 8.5.x and below
Subject KB00004: Crystal Report Default Value Records

Symptoms

Crystal reports sets a default value for the number of records being returned to 1000, As such this means that you are only able to report on the 1st 1000 users entered into database. Reports won’t show any further users.

Resolution

To increase the maximum number of values for a dynamic parameter list of values, set the registry key: MaxRowsetRecords, to a value greater than 1,000:

Open the Microsoft Registry Editor, and navigate to the path corresponding to the version of Crystal Reports used:

Crystal Reports 2008: HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV

Crystal Reports 2011: HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV

Crystal Reports 2013: HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV

Crystal Reports 2016: HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV

Crystal Reports for Visual Studio 2010: HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions\LOV

Notes

Add the key: LOV, if it is not present. For 64-bit version of Microsoft Windows, the registry path will be slightly different, it will start with: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\

But the rest of the registry path is the same.

Add the String value: MaxRowsetRecords

Set the value of: MaxRowsetRecords to the maximum number of records in the table where the values are stored. If Crystal Reports application needs to scan 100 000 records to retrieve 20 000 parameter values, set the value to 100 000.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on August 8, 2018, at 10:50.