Cascading dynamic drop down lists not showing all records

[Former Member]

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

[Former Member]

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..


[Former Member]

this is CR 2013. It does not have maxrowsetrecords or even just maxrow in the registry. This is why I indicated the max records for the first drop down are less then a 1,000.

-Dennis

[abhilash_kumar]

Hi Dennis,

Is the machine 64-bit or 32-bit?

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

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

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.

Do this on the HKEY_LOCAL _MACHINE hive as well.

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

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

-Abhilash

[Former Member]

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