FastReport中国社区FastReport联系电话 联系电话:023-68661681

报表生成器成功案例:C#调用FastReport控件示例

来源:   发布时间:2021-03-18   浏览:次

FastReport .Net是适用于Windows Forms,ASP.NET,MVC和.NET Core的全功能报表解决方案。它可以在Microsoft Visual Studio 2005-2019中使用。支持.Net Framework 2.0-4.x,.NET Core 3.0及以上版本。

在FastReport .NET 2021.1的新版本中,我们实现了对.NET 5的支持。添加了新条形码-Deutsce Post Leitcode。将RTF转换为报告对象的算法已得到显着改进。并且还添加了用于转换数字的新功能。欢迎下载体验。(点击下方按钮下载)

立即点击下载FastReport.NET v2021.1最新版

下载FastReport组件必须的dll文件,如下图:

创建个WinForm项目

引用dll文件

引用dll文件创建FastReport控件工具

创建打印设置From

C#代码:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using FastReport;
using System.Data.SqlClient;
 
namespace PrintTest001
{
    public partial class FrmPrintDesigner : Form
    {
        public FrmPrintDesigner()
        {
            InitializeComponent();
        }
 
        private void FrmPrintDesigner_Load(object sender, EventArgs e)
        {
            Report dReport = new Report();   //实例化一个Report报表
            String reportFile = "Report/Report01.frx";
            dReport.Load(reportFile);  //载入报表文件
            this.designerControl1.Report = dReport; //这里不一样的是把Report赋给控件的属性            
            DataSet ds1 = new DataSet();
            ds1 = getDataHz();
            dReport.RegisterData(ds1, "单据汇总");
 
            DataSet ds2 = new DataSet();
            ds2 = getDataMx();
            dReport.RegisterData(ds2, "单据明细");
 
            dReport.Prepare();   //准备
            dReport.Design();  //显示
        } 
 
        private DataSet getDataHz()
        {
            String connStr = ReturnDataSet.connectionString;
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            String sqlStr = ReturnDataSet.HzSql;
            SqlCommand comm = new SqlCommand();
            comm.CommandText = sqlStr;
            comm.CommandType = CommandType.Text;
            comm.Connection = conn;
            DataSet ds = new DataSet();
            SqlDataAdapter adapter = new SqlDataAdapter(comm);
            adapter.Fill(ds, "单据汇总");
            conn.Close();
            return ds;
        }
        private DataSet getDataMx()
        {
            String connStr = ReturnDataSet.connectionString;
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            String sqlStr = ReturnDataSet.MxSql;
            SqlCommand comm = new SqlCommand();
            comm.CommandText = sqlStr;
            comm.CommandType = CommandType.Text;
            comm.Connection = conn;
            DataSet ds = new DataSet();
            SqlDataAdapter adapter = new SqlDataAdapter(comm);
            adapter.Fill(ds, "单据明细");
            conn.Close();
            return ds;
        }
    }
}

创建打印预览From

C#代码:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using FastReport;
using System.Data.SqlClient;
 
namespace PrintTest001
{
    public partial class FrmPrintPreview : Form
    {
        public FrmPrintPreview()
        {
            InitializeComponent();
        }
 
        private void FrmPrintPreview_Load(object sender, EventArgs e)
        {
            Report dReport = new Report();   //实例化一个Report报表
            String reportFile = "Report/Report01.frx";
            dReport.Load(reportFile);  //载入报表文件
            dReport.Preview = previewControl1; //设置报表的Preview控件(这里的previewControl1就是我们之前拖进去的那个)    
            DataSet ds1 = new DataSet();
            ds1 = getDataHz();
            dReport.RegisterData(ds1, "单据汇总");
 
            DataSet ds2 = new DataSet();
            ds2 = getDataMx();
            dReport.RegisterData(ds2, "单据明细");
 
            dReport.Prepare();   //准备
            dReport.ShowPrepared();  //显示
 
        }
 
        private DataSet getDataHz()
        {
            String connStr = ReturnDataSet.connectionString;
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            String sqlStr = ReturnDataSet.HzSql;
            SqlCommand comm = new SqlCommand();
            comm.CommandText = sqlStr;
            comm.CommandType = CommandType.Text;
            comm.Connection = conn;
            DataSet ds = new DataSet();
            SqlDataAdapter adapter = new SqlDataAdapter(comm);
            adapter.Fill(ds, "单据汇总");
            conn.Close();
            return ds;
        }
        private DataSet getDataMx()
        {
            String connStr = ReturnDataSet.connectionString;
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            String sqlStr = ReturnDataSet.MxSql;
            SqlCommand comm = new SqlCommand();
            comm.CommandText = sqlStr;
            comm.CommandType = CommandType.Text;
            comm.Connection = conn;
            DataSet ds = new DataSet();
            SqlDataAdapter adapter = new SqlDataAdapter(comm);
            adapter.Fill(ds, "单据明细");
            conn.Close();
            return ds;
        }
    }
}

示例:

打印设置效果: 打印预览效果:

本站文章除注明转载外,均为本站原创或翻译
欢迎任何形式的转载,但请务必注明出处,尊重他人劳动成果
转载请注明:文章转载自:FastReport控件中文网 [https://www.fastreportcn.com/]
本文地址:https://www.fastreportcn.com/post/2939.html

联系我们
  • 重庆总部 023-68661681
购买
  • sales@evget.com
合作
  • business@evget.com


在线
客服
微信
QQ 电话
023-68661681
返回
顶部