Subreport parameterized query

[Sean Beaulac]

I followed the video tutorial on creating parameterized queries for reports but i'm having trouble replicating it for SubReports. 
The code for the subreport:
            get { return (int)sqlDataAdapter1.SelectCommand.Parameters["@WorkOrderItem"].Value; }
            set { sqlDataAdapter1.SelectCommand.Parameters["@WorkOrderItem"].Value = value; }

the code from the .aspx page:

            Reports.SubReports.WOTechnicianDetails subReport = new Reports.SubReports.WOTechnicianDetails();
            subReport.FK_WorkOrderParam1 = int.Parse(this.Id.ToString());

when I do it this way, the subreport gets the value I want, but it still only loads the default that I put in for the Sql Data Adapter under parameters.  Am I missing a place I need to refresh the report?  Any help is appreciated.

Thanks   

[Sean Beaulac]

I got it to work without using any of the code above.  After searching through the forums I found that you can reference the parameters from master report to subreport and set the value that way. 

[Spiros]

I'm having a few issues passing the parameter Value.
My sub report  has a sqldataAdapter and needs a parameter that is on the main report.
The Value doesn't seem to come over.

Any ideas?

Spiros

[Sean Beaulac]

Just to make sure, on the main report where you have your sub report, go to your sub report properties and make sure the parameter is being referenced to a value on the main report. 

On the page where the report viewer:

            Telerik.Reporting.SubReport subreportItem = rpt.Items.Find("subReport2", true)[0] as Telerik.Reporting.SubReport;
            subreportItem.ReportSource.ReportParameters["Parameter1"].Value = "the value you want";

On the subreport in NeedDataSource

            Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;
            this.sqlDataAdapter1.SelectCommand.Parameters["@WorkOrderItem"].Value = this.ReportParameters[0].Value;
            report.DataSource = this.sqlDataAdapter1;

Also, under InitializeComponent() make sure to set the datasource = null.  It forced the subreport to fire NeedDataSource. 

I found all of this in different places and pieced together what I could and it work.  Hope this helps.