Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2009
    Posts
    2

    Unanswered: Get parameter to SQL stored procedure

    I'm a newbie using CR10. I'm creating a report from SQL stored procedure. How can I get a parameter value and send to a variable in the stored procedure?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    If the stored procedure accepts parameters then it should prompt you for these values when you pick it as the data source?
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2009
    Posts
    2
    In store procedure, it's a declared variable. Crystal report doesn't pick up this variable. What can i do?

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    You'll have to make the stored procedure parameterised!
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •