项目介绍积木报表JimuReport,是一款免费的数据可视化报表,含报表、仪表盘和大屏设计,像搭建积木一样完全在线设计!功能涵盖:数据报表、打印设计、图表报表、门户设计、大屏设计等!
- Web版报表设计器,类Excel操作风格,通过拖拽完成报表设计,所见即所得。
- 大屏采用类word风格,可以随意拖动组件,想怎么设计怎么设计,可以像百度和阿里一样,设计出炫酷大屏!
- 从v1.9+起推出JimuBI产品,她的牛叉之处,同时支持仪表盘、大屏、门户(支持交互)、移动。
- 秉承"简单、易用、专业"的产品理念,极大的降低报表开发难度、缩短开发周期、节省成本。
- 领先的企业级Web报表,支持各种复杂报表,专注于解决企业报表难题。
当前版本:v1.9.1 | 2024-12-05
集成依赖
一、积木报表依赖
- <dependency>
- <groupId>org.jeecgframework.jimureport</groupId>
- <artifactId>jimureport-spring-boot-starter</artifactId>
- <version>1.9.1</version>
- </dependency>
复制代码
二、积木BI依赖(仪表盘和大屏)从1.9.1起正式将 jimureport-dashboard-spring-boot-starter 更名为 jimubi-spring-boot-starter - <dependency>
- <groupId>org.jeecgframework.jimureport</groupId>
- <artifactId>jimubi-spring-boot-starter</artifactId>
- <version>1.9.1</version>
- </dependency>
复制代码
升级日志本次升级主要推出首个稳定版大屏,报表新增 "定时导出报表"功能,同时修复1.9.0版本已知BUG。
升级SQL
- -- 大屏加字段
- ALTER TABLE `onl_drag_page` ADD COLUMN `des_json` varchar(500) NULL COMMENT '仪表盘主配置JSON' AFTER `cover_url`;
- -- 文件夹加排序
- ALTER TABLE jimu_report_category
- ADD COLUMN sort_no int NULL COMMENT '排序' AFTER tenant_id;
- update jimu_report_category set sort_no = 0 where sort_no is null;
- -- 定时报表导出
- DROP TABLE IF EXISTS `jimu_report_export_job`;
- CREATE TABLE `jimu_report_export_job` (
- `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主键',
- `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '任务名称',
- `begin_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
- `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
- `exec_interval` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '执行频率',
- `report_conf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '导出报表配置',
- `last_run_time` datetime NULL DEFAULT NULL COMMENT '最后执行时间',
- `receiver_email` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '接收通知的邮件',
- `file_sync_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '文件同步路径',
- `status` int(11) NULL DEFAULT NULL COMMENT '状态(0:停止;1:启动)',
- `create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
- `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
- `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
- `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
- `tenant_id` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '多租户标识',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '积木报表导出计划表' ROW_FORMAT = Dynamic;
- -- 仪表盘门户组件配置
- UPDATE `onl_drag_comp` SET `comp_config` = '{\n "w": 12,\n "h": 26,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/42/nav",\n "timeOut": -1,\n "linkageConfig": [],\r\n "dataMapping": [\r\n {\r\n "filed": "标题",\r\n "mapping": ""\r\n },\r\n {\r\n "filed": "图标",\r\n "mapping": ""\r\n },\r\n {\r\n "filed": "颜色",\r\n "mapping": ""\r\n },\r\n {\r\n "filed": "跳转",\r\n "mapping": ""\r\n }\r\n ],\n "chartData": [\n {\n "title": "首页",\n "icon": "icon-jeecg-homepage",\n "color": "#1fdaca"\n },\n {\n "title": "仪表盘",\n "icon": "icon-jeecg-shijian",\n "color": "#bf0c2c"\n },\n {\n "title": "组件",\n "icon": "icon-jeecg-dangan",\n "color": "#e18525"\n },\n {\n "title": "系统管理",\n "icon": "icon-jeecg-shezhi",\n "color": "#3fb27f"\n },\n {\n "title": "权限管理",\n "icon": "icon-jeecg-yuechi",\n "color": "#4daf1bc9"\n },\n {\n "title": "图表",\n "icon": "icon-jeecg-fujin",\n "color": "#00d8ff"\n }\n ],\n "option": {\n "icon": {\n "scriptUrl": "//at.alicdn.com/t/font_3237315_b3fqd960glt.js",\n "fontSize": 30\n },\n "card": {\n "title": "快捷导航",\n "extra": "更多",\n "rightHref": "",\n "size": "default"\n },\n "body": {\n "column": 3,\n "textAlign": "center",\n "iconAlign": "top"\n }\n }\n}', `status` = '1', `create_by` = NULL, `create_time` = NULL, `update_by` = 'admin', `update_time` = '2022-04-29 19:50:38' WHERE `id` = '100103';
- UPDATE `onl_drag_comp` SET `comp_config` = '{\n "w": 12,\n "h": 19,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/42/nav",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "标题",\n "mapping": ""\n },\n {\n "filed": "图标",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n },\n {\n "filed": "总计",\n "mapping": ""\n },\n {\n "filed": "前缀",\n "mapping": ""\n },\n {\n "filed": "颜色",\n "mapping": ""\n },\n {\n "filed": "单位",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "title": "访问数",\n "icon": "icon-jeecg-qianbao",\n "value": 2000,\n "total": 120000,\n "prefix": "$",\n "color": "green",\n "action": "月"\n },\n {\n "title": "成交额",\n "icon": "icon-jeecg-youhuiquan",\n "value": 20000,\n "total": 500000,\n "prefix": "$",\n "color": "blue",\n "action": "月"\n },\n {\n "title": "下载数",\n "icon": "icon-jeecg-tupian",\n "value": 8000,\n "prefix": "$",\n "total": 120000,\n "color": "orange",\n "action": "周"\n },\n {\n "title": "成交数",\n "icon": "icon-jeecg-jifen",\n "value": 5000,\n "prefix": "$",\n "total": 50000,\n "color": "purple",\n "action": "年"\n }\n ],\n "option": {\n "icon": {\n "scriptUrl": "//at.alicdn.com/t/font_3237315_b3fqd960glt.js",\n "fontSize": 20\n },\n "card": {\n "title": "统计卡片",\n "extra": "更多",\n "rightHref": "",\n "size": "default"\n },\n "body": {\n "horizontal": 8,\n "vertical": 8,\n "span": 6\n }\n }\n}', `status` = '1', `create_by` = NULL, `create_time` = NULL, `update_by` = 'admin', `update_time` = '2022-05-07 18:24:23' WHERE `id` = '100104100';
- UPDATE `onl_drag_comp` SET `comp_config` = '{\n "w": 24,\n "h": 14,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/42/nav",\n "timeOut": 0,\n "turnConfig": {\n "url": ""\n },\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "标题",\n "mapping": ""\n },\n {\n "filed": "图标",\n "mapping": ""\n },\n {\n "filed": "数值",\n "mapping": ""\n },\n {\n "filed": "后缀",\n "mapping": ""\n },\n {\n "filed": "颜色",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "title": "访问数",\n "icon": "icon-jeecg-qianbao",\n "value": 2000,\n "color": "green",\n "suffix": "月"\n },\n {\n "title": "成交额",\n "icon": "icon-jeecg-youhuiquan",\n "value": 20000,\n "color": "blue",\n "suffix": "月"\n },\n {\n "title": "下载数",\n "icon": "icon-jeecg-tupian",\n "value": 8000,\n "color": "orange",\n "suffix": "周"\n },\n {\n "title": "成交数",\n "icon": "icon-jeecg-jifen",\n "value": 5000,\n "color": "purple",\n "suffix": "年"\n }\n ],\n "option": {\n "icon": {\n "fontSize": 50\n },\n "card": {\n "title": "卡片",\n "extra": "更多",\n "rightHref": "",\n "size": "default"\n },\n "body": {\n "horizontal": 8,\n "vertical": 8,\n "span": 6\n }\n }\n}', `status` = '1', `create_by` = NULL, `create_time` = NULL, `update_by` = 'admin', `update_time` = '2022-05-07 18:24:23' WHERE `id` = '100104108';
- UPDATE `onl_drag_comp` SET `comp_config` = '{\n "w": 12,\n "h": 33,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/42/nav",\n "timeOut": -1,\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "标题",\n "mapping": ""\n },\n {\n "filed": "图标",\n "mapping": ""\n },\n {\n "filed": "分组",\n "mapping": ""\n },\n {\n "filed": "描述",\n "mapping": ""\n },\n {\n "filed": "时间",\n "mapping": ""\n },\n {\n "filed": "颜色",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "title": "Github",\n "icon": "icon-jeecg-social-github",\n "color": "",\n "desc": "不要等待机会,而要创造机会。",\n "group": "开源组",\n "date": "2021-04-01"\n },\n {\n "title": "Vue",\n "icon": "icon-jeecg-social-buysellads",\n "color": "#3fb27f",\n "desc": "现在的你决定将来的你。",\n "group": "算法组",\n "date": "2021-04-01"\n },\n {\n "title": "Html5",\n "icon": "icon-jeecg-html5",\n "color": "#e18525",\n "desc": "没有什么才能比努力更重要。",\n "group": "上班摸鱼",\n "date": "2021-04-01"\n },\n {\n "title": "Angular",\n "icon": "icon-jeecg-social-product-hunt",\n "color": "#bf0c2c",\n "desc": "热情和欲望可以突破一切难关。",\n "group": "UI",\n "date": "2021-04-01"\n },\n {\n "title": "React",\n "icon": "icon-jeecg-social-skype",\n "color": "#00d8ff",\n "desc": "健康的身体是实目标的基石。",\n "group": "技术牛",\n "date": "2021-04-01"\n },\n {\n "title": "Js",\n "icon": "icon-jeecg-social-pengyou",\n "color": "#4daf1bc9",\n "desc": "路是走出来的,而不是空想出来的。",\n "group": "架构组",\n "date": "2021-04-01"\n }\n ],\n "option": {\n "icon": {\n "scriptUrl": "//at.alicdn.com/t/font_3237315_b3fqd960glt.js",\n "fontSize": 30\n },\n "card": {\n "title": "项目列表",\n "extra": "更多",\n "rightHref": "",\n "size": "default"\n },\n "body": {\n "column": 3\n }\n }\n}', `status` = '1', `create_by` = NULL, `create_time` = NULL, `update_by` = 'admin', `update_time` = '2022-04-29 19:52:42' WHERE `id` = '100105';
- UPDATE `onl_drag_comp` SET `comp_config` = '{\n "w": 12,\n "h": 19,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/42/nav",\n "timeOut": -1,\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "标题",\n "mapping": ""\n },\n {\n "filed": "图标",\n "mapping": ""\n },\n {\n "filed": "描述",\n "mapping": ""\n },\n {\n "filed": "时间",\n "mapping": ""\n }\n ],\n "chartData": [\n {\n "title": "待办公文",\n "icon": "icon-jeecg-yudu",\n "content": 23,\n "desc": "今日已办 3",\n "date": "2021-04-01"\n },\n {\n "title": "待办流程",\n "icon": "icon-jeecg-shuju",\n "content": 23,\n "desc": "今日已办 3",\n "date": "2021-04-01"\n },\n {\n "title": "待办任务",\n "icon": "icon-jeecg-tongzhi",\n "content": 23,\n "desc": "今日已办 3 今日更新 5",\n "date": "2021-04-01"\n }\n ],\n "option": {\n "icon": {\n "scriptUrl": "//at.alicdn.com/t/font_3237315_b3fqd960glt.js",\n "fontSize": 25\n },\n "card": {\n "title": "待办事项",\n "extra": "更多",\n "rightHref": "",\n "size": "default"\n },\n "body": {\n "column": 3\n }\n }\n}', `status` = '1', `create_by` = NULL, `create_time` = NULL, `update_by` = 'admin', `update_time` = '2022-04-29 19:52:49' WHERE `id` = '100106';
- UPDATE `onl_drag_comp` SET `comp_config` = '{\n "w": 12,\n "h": 28,\n "dataType": 1,\n "url": "http://api.jeecg.com/mock/42/list",\n "linkageConfig": [],\n "dataMapping": [\n {\n "filed": "名称",\n "mapping": ""\n },\n {\n "filed": "描述",\n "mapping": ""\n },\n {\n "filed": "时间",\n "mapping": ""\n },\n {\n "filed": "头像",\n "mapping": ""\n }\n ],\n "timeOut": -1,\n "option": {\n "titleFontSize": 18\n },\n "chartData": [\n {\n "name": "威廉",\n "date": "刚刚",\n "desc": "在 <a>开源组</a> 创建了项目 <a>Vue</a>",\n "avatar": "https://jeecgdev.oss-cn-beijing.aliyuncs.com/upload/test/320222_1646724689691.jpg"\n },\n {\n "name": "艾文",\n "date": "1个小时前",\n "desc": "关注了 <a>威廉</a>",\n "avatar": "https://jeecgdev.oss-cn-beijing.aliyuncs.com/upload/test/320305_1646724680756.jpg"\n },\n {\n "name": "克里斯",\n "date": "1天前",\n "desc": "发布了 <a>个人动态</a>",\n "avatar": "https://jeecgdev.oss-cn-beijing.aliyuncs.com/upload/test/299258_1646724675255.jpg"\n },\n {\n "name": "Jeecg",\n "date": "2天前",\n "desc": "发表文章 <a>如何编写一个Vite插件</a>",\n "avatar": "https://jeecgdev.oss-cn-beijing.aliyuncs.com/upload/test/2.4jeecg_1621512120602.png"\n }\n ]\n}', `status` = '1', `create_by` = 'jeecg', `create_time` = '2022-03-09 14:07:54', `update_by` = 'admin', `update_time` = '2022-04-29 19:52:54' WHERE `id` = '1501439614397119490';
复制代码
报表Issues- 新增大功能:定时导出报表功能
- 放开数据集和报表创建数限制,满足开源用户需求
- 支持导出报表接口
- issues/2972 解决jimureport可上传任意文件漏洞
- 模版上传封面失败之后无提示
- 解决设计报告后无法保存,提示版本已过时严重问题
- 可以像EXCEL那样填报码?可以拆入行吗? · Issue #2971
- 积木报表SQL数据集使用存储过程每次预览未关闭druid连接池 · Issue #2929
- 单元格中使用concat函数做字符串连接时错误 · Issue #2969
- 动态交叉表中自定义文本排序不生效 #3107
- 文件夹加排序
- 优化样式,鼠标放上去选择框的样式
- 兼容国产数据库 TDengine | 涛思数据
- 文件夹点击名称时不要展开/收起
- 支持clickhouse数据库
- 分组设置-聚合方式,无法批量设置单元格
- 报表钻取,选择主表汉子字段为连接时候原始值不能下拉,为英文字段可以 #3110
- 填报模版添加完数据后点击 详情404
- springboot3 1.8.1 多数据源报错 · Issue #3130
- jeecg.jmreport.apiBasePath 配置自定义接口前缀的问题 · Issue #3134
- ruoyiVue集成积木报表,在线填报报表token校验失败 · Issue #3147
- 在报表中插入图片后删除其他单元格内容图片会一起删除 · Issue #3186
- 填报校验问题 · Issue #3193
大屏Issues
代码下载
技术文档
为什么选择 JimuReport?永久免费,支持各种复杂报表,并且傻瓜式在线设计,非常的智能,低代码时代,这个是你的首选!
- 采用SpringBoot的脚手架项目,都可以快速集成
- Web 版设计器,类似于excel操作风格,通过拖拽完成报表设计
- 通过SQL、API等方式,将数据源与模板绑定。同时支持表达式,自动计算合计等功能,使计算工作量降低
- 开发效率很高,傻瓜式在线报表设计,一分钟设计一个报表,又简单又强大
- 支持 ECharts,目前支持28种图表,在线拖拽设计,支持SQL和API两种数据源
- 支持分组、交叉,合计、表达式等复杂报表
- 支持打印设计(支持套打、背景打印等)可设置打印边距、方向、页眉页脚等参数 一键快速打印 同时可实现套打,不动产证等精准、无缝打印
- 可设计各种类型的单据、大屏,如出入库单、销售单、财务报表、合同、监控大屏、旅游数据大屏等
- 大屏设计器支持几十种图表样式,可自由拼接、组合,设计炫酷大屏
- 数据可视化,DataV、帆软的开源替代方案,比帆软拥有更好的体验和更简单的使用方式
- 积木报表官网 可以在线免费制作报表和大屏,手机号一键注册,便可永久使用。大屏采用类word风格,可以随意拖动组件,想怎么设计怎么设计,可以像百度和阿里一样,设计出炫酷的可视化大屏!重要的是:免费!免费!免费!
报表设计效果
仪表盘工作台
大屏设计效果
|