FastReport.NET2023报表数据源配置详解|C/S开发框架

作者:csframework|C/S框架网发布日期:2024/04/16 23:46:20

FastReport.NET简介

FastReport.Net是一款适用于Windows Forms, ASP.NET和MVC框架的功能齐全的报表分析解决方案。可用在Microsoft Visual Studio 2005到2019，支持.Net Framework 2.0到4.x，.NET Core。

使用FastReport.Net，您能创建独立于应用程序的报表。也就是说，FastReport.Net能作为一款独立的报表工具进行运用。

本文要点

FastReport.Net组件支持给前端实施工程师快速自定义报表，包括新增报表、修改报表格式等操作，而不需要编写任何代码。

配置报表数据源

Json数据源

C# 全选

        private void JsonDemo()
        {
            //本地文件json数据源
            var json = Newtonsoft.Json.JsonConvert.SerializeObject(DemoData.demoDataItems);
            var jsonFile = Path.Combine(Application.StartupPath, "demo.json");
            File.WriteAllText(jsonFile, json, System.Text.Encoding.UTF8);

            //报表模板文件
            var reportFile = Path.Combine(Application.StartupPath, "demo.frx");

            //生成报表数据源
            RegisteredObjects.AddConnection(typeof(JsonDataConnection));
            Report report = new Report();
            JsonDataConnection connection = new JsonDataConnection();
            connection.ConnectionString = "Json=" + jsonFile;
            connection.CreateAllTables();
            report.Dictionary.Connections.Add(connection);

            //注册数据源
            report.RegisterData(connection.DataSet);
            report.Load(reportFile);
            report.Design(true);
        }

Sql数据源

C# 全选

        private void SqlDemo()
        {
            var report = new Report();
            var reportFile = Path.Combine(Application.StartupPath, "demo.frx");

            //生成报表数据源
            RegisteredObjects.AddConnection(typeof(MsSqlDataConnection));
            MsSqlDataConnection connection = new MsSqlDataConnection();
            connection.ConnectionString = DemoData.connectionString;
            report.Dictionary.Connections.Add(connection);

            FastReport.EnvironmentSettings settings = new FastReport.EnvironmentSettings();
            settings.DesignerSettings.ApplicationConnection = new System.Data.SqlClient.SqlConnection();
            settings.DesignerSettings.ApplicationConnection.ConnectionString = DemoData.connectionString;
            Config.DesignerSettings = settings.DesignerSettings;

            //获取DataTable数据源
            var dtDemo = DemoData.GetTable("tb_SO");

            //注册数据源
            report.RegisterData(dtDemo, "tb_SO");
            report.Load(reportFile);
            var ok = report.Design(true);
        }