Link to home
Start Free TrialLog in
Avatar of ebi168
ebi168

asked on

BusinessObjects Enterprise XI: List of values trim

Hi,

The list of values has a long list so records get trimmed off. Only partial records are shown in the list. I did changed the registry key to 0 on the server and on my machine but nothing happened, can anyone tell me why. Do we need to restart the machine for changes to happen? Thanks

from business objects knowledge base:

A registry sub key value of zero will return all List of Values' values.
====================

Registry Entry Information
-------------------------------
Subkey: HKEY_CURRENT_USER/Software/Business Objects/Suite 11.0/Crystal Reports/Database/QPMaxLOVSize
Type: DWORD
Default Value: 1000
Avatar of Kurt Reinhardt
Kurt Reinhardt
Flag of United States of America image

You may need to restart the BusinessObjects Enterprise XI servers.

Also, are you using the Advanced DHTML viewer?  Similar issues have occurred with it with past versions of Enterprise.  In this case, BusinessObjects recommends using either the ActiveX or Java Viewers.

~Kurt
Avatar of ebi168
ebi168

ASKER

Just to be more precise, restart the machine or restart the BO services. I am not sure what viewer used, do you know how to check.
SOLUTION
Avatar of Kurt Reinhardt
Kurt Reinhardt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ebi168

ASKER

I just find the registry I should change is:

key HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV\MaxRowsetRecords

and set the value to the maximum number of values that you desire for your report.

The value of MaxRowsetRecords is 1000 by default so I changed it to a much larger value. Now the list gets extended but there are some alien numbers added to the list also, e.g. and still not all values are on the list. Do you know where the problem is.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial