on 09-17-2008 11:33 AM
Hi All
In Crystal Reports XI developer I need to be able to select from 12u2019700 records in our SQL 2005 DB but crystal is only showing a small amount of our suppliers?
Is their a setting I can change to get all the records?
I canu2019t use dynamic cascading menus as our CR server XI is corrupting the menu so I canu2019t limit the selection criteria?
Many thanks for any support given
Hi Simon,
If you are using a Dynamic Parameter, then by default it will only display the first 1000 values.
To change this, you will need to modify a registry key.
Consult the following SAP Note for further information on how to change the registry key:
[1218588 - How can you increase the number of values in a dynamic parameter list?|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3132313835383826]
If you are not using a parameter, can you clarify what steps you use that display a limited number of values.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Patrick
Thanks for the reponse
I can't get a login for the fix information any chance you could post the details from that page here please?
Many Thanks
Simon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Simon
Here are the details of the Note that is mentioned in the last post:
Symptom
For performance reasons, in Crystal Reports XI Release 1 and Release 2 the maximum number of values that are returned for a list of values is set to 1000. If you have a cascading List of Values (for example Country > Region > City), the lowest level (in this case City) will only display a maximum of 1000 values. This means that the higher-level prompts may display far fewer values than you expect. The list of values provides the data for the dynamic parameter list.
How can you modify the maximum number of values available in a dynamic parameter list?
Resolution
To increase the maximum number of values available in a dynamic parameter list, you must add a registry key.
CAUTION
The following resolution involves editing the registry. Using the Registry Editor incorrectly can cause serious problems that may require you to reinstall the Microsoft Windows operating system. Use the Registry Editor at your own risk. For information on how to edit the registry key, view the 'Changing Keys and Values' online Help topic in the Registry Editor (Regedit.exe).
It is strongly recommended that you make a backup copy of the registry files (System.dat and User.dat on Win9x computers) before you edit the registry.
Crystal Reports XI Release 1
Create a registry key HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV.
NOTE
Alternatively, you can create the registry key HKEY_CURRENT_USER\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV and that key will override the settings of the HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV key.
Add a string value "MaxRowsetRecords" and set the value to the maximum number of values that you desire for your report. For example, a value of 2000 will return up to 2000 values in the lowest level of a cascading parameter. NOTE: The value 0 (Unlimited) will not work with BusinessObjects Enterprise XI or Crystal Reports Server XI, you must specify another value.
NOTE
The higher the number of values is, the longer it will take the Enter Values dialog box to populate with values.
After making changes to the registry, restart the affected service or application as required.
Crystal Reports XI Release 2
Create a registry key HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.5\Crystal Reports\DatabaseOptions\LOV.
NOTE
Alternatively, you can create the registry key HKEY_CURRENT_USER\SOFTWARE\Business Objects\Suite 11.5\Crystal Reports\DatabaseOptions\LOV and that key will override the settings of the HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.5\Crystal Reports\DatabaseOptions\LOV key.
Add a string value "MaxRowsetRecords" and set the value to the maximum number of values that you desire for your report. For example, a value of 2000 will return up to 2000 values in the lowest level of a cascading parameter.
NOTE
The value 0 (Unlimited) will not work with BusinessObjects Enterprise XI or Crystal Reports Server XI, you must specify another value.
After making changes to the registry, restart the affected service or application as required.
Additional Information
This document is not applicable for reports based on Universes. These registry keys do not affect the List of Values returned when a report is based on a Universe. See knowledge base article 200603.
To modify the maximum number of values available in a dynamic parameter list on UNIX, refer to knowledge base article c2018918.
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 , c2017238
Header Data
Released on 19.06.2007 16:50:24 by Norleen Scott (I819035)
Current Release Status Released to Customer
Target Release Status Released to Customer
Responsible Norleen Scott ( I819035 )
Category How To
Application Area BOJ-ERQ-CR
Product Version BOBJ ENTERPRISE XI R2
CRYSTAL REPORTS XI R2
BOBJ ENTERPRISE XI
CRYSTAL REPORTS XI
Other Properties
Business Objects Article ID c2017238
Business Objects ProductFamilyMajorVersion BusinessObjects Enterprise XI
Crystal Reports XI
Business Objects ProductName BusinessObjects Enterprise
Crystal Reports
Business Objects ProductMajorVersion BusinessObjects Enterprise XI
Crystal Reports XI
Business Objects BuildVersion 11.0.0.0
11.0.2.x
11.1.0.0
11.2.0.0
11.3.0.0
11.5.0.0
Business Objects SupportQueue Design
Business Objects ProductLanguage English
Hope this helps
Shraddha
User | Count |
---|---|
78 | |
9 | |
8 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.