I don't code in VB, so I don't know the exact syntax. However, here's what the code to get to the subreports looks like in C#. Once you get to the subreport, I think you can then set the .SQLQueryString for the individual subreport.
Sections sections = reportDocument.ReportDefinition.Sections;
foreach (Section section in sections)
{
ReportObjects reportObjects = section.ReportObjects;
foreach (ReportObject reportObject in reportObjects)
{
if (reportObject.Kind == ReportObjectKind.SubreportObject)
{
SubreportObject subreportObject = (SubreportObject.reportObject);
ReportDocument subReportDocument =
subreportObject.OpenSubreport(subreportObject.SubreportName);
//add your code here....
}
}
}
-Dell
IP Logged
