Restricting the selection of Crystal Reports options?
I am trying to render a Crystal Reports 11 report from an Oracle database grouped by user. I have over a thousand users. I want to create a parameter field that will prompt a person to select the users for whom they would like to view results. However, my options box only shows 221 possible users. Users are displayed in alphabetical order due to the SQL Order By statement. I'm wondering if there is a limit to the number of dynamic defaults that a parameter field can store. Any help with this would be great.
source to share
The default limit in Crystal 11 is 1000 (stored in the registry key HKEY_LOCAL_MACHINE \ SOFTWARE \ Business Objects \ Suite 11.0 \ Crystal Reports \ DatabaseOptions \ LOV \ MaxRowsetRecords), so your problem may be in the construction of the parameter itself. Make sure it is a dynamic parameter field that will query the database when using it, as the odd number of values shown makes me think it is a list generated when the report is first run and saved, and therefore in a list of static parameters.
source to share
I tried to reproduce your situation using a database table with 5000+ records.
In this field, I created a dynamic parameter (Crystal Reports XI R3, full version). He created a unique list of values, which turned out to be about 1000 (I started counting it, but estimated its total size based on the position of the scroll bar).
I added an entry to the system HKEY_LOCAL_MACHINE \ SOFTWARE \ Business Objects \ Suite \ Crystal Reports \ DatabaseOptions \ LOV \ MaxRowsetRecords (String) and set its value to -1.
LoV included all values when the registry entry was changed.
When LoVs had a writing limitation, it turned out that samples from each letter of the alphabet were indiscriminate. Perhaps this is what you are facing.
source to share
The following is a description of Crystal Reports 2013.
-
Add a new registry entry:
- For 32-bit computer
HKEY_HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions
- For 64 bit computer (Wow6432Node note)
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions
-
Add a new key at this level:
\LOV
-
Add a line titled
MaxRowsetRecords
-
Set the value to whatever constraint you want, I chose
100000
in design. (0
or-1
, which means all values, is no longer supported.) -
After making changes to the registry, restart the affected service or application as needed.
source to share
Just to clarify, the MaxRowsetRecords value is NOT one of the different parameter values that you can choose from. This is the maximum number of records that Crystal looks at from which it retrieves dynamic parameter values. Chances are, if you look at your query, you will find that the first 1000 records contain 221 unique values. Apply the registry change to more and you should see more parameter values from which you can choose.
source to share