I have a complex Crystal Report to do against 2 tables that have no distinct relationship. In order to get the information out of the 2nd table, I created a stored procedure that accepts a parameter. I then created a report that pulls the 1st tables information. I created a sub-report that calls the stored procedure. However I do not know how to take the linked filed from the main report and pass it into the stored procedure.
Can someone please provide me with some step-by-step instructions on how to pass the linked field to the stored procedure?
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
-- Author: Bill Mannion
-- Create date: 7/6/09
-- Description: Survey Report Data Gather for Selection Criteria
[dbo].[spGetGHCSurveyInfo] (@MeetingTitle VarChar(150) )AS
SET NOCOUNT ON;
select * from vwKnowledgeResultDetails
Where KnowledgeResultID in (select vwKnowledgeResultDetails.KnowledgeResultID
where vwKnowledgeResultDetails.KnowledgeAnswerValue LIKE '%'+@MeetingTitle+'%')