Skip to Content
0
Jun 09, 2014 at 03:33 PM

Cascading dynamic drop down lists not showing all records

391 Views

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