Skip to Content

Cascading dynamic drop down lists not showing all records

I am having issues with cascading dynamic drop down list not showing all the records when the drop down list equal or exceed 3 drop downs.

The database is SQL 2008 R2 SP2. The incorrect behavior is in Crystal Reports 2013 SP3 designer. I have tried using both a simple view, (pre-filtered to only have the data for the drop downs) and a simple Crystal command. The CR command is very simple:

Select field1, field2, field3 from Table1 This command is currently what is in use and it is not linked to any of the other report tables.

The behavior I am getting from Crystal is:

1st drop down - field1 total records with no parameters = 700

2nd drop down - field2 total records with field1 filter parameter = 80

3rd drop down - field3 total records with field1 and field2 filter parameters = 3

The drop downs should be:

1st drop down - field1 total records with no parameters = 700

2nd drop down - field2 total records with field1 filter parameter = 120

3rd drop down - field3 total records with field1 and field2 filter parameters = 14

As you can see the cascading is well below the 1,000 records, registry limit.

Running the command in a SQL query window with and without parameters, returns all the correct records.

Thanks

-Dennis

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2014 at 04:53 PM

    Hi,

    Can u pease try this in dev server :

    goto cmd and type regedit and look for

    CR 11 or CR 13

    [HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV]
    "MaxRowsetRecords"="5000" // previously 1000



    if CR 2008 then got

    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV] "MaxRowsetRecords"="5000"// previously 1000

    let me know how it goes..

    Add a comment
    10|10000 characters needed characters exceeded

    • This is a 64 bit Win 7 Pro machine.

      the path

      HKEY_CURRENT_MACHINE\Software\Wow6432Node\Business Objects\Suite XI 4.1\Crystal Reports\DatabaseOptions

      is valid except for it is 'Sap Business Objects' and 'Suite XI4.0'

      I added the LOV folder and the sting MaxRowsetRecords with a 20000 value.


      The path

      HKEY_CURRENT_USER\Software\Wow6432Node\Business Objects\Suite XI 4.1\Crystal Reports\DatabaseOptions

      is very different. It is

      HKEY_CURRENT_USER\Software\SAP Business Objects\Suite XI4.0\Crystal Reports\

      DatabaseOptions

      I added the LOV folder and the sting MaxRowsetRecords with a 20000 value.

      I rebooted my laptop


      Removed the textbox input parameters from the report. Created a 4 deep cascading dynamic drop down list using a CR command.

      The command retrieves the following in an SQL query window and in the Crystal drop down list

      Field 1 = 11 records no parameters - Crystal returned 11 records

      Field 2 = 93 records using Field 1 as a parameter - Crystal returned 87

      Field 3 = 1 record using Field 1 and Field 2 as a parameter - Crystal returned 1 record

      Field 4 = 27 records using Field 1, Field 2 and Field 3 as parameters - Crystal returned 24 records


      If I create a new CR report and drop on the CR command into the report, I get all the correct returns from Field 1 to Field 4.

      Frustrating as ####!

      -Dennis



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.