Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    houston
    Posts
    22

    Unanswered: anyone use stored procedures??????

    if anyone out there uses Crystal with stored procedures, i have a question.
    how do you get around forcing crystal interface to allow multiple value(s) in the parameter field.
    it automatically Greys out when i use a stored procedure.

    even if in the sql code i put:

    "where interval_type IN (i_interval_type)" ..........RATHER THAN ......"where interval_type = (i_interval_type)"

    if anyone knows a work around on this, i'd appreciate some assistance.
    thanks
    rik

  2. #2
    Join Date
    Dec 2005
    Posts
    1

    Looking for help for the same scenario

    Hi rik,
    Am also looking for a solution for the same scenario. If you happen to come across any soln/work around please let me know
    Regards
    Venu
    Quote Originally Posted by rikb53
    if anyone out there uses Crystal with stored procedures, i have a question.
    how do you get around forcing crystal interface to allow multiple value(s) in the parameter field.
    it automatically Greys out when i use a stored procedure.

    even if in the sql code i put:

    "where interval_type IN (i_interval_type)" ..........RATHER THAN ......"where interval_type = (i_interval_type)"

    if anyone knows a work around on this, i'd appreciate some assistance.
    thanks
    rik

  3. #3
    Join Date
    Oct 2003
    Location
    houston
    Posts
    22

    multiple values in the parameter field

    well, i've found a couple of answers on this. first of all Crystal is right in doing that. you can't bind that variable in Oracle, at least with a comma deliminted list. it doesnt understand it. one person suggested creating a Collection, but in the Ref Cursor im passing, it doesnt allow that either. i guess all the years of writing sql and using ::: where my_value IN('this','this','this','this') ........i simply took for granted.
    the only other solution is to use an or, but then you're limited to the number of or's you have.
    where my_value = (a_value) or my_value = (b_value) etc.
    i'm assuming that passig a null value wouldnt be a biggy but, its still not a list.
    so, i'm still in the hunt on this one.
    thanks
    rik

Posting Permissions

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