Not geting all database values from Cascading Dynamic Parameters

[Former Member]

I'm creating a CR2008 report where I need to setup a cascading dynamic parameter for users to select.  However, I ran into a dilemma where my first parameter is not populating all values in the drop down list.  I only have 6 values to select yet only 3 shows up.

Does anyone know what's wrong?  I use the same methodology to create other CR2008 reports utilizing cascading dynamic parameters and they all work fine except this one.  I've been so troubled by this all week and my end users pressuring me to fix this issue.

Any help out there would be greatly appreciated.  Thank you.

[abhilash_kumar]

Hi Fione,

CR limits the number of values displayed in the list to about 1000, for performance reasons.

It is strange that you're having this issue with just 6 records.

This is controlled via a registry key and you can try the following steps to see if it helps:

1) If you're using CR 2008 on a 64-bit machine, then open the registry editor and browse to:

HKEY_CURRENT_USER\Software\Wow6432Node\Business Objects\Suite 12.0\Crystal  Reports\DatabaseOptions

2) Create a new key (or folder) called 'LOV' here and then on the right-hand side create a new string value called 'MaxRowsetRecords' with a value higher than 1000, perhaps around 20000.

3) Repeat these steps on the HKEY_LOCAL _MACHINE hive as well.

If you're using a 32-bit machine then the path would be:

HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions

-Abhilash

[Former Member]

Thank you so much for the quick response.

But in my case I don't think it has anything to do with the Registry per se since I only have 6 values total.  Also, one thing worth mentioning is that I was able to see all six values when we were still using Lawson LSO 9.0.1.  This issue just started after we upgraded to LSO 10.0.2.

Is there any other way to resolve this issue other than messing up with the Registry?  I checked my current Registry & the MaxRowSetRecords is equal to 1000.  So is there any use to increase it to 20000?

[abhilash_kumar]

And do you see this issue within the CR Designer or a custom viewer?

-Abhilash

[Former Member]

I'm using CR Designer to create this report.