support stored procedures with input values for details (on demand) data tables

In short, wants to be able to use stored procedures that require input values for the data tables for details (on demand) plots, with the input values coming from the identifiers in the marking the data on demand data is based on.


I problem description:
"I have created two information link based on SQL Server stored procedure.
1-GetMonthlyCampaignStatus
return data table (cmp_id,cmpName )
2-GetCampaignDetail
Take input Parameter "cmp_id"
return data table (cmp_id,campaignResponses )
I have created a relation between the two data table
GetMonthlyCampaignStatus.cmp_id=GetCampaignDetail.cmp_id
Problem
-------
I want to create Detail Visualization of GetMonthlyCampaignStatus
How I passed the cmp_id from datatable "GetMonthlyCampaignStatus" to "GetCampaignDetail" stored procedure(as it takes input parameter cmp_id)so that only selected data will be returned by SQL Server instead of all data.
Is reletion automatically send the value of cmp_id from "GetMonthlyCampaignStatus" to "GetCampaignDetail" when we create detail visualization or we have to pass this value by some other way?
I have created detail visualization but it didnot work which seems i have to pass value of cmp_id from "GetMonthlyCampaignStatus" to "GetCampaignDetail".But how ????"

{noformat}