Crystal XI R2 Cascading Prompts Question

[SundancerKid]

Hi ALL,

I have a Description Table with approxmiately 90,000 records in it.

I would like to break that up into smaller chunks so that it is not a drain on performance.

So I created a cascading prompt i.e..
Status (Level 1) Value (...ALL/Active/InActive)
Substring(DescID,1,3) (Level 2) Value (010, 011, 012)
DescID (Multi Value) (Level 3) Value(010111111, 010222222, 010333333)
Value(011111111, 011222222, 011333333)
Value(012111111, 012222222, 011333333)

When I select the Level 2 I am able to filter the first 3 characters and then Level 3 brings back information based upon Level 2.
I then add my selection to the Selection Values for Level 3 and then go back to Level 2 to get more selections my Selection Values in Level 3 is cleared.

Does anyone know a way aroung this situation?

 

[lbass]

That's not the way cascading prompts work. You have to choose all desired values at the highest level1, which then creates the picklist for those values at level2. The selections at level2 determine the picklist at level3, etc. There is no way to make selections, store them, change the selections and then add those new results to the original selections.

-LB