Skip to Content
author's profile photo Former Member
Former Member

Dynamic Cascading Parameter as Input for a Stored Procedure?

Hello,

Is there a way to use Dynamic Cascading Paramaters as Input for a Stored Procedure?

I have a Stored Procedure which has 3 Parameters that depend on each other.

Up to now, I found out how to use a Dynamic Parameter for one Parameter... but I wasn't able to cascade all three Parameters.

Thanks

Christoph

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2008 at 12:50 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.