• 锐浪报表多个子报表赋值


    源代码如下:有疑问这咨询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

  • 相关阅读:
    有趣的网站
    Python-Day2
    C# EF增删改查
    LINQ教程
    命名空间“System.Web”中不存在类型或命名空间名称“Optimization”(是否缺少程序集引用?)
    Log4Net组件的应用详解
    log4net应用
    Select count(*)和Count(1)的区别和执行方式
    Ms sql 2005 中的bit 数据类型
    关于CLR、CIL、CTS、CLS、CLI、BCL和FCL
  • 原文地址:https://www.cnblogs.com/hefy/p/5052097.html
Copyright © 2020-2023  润新知