I have not had much success trying to map a cascading prompt to existing parameters because it wants to create new ones for you, and it doesn't let you pick existing ones.
I have found a way around it, though it does have at least one limitation. I create a new blank report that has no datasource. I create the dynamic cascading prompts that I need and map them each to a parameter so that the value picked is captured. I then insert a subreport, and use the existing report that uses the stored proc. Link the two together, mapping the parameters from the main report to the subreport paramters.
The limitation that is that you Crystal won't let you have a subreport within a subreport. If you have subreport(s) in your existing report, this may won't be a good solution for you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.