Dynamic parameters with stored procedure RRS feed

  • Question

  • User2073733224 posted


    I have a crystal report uses stored procedure. This stored procedure has 2 parameters - @year and @state. The list of states depends on what year is selected - it dynamically changes. I would like to use the built-in dynamic cascading that is available with Crystal 2008. But I am not able to bind the existing parameters to the dynamic lists of values that I create in Crystal. Crystal always creates additional parameters. Is there a way how to connect the existing parameters to the list of values?

    Thank you for any ideas.


    Sunday, February 22, 2009 4:03 AM


  • User2073733224 posted


     I found all my answers in this document:


    Page 21 has a step by step. I got a little confused by the names Crystal Reports gives the parameters when the prompt is used for the first time ("@State - state" , "@Yr - yr") - I would assume it uses the name of the parameters (@State, @Yr) but when you close the Edit dialog and then reopen it, the names are correct.


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, February 22, 2009 9:42 AM