Skip to Content
0
Former Member
Jun 29, 2007 at 12:33 AM

Pass multiple values from 1 parameter to a stored procedure?

18 Views

Post Author: Rdev

CA Forum: Data Connectivity and SQL

I have a Crystal Reports 11 report that uses a SQL stored procedure to access records from some views. I need to pass 1 or many ContactID values to the stored procedure so that the record filtering happens on the stored procedure side, not in Crystal Reports. ContactID is an integer data type.

What do I need to do on the Crystal reports side to pass multiple ContactID's to the stored procedure and how should my stored procedure be created to accept multiple ContactID values from Crystal Reports?

I have searched all over for an answer but have not found one that works for me.

Any help will be appreciated and if you could point me to some examples, that would also help me.

Thanks in advance,

Rdev