Passing a dynamic parameter to a stored procedure in crystal reports

See more:

CrystalReports

I have a crystal report from my ERP vendor and I am trying to add a field to it that exists in a table that isn't one of the tables currently being used by the report.

It is not a simple task of editing this report to add the required tables so the field can be included, so I thought that perhaps I could add a stored procedure to the report and pass to it one of the fields that is part of the report, which it turn would provide me with the field's value that I want to include.

This is, for every record that is being displayed in the report, the stored procedure would be called passing a field from each record, and I would get back the additional field I want to include in the report.

Can you pass a dynamic parameter to a stored procedure in CR that isn't a report parameter ?

What I have tried:

CREATE PROCEDURE [dbo].[q_GetCOO_byItemID]
@ItemID varchar(max)


AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	select country_of_origin from inventory_supplier
	inner join inventory_supplier_x_loc
	on inventory_supplier_x_loc.inventory_supplier_uid = inventory_supplier.inventory_supplier_uid
	inner join inventory_supplier_trade
	on inventory_supplier_trade.inventory_supplier_uid = inventory_supplier.inventory_supplier_uid
	inner join inv_mast
	on inv_mast.inv_mast_uid = inventory_supplier.inv_mast_uid
	where inv_mast.item_id = @ItemID and primary_supplier = 'Y' and location_id = '10'
END