打印不出内容啊,求大神指教。。
XSD文件建了,利用C1ReprotDesigner也生成了模板xml文件,数据是用sql查询封装成DataTable赋值给report
代码:
report.Load("Report.xml", "采购单");
DataTable dt = rds.采购单;
DataTable subdt = rds.采购单子单;
string sql = "select r.id 采购ID,r.purchase_no 采购单号,r.purchase_quantity 采购数量 from e_purchase_order r where r.id=" + param.ToString();
FromRuntime.sqlToDataTable(dt, sql);
string sql2 = " select i.p_product_sn 产品ID,i.purchase_quantity 产品数量 from e_purchase_order_item i where i.e_purchase_order_id=" + param.ToString();
FromRuntime.sqlToDataTable(subdt, sql2);
report.DataSource.Recordset = dt;
report.Fields["subfield"].Subreport.DataSource.Recordset = subdt;
report.Document.Print(); |
|