Skip to Content
0
Former Member
Jan 24, 2023 at 09:19 PM

Cascading Parameter list pulled from server incomplete

62 Views Last edit Jan 26, 2023 at 05:48 PM 2 rev

I have a problem with a Cascading Dynamic parameter.

I set up a stand alone dynamic parameter, pointed it to a specific value (METHOD) on a table (RUNS) on my data server. When set up like this, it correctly pulls a full list to populate the Dynamic Parameter. (See the left side of the screenshot.)

However, if I set it up as a Cascading Dynamic parameter, using the same source, it only pulls a partial list. (See the right side of the screenshot.)

image.png

The single dynamic parameter setup:

image.png

and here is the Cascading Setup:

image.png

Both setups have the same setup in the formula section. The only real difference is the parameter names. This one shown below is from the independent Dynamic parameter setup.

image.png

I tried changing settings for the "Join" between tables, but that had no effect.

I am using Crystal Reports 2016, Support pack 9 patch 4 (version number 14.2.9.4008.)

**Edit**

An odd thing happened. I updated the second of the parameters from RUNS.RUNNO to RESULTS.RUNNO and the list for the first parameter, RUNS.METHOD, increased by 9 lines. The list is still not as big as if I did the first parameter without a second parameter, but it did grow a little. See below.

image.png

Attachments

image.png (72.2 kB)
image.png (24.8 kB)
image.png (29.4 kB)
image.png (28.2 kB)
image.png (21.8 kB)