Skip to Content

Not geting all database values from Cascading Dynamic Parameters

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 18, 2015 at 06:05 AM

    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


    Add comment
    10|10000 characters needed characters exceeded