PREFACE: Relatively new to Crystal; new to stored procedures.

ISSUE: Stored proc with parameters (runs fine in SQL Server Mgt Studio - returns records). Can't connect it to Crystal.

From Crystal when I go to select the SP I can see it, I select it in the left pane of SSMS, right arrow becomes active to move it to the right pane, I select it ... nothing happens and no error message. I've double-checked my query, googled quite a bit, can't seem to come up with a reasonable explanation. Any assistance would be greatly appreciated.

Connections, etc:
-----------------
SQL Server 2008 R2
Crystal Reports 2008
OLE DB (ADO) - MS OLE DB Provider for SQL Server

First time I've tried an SP (very simple):

ALTER procedure [dbo].[EmployeesNotTakenTool]
     @location nvarchar(40),
     @tool nvarchar (100)
     as
     
BEGIN

select distinct dbo.vw_EmployeeCertificationRecordDetail.EmployeeBadge,
dbo.vw_EmployeeCertificationRecordDetail.FullName,
dbo.vw_EmployeeCertificationRecordDetail.Shift,
dbo.vw_EmployeeCertificationRecordDetail.SuperFull,
dbo.vw_EmployeeCertificationRecordDetail.Location

from     dbo.vw_EmployeeCertificationRecordDetail

where dbo.vw_EmployeeCertificationRecordDetail.EmployeeBadge NOT IN (

select dbo.vw_EmployeeCertificationRecordDetail.EmployeeBadge
from dbo.vw_EmployeeCertificationRecordDetail
where dbo.vw_EmployeeCertificationRecordDetail.Location = @location and dbo.vw_EmployeeCertificationRecordDetail.CertificationName = @tool and dbo.vw_EmployeeCertificationRecordDetail.Status = 'Certified' and dbo.vw_EmployeeCertificationRecordDetail.Shift is not null)

and dbo.vw_EmployeeCertificationRecordDetail.Location = @location
and dbo.vw_EmployeeCertificationRecordDetail.Status = 'Certified'
and dbo.vw_EmployeeCertificationRecordDetail.Shift is not null
and dbo.vw_EmployeeCertificationRecordDetail.SuperFull is not null;

END

Edited by dlg_az - 13 Apr 2012 at 4:02pm

You can't pass multiple values in a param to a stored proc.

When I write a query for a command (not using a SP) and I want to filter on a list of items, I'll add to the where clause something like the following: