RE: SAP Crystal Reports 2008 Multi Parameter in Stored Procedure

[allyne]

I have a stored procedure that looks simular to the below.

Create Procedure sp_Customer

(@SalesPerson Nvarchar (Max))
as

Select c.customerID,c.LastName, c.FirstName,c.CompanyName,c.SalesPerson
from SalesLT.Customer c
where c.SalesPerson in (@SalesPerson)

I'm new to Crystal reports and I am unable to get the parameter in crystal reports to work as a multi select parameter. Is this possible? If so how can I get this to work?

Thanks for all your help!

 

[briangriffin]

I believe CR2008 introduced multiple value parameters in command objects. If so, create the report based on a command instead of the stored procedure:

Select
c.customerID,
c.LastName,
c.FirstName,
c.CompanyName,
c.SalesPerson

from SalesLT.Customer c

where c.SalesPerson = {?SalesPerson}

You would create the parameter in the command object and check the 'Allow multiple values' box.