水晶报表您请求的报表需要更多信息，着急

[dl_wang]

建了两个数据集 dataset1(datatable:mytable1) dataset2(datatable:mytable2)

实现主表 子表绑定出现 您请求的报表需要更多信息。出现登陆框---dataset2


主要代码如下：

private void bdReport()
{

ReportDocument oCR = new ReportDocument();
OracleConnection cnn = new OracleConnection("data source=orcl; User=system; Password=system");

OracleDataAdapter cmd1 = new OracleDataAdapter("SELECT PONUMBER FROM ORDER WHERE PONUMBER <>' ' GROUP BY PONUMBER", cnn);

//Create and fill the DataSet.

DataSet ds = new DataSet();
cmd1.Fill(ds, "mytable1");
string reportPath = Server.MapPath("12.rpt");
oCR.Load(reportPath);
OracleDataAdapter cmd2 = new OracleDataAdapter("SELECT PONUMBER,ORODUCTID FROM ORDER WHERE PONUMBER<>' '", cnn);

cmd2.Fill(ds, "mytable2");

//Create the relation between the Authors and Titles tables.
ds.Relations.Add("mo",
ds.Tables["mytable1"].Columns["PO_NUMBER"],
ds.Tables["mytable2"].Columns["PO_NUMBER"]);

//binding reportViewer
oCR.SetDataSource(ds);

this.CrystalReportViewer1.ReportSource = oCR;
cnn.Close();

}

[阿泰]

你要在一个dataset里建两个datatable，而不是分别建在一个dataset里。

代码没错，把dataset重建一下，报表模板重建一下即可

[dl_wang]

up