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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on 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


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.