Has it been plagued by data binding issues in subreports of Crystal Reports? This is also a question I mentioned in another article.
Http://www.cnblogs.com/haozidong/archive/2004/10/20/54489.html
You can bind a subreport with code to solve this problem.
String sConnectionString = ConfigurationSettings. receivettings ["dbCommISMS"];
SqlConnection sqlConn = new SqlConnection (sConnectionString );
SqlCommand sqlComm = new SqlCommand ();
SqlDataAdapter dataAdapter = new SqlDataAdapter ();
SqlConn. Open ();
SqlComm. Connection = sqlConn;
SqlComm. CommandType = CommandType. Text;
DataAdapter. SelectCommand = sqlComm;
Dataset1 dataSet = new Dataset1 ();
String sSQL = "SELECT * FROM T_REQUEST WHERE APPLI_ID = '" + appli_id + "'";
SqlComm. CommandText = sSQL;
DataAdapter. Fill (dataSet, "T_REQUEST ");
SSQL = "SELECT * FROM T_REQUEST_INSPECTION WHERE APPLI_ID = '" + appli_id + "'";
SqlComm. CommandText = sSQL;
DataAdapter. Fill (dataSet, "T_REQUEST_INSPECTION ");
SSQL = "SELECT * FROM T_ACCEPT_INSPECTION WHERE APPLI_ID = '" + appli_id + "'";
SqlComm. CommandText = sSQL;
DataAdapter. Fill (dataSet, "T_ACCEPT_INSPECTION ");
SubreportObject oSubreport1 = oRpt. ReportFooterSection1.ReportObjects ["Subreport1"] as SubreportObject;
ReportDocument oSub1 = oSubreport1.OpenSubreport ("Inspection ");
OSub1.SetDataSource (dataSet );
SubreportObject oSubreport2 = oRpt. ReportFooterSection2.ReportObjects ["Subreport2"] as SubreportObject;