How to use multiple subreport in a main report in ... - SAP Community

Your subreports are coming  back blank because setting the datasource at the subreport level doesn't work.  In both the main report and any subreports, you have to walk through the tables and set the datasource on the tables themselves.

The code for setting the login for the data in the subreports should look something like this:

private void ConfigureCrystalReports()
{
  northwindCustomersReport = new ReportDocument();
  string reportPath = Application.StartupPath + "\\" + "NorthwindCustomers.rpt";
  northwindCustomersReport.Load(reportPath);

  //Build the ConnectionInfo used for assigning credentials for the data
  ConnectionInfo connectionInfo = new ConnectionInfo();
  connectionInfo.ServerName = "localhost";
  connectionInfo.DatabaseName = "Northwind";
  connectionInfo.IntegratedSecurity = true;
            
  crystalReportViewer.ReportSource = northwindCustomersReport;
  //Set credentials for the main report
  SetDBLogonForReport(connectionInfo, northwindCustomersReport); 
  //Set credentials for the subreports
  SetDBLogonForSubreports(connectionInfo, northwindCustomersReport);
}

private void SetDBLogonForReport(ConnectionInfo connectionInfo, 
     ReportDocument reportDocument)
{
  Tables tables = reportDocument.Database.Tables;
  foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables)
  {
    TableLogOnInfo tableLogonInfo = table.LogOnInfo;
    tableLogonInfo.ConnectionInfo = connectionInfo;
    table.ApplyLogOnInfo(tableLogonInfo);
  }
}

private void SetDBLogonForSubreports(ConnectionInfo connectionInfo, 
    ReportDocument reportDocument)
{
  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);
        SetDBLogonForReport(connectionInfo, subReportDocument);
      }
    }
  }

This code was taken from the sample code that can be downloaded from the "SAP Crystal Reports .NET SDK Tutorial Sample Code" link on the Crystal for VS Help page.

-Dell