Master Detail with stored procedures and parameters on both

[Mike Maynard]

Hi all,
I have been trying different things to try and get this to work but keep running into walls.
My setup is:

Visual Studio 2012 - Winforms - Telerik Reporting 2013 Q3
SQL Server 2008R2 backend.

Master table
name: JSA1
Key Field: JSAID
Field1
Field2
Field3
Field4

Detail Table
name: tblSteps
Key Field: STEPID
FK Field: JSAID
Field1
Field2
Field3
Field4

Foreign key is setup properly in SQL Server.
I have 2 stored procedures that select records from each of the tables.
I can preview the reports individually with an entered parameter value and they both work fine.
What I want to accomplish is to be able to pass the parameter to BOTH the main report and the subreport.
I followed the Master Detail guide, and that works ok, but it is slow since it has to return ALL of the detail table before it filters then down to the records I want.

I call the master report using a form with a reportviewer on it and pass the parameter to the main report as follows
 Dim instanceReportSource As New Telerik.Reporting.InstanceReportSource()
                instanceReportSource.ReportDocument = New Reporting.VWIDetail()
                instanceReportSource.Parameters.Add(New Telerik.Reporting.Parameter("JSAID", GlobalVariables.VWILinkDetail))
                ReportViewer2.ReportSource = instanceReportSource
               ReportViewer2.RefreshReport()

How can I pass that parameter to the sub report in the same way?

[Nasko]

Hello Mike,

You can set the sub-report parameters programmatically like in the following code snippet:

...
Dim report = New Reporting.VWIDetail()
Dim subReport = TryCast(report.Items.Find("MySubReportItemName", True)(0), Telerik.Reporting.SubReport)
subReport.ReportSource.Parameters.Add("Parameter1", "value")
...

Regards,
Nasko
Telerik