locked
Dynamic parameters with stored procedure RRS feed

  • Question

  • User2073733224 posted

    Hi,

    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.

    eLK

    Sunday, February 22, 2009 4:03 AM

Answers

  • User2073733224 posted

     Alright,

     I found all my answers in this document:

    https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0784cb0-8a1e-2b10-4588-fb1156be10bc

    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.

    eLK

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