锐浪报表多个子报表赋值

最新推荐文章于 2021-12-15 15:19:33 发布

AirZH??

最新推荐文章于 2021-12-15 15:19:33 发布

阅读量779

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/hefy/p/5052097.html

版权

源代码如下：有疑问这咨询QQ：1204409478

下面的所有主报表和子报表全部都来自一个GRF报表文件，所以只加载一次。

下面的代码演示是从数据库动态添加数据到各个子报表

#region 小票打印
GridppReport PReport = new GridppReport();//主报表
GridppReport ReportMain = new GridppReport();//子报表
GridppReport ReportGoods = new GridppReport();//子报表
GridppReport ReportPay = new GridppReport();//子报表

private void ResceiptPrint()
{
try
{
DirectoryInfo dir = new DirectoryInfo(AppDomain.CurrentDomain.BaseDirectory);
string callBackPath = dir.FullName + "\\"; //自动升级完成后，要启动的exe的完整路径。
//载入报表模板数据
PReport.LoadFromFile(callBackPath + "\\Grf\\Pos\\Reg.grf");

PReport.ControlByName("SubReport1").AsSubReport.Report = ReportMain;
PReport.ControlByName("SubReport2").AsSubReport.Report = ReportGoods;
PReport.ControlByName("SubReport3").AsSubReport.Report = ReportPay;

ReportMain.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(PReportMain);
ReportGoods.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(SonReportGoods);
ReportPay.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(SonReportPay);

PReport.Print(false);
}
catch(Exception)
{
MessageBox.Show("小票打印异常！","提示");
}

}

private void PReportMain()
{
ReportMain.DetailGrid.Recordset.ConnectionString = "Provider=SQLOLEDB.1;...";
ReportMain.DetailGrid.Recordset.QuerySQL = "SELECT ...";
}

private void SonReportGoods()
{
ReportGoods.DetailGrid.Recordset.ConnectionString = "Provider=SQLOLEDB.1;...";
ReportGoods.DetailGrid.Recordset.QuerySQL = @"SELECT ... ";
}

private void SonReportPay()
{
ReportPay.DetailGrid.Recordset.ConnectionString = "Provider=SQLOLEDB.1;...";
ReportPay.DetailGrid.Recordset.QuerySQL = @"SELECT ... ";

}
#endregion

转载于:https://www.cnblogs.com/hefy/p/5052097.html