Skip to Content
0
Former Member
Feb 16, 2010 at 04:56 PM

MultiSelect Parameter with Stored Procedure not working

61 Views

I am using Crystal Reports 2008 and SQL Server 2008. I am using a stored procedure which works with a multiselect in SQL side. I am using a string to table utility function in the where clause with the In statment like below:

WHERE FORMULARY_ID in

--(@FORMULARY_ID)

(SELECT Extractedtext

FROM ClarityTST.[rpt].[LHfn_StringToTable]( @FORMULARY_ID, ',') )

When I try to use the stored procedure I get an error message:

"The stored procedure cannot accept multiple values. Please ensure that the multiple value is set to False:"

I would like to use it with multiple parameters.