multiple selection parameters to stored procedure

[willisa]

Is there a way of passing multiple selection parameters selection to a stored procedure?

 

[lyanch]

I haven't found one.

Lisa

 

[lyanch]

Actually that isn't true. You can "string" them together and then parse the multiple values out within the sp. Actually sending an array as a parameter to a sp is what I don't think you can do.

Lisa

 

[willisa]

Have you done that before? I would have thought that by the time you string it together it would have been to late to send to the stored procedure. I will give it a go though. I am assuming you string the parameter together in the report header

 

[lyanch]

No, you string it together when you enter it...

The user would enter it like:

1;254;64;526

for four separate number values (you can use any separator you want)

Then the SP would parse it.. sorry if I didn't make that clear.

Lisa

 

[willisa]

unfortunately I am doing this through crystal enterprise without building custom csp pages. So unless I did that its not going to work. Thanks for your time.