Cascading Parameters not showing all values

[Quixote29]

I have been reading the forums, and I haven't yet found an answer to my question. This is the first time I have created a Cascading Parameter, so please forgive any misunderstanding.

I am on Crystal XI

All record information is in the SAME SQL view...no other tables or views are being used/joined.

Parameter A has 7 distinct values (dynamic), but only one is showing up as availible when the report is being run.... WHY?!?!? More importantly, how do I fix it? (I have used "browse data" to confirm the 7 values)

Parameters B, C, D are all acting the way they should assuming that their options change when I get all 7 values in Parameter A. Currently the options are correct for the ONE choice showing for Parameter A.

Help? Anyone? Bueller?

Thanks in advance!

 

[lbass]

So B,C,D are all additional cascading parameters? The resulting list of values cannot be greater than 1000, so if these additional levels result in more than that if more than one A value had been selected, then only one will show for selection. Is this a possibility in your situation? If so, there is a registry key that must changed in order to allow a larger pick list.

-LB

 

[Quixote29]

Correct. B,C,D are additional cascades. They should not produce more than 1000 options.

I did change my regitry settings anyway....but it did not produce any change in results.

 

[lbass]

I wonder if one of your later parameters only has values for certain values of A or if one of the fields used for a later parameter picklist can be null. I would test my removing one level at a time--or starting over and adding one level at a time.

-LB