JimuReport building block report 1.3.3 version released, a visual report tool

Project Introduction

Building block report is a free visual web report tool, drag and drop online report design like building blocks! The function covers, data report, print design, chart report, large screen design, etc.!
Adhering to the "simple, easy-to-use, professional" product concept, it greatly reduces the difficulty of report development, shortens the development cycle, saves costs, and solves various report problems. The key point is that this software is completely free! ! !

current version : v1.3.3-beta | 2021-05-17

Integration dependency

<dependency>
    <groupId>org.jeecgframework.jimureport</groupId>
    <artifactId>spring-boot-starter-jimureport</artifactId>
    <version>1.3.3-beta</version>
</dependency>

Incremental SQL

ALTER TABLE `jimu_report_db_field`
ADD COLUMN `search_value` varchar(100) NULL COMMENT '查询默认值' AFTER `dict_code`;

ALTER TABLE `jimu_report_db` 
ADD COLUMN `json_data` text NULL COMMENT 'json数据，直接解析json内容' AFTER `db_source_type`;

ALTER TABLE `jimu_report_data_source`
ADD COLUMN `connect_times` int(1) NULL COMMENT '连接次数' AFTER `update_time`;

Upgrade log

new function

• The new printing method "Print Form" is more clear for document printing (the printing of charts is not supported)
• The new PDF generation is clearer (the support for supporting charts is not good yet, to be optimized)
• Support linkage and drilling
• Optimize excel import and export
• Support landscape and portrait settings
• The designer supports auto-save function
• Support json format data set
• System variables support current time and current date
• Support format brush
• Support inserting multiple columns and multiple rows
• The query conditions support default values
• Delete does not support shortcut keys

Issues handling

• The report parameters of the api data source will be cleared every time the api is modified #186
• API data source is invalid #183
• Custom api issue #177
• 1.3.1-beta3API preview error issues/I3IE3O
• Version 1.3.1-beta3, connected to SQL Server, data query error issues/I3IF5W
• Dot print button stuck #180
• [BUG] The imported template cannot set any attributes, and error #169
• 1.3.1-beta2 version is exported to excel and pdf, the business data of the request api is empty issues/I3HMWQ
• The local use of idea debugging is normal, and the jar package is published to the server and the error is reported as follows #211
• Data drill cannot be used #187
• I hope to add the function of printing all by page #200
• After the grouped cells are merged, the preview error #155
• It is uncomfortable without automatic saving, and it cannot be saved after a period of time #201
• 1.3.1-beta4 version, design page problem feedback issues/I3ITX4
• When the export list contains uppercase IOS (or uppercase English), the export will report error issues/I3IIR9
• Serious bug The new under mac is not easy to use 160a206721b22f issues/I3NL58
• SystemUtils.getHostName() in SnowflakeIdWorker class is empty in mac environment issues/I3NKZH
• The popup component setting radio does not work in the single table and main table state #2478
• Exporting to excel or pdf can only export the first page #157
• API query with parameters failed issues/I3JKM5
• API interface returns more than 5S how to deal with issues/I3O960
• service failed to start 160a206721b330 issues/I3O34Q
• API data set cannot automatically send token 160a206721b350 issues/I3OVQL
• The printed page does not switch between portrait and landscape #245
• The prompt content of the pie chart, lack of percentage support issues/I3NP5F
• When the 1.3.1-beta2 version requests an unofficial business interface, X-Access-Token is put in the request parameter, it is better to put it in the header issues/I3HDEI
• Use the system variable placeholder #{} to write the SQL data set, and the problem occurs. Hope to answer #203
• In the template case list, uploading the cover is unsuccessful, and the log prompts error #189
• Use the system variable placeholder #{} to write the SQL data set, and the problem occurs. Hope to answer issues/I3J5U7
• Large-screen column chart does not support interaction issues/I3MXKK
• js calculation total accuracy error problem

Code download

• https://github.com/zhangdaiscott/JimuReport
• https://gitee.com/jeecg/JimuReport

Technical documents

• Integration document http://report.jeecg.com/2078875
• Database script jimureport.sql
• Technical website: http://jimureport.com
• Technical documentation: http://report.jeecg.com

Why choose JimuReport?

It is free forever, supports a variety of complex reports, and fool-like online design, very smart, low-code era, this is your first choice!

• Scaffolding projects using SpringBoot can be quickly integrated
• Web version designer, similar to excel operation style, complete report design through drag and drop
• Bind the data source to the template through SQL, API, etc. At the same time, it supports expressions, automatic calculation of totals and other functions, which greatly reduces the calculation workload
• High development efficiency, fool-style online report design, design a report in one minute, simple and powerful
• Supports ECharts, currently supports 28 types of charts, online drag-and-drop design, supports SQL and API two data sources
• Support complex reports such as grouping, crossing, totaling, expressions, etc.
• Support printing design (support printing, background printing, etc.), setting printing margin, direction, header and footer and other parameters, one-click quick printing, at the same time, it can realize accurate and seamless printing of invoice printing and real estate certificate
• The large screen designer supports dozens of chart styles, which can be spliced and combined freely to design a cool large screen
• Various types of documents and large screens can be designed, such as warehouse receipts, sales orders, financial statements, contracts, monitoring large screens, tourism data large screens, etc.

System screenshot

• Report designer (completely online design, easy to use)

• Print design (support pattern printing, background printing)

• Data report (supports complex reports such as grouping, crossing, and totaling)

• Graphical report (currently supports 28 types of charts)

Function list

├─报表设计器
│  ├─数据源
│  │  ├─支持多种数据源，如Oracle,MySQL,SQLServer,PostgreSQL等主流的数据库
│  │  ├─支持SQL编写页面智能化，可以看到数据源下面的表清单和字段清单
│  │  ├─支持参数
│  │  ├─支持单数据源和多数数据源设置
│  ├─单元格格式
│  │  ├─边框
│  │  ├─字体大小
│  │  ├─字体颜色
│  │  ├─背景色
│  │  ├─字体加粗
│  │  ├─支持水平和垂直的分散对齐
│  │  ├─支持文字自动换行设置
│  │  ├─图片设置为图片背景
│  │  ├─支持无线行和无限列
│  │  ├─支持设计器内冻结窗口
│  │  ├─支持对单元格内容或格式的复制、粘贴和删除等功能
│  │  ├─等等
│  ├─报表元素
│  │  ├─文本类型：直接写文本；支持数值类型的文本设置小数位数
│  │  ├─图片类型：支持上传一张图表；支持图片动态生成
│  │  ├─图表类型
│  │  ├─函数类型
│  │  └─支持求和
│  │  └─平均值
│  │  └─最大值
│  │  └─最小值
│  ├─背景
│  │  ├─背景颜色设置
│  │  ├─背景图片设置
│  │  ├─背景透明度设置
│  │  ├─背景大小设置
│  ├─数据字典
│  ├─报表打印
│  │  ├─自定义打印
│  │  └─医药笺、逮捕令、介绍信等自定义样式设计打印
│  │  ├─简单数据打印
│  │  └─出入库单、销售表打印
│  │  └─带参数打印
│  │  └─分页打印
│  │  ├─套打
│  │  └─不动产证书打印
│  │  └─发票打印
│  ├─数据报表
│  │  ├─分组数据报表
│  │  └─横向数据分组
│  │  └─纵向数据分组
│  │  └─多级循环表头分组
│  │  └─横向分组小计
│  │  └─纵向分组小计
│  │  └─合计
│  │  ├─交叉报表
│  │  ├─明细表
│  │  ├─带条件查询报表
│  │  ├─表达式报表
│  │  ├─带二维码/条形码报表
│  │  ├─多表头复杂报表
│  │  ├─主子报表
│  │  ├─预警报表
│  │  ├─数据钻取报表
│  ├─图形报表
│  │  ├─柱形图
│  │  ├─堆叠柱形图
│  │  ├─折线图
│  │  ├─饼图
│  │  ├─动态轮播图
│  │  ├─折柱图
│  │  ├─散点图
│  │  ├─漏斗图
│  │  ├─雷达图
│  │  ├─象形图
│  │  ├─地图
│  │  ├─仪盘表
│  │  ├─关系图
│  │  ├─图表背景
│  │  ├─图表动态刷新
│  │  ├─图表数据字典
│  ├─参数
│  │  ├─参数配置
│  │  ├─参数管理
│  ├─导入导出
│  │  ├─支持导入Excel
│  │  ├─支持导出Excel、pdf；支持导出excel、pdf带参数
│  ├─打印设置
│  │  ├─打印区域设置
│  │  ├─打印机设置
│  │  ├─预览
│  │  ├─打印页码设置
├─大屏设计器
│  ├─系统功能
│  │  ├─静态数据源和动态数据源设置
│  │  ├─基础功能
│  │  └─支持拖拽设计
│  │  └─支持增、删、改、查大屏
│  │  └─支持复制大屏数据和样式
│  │  └─支持大屏预览、分享
│  │  └─支持系统自动保存数据，同时支持手动恢复数据
│  │  └─支持设置大屏密码
│  │  └─支持对组件图层的删除、组合、上移、下移、置顶、置底等
│  │  ├─背景设置
│  │  └─大屏的宽度和高度设置
│  │  └─大屏简介设置
│  │  └─背景颜色、背景图片设置
│  │  └─封面图设置
│  │  └─缩放比例设置
│  │  └─环境地址设置
│  │  └─水印设置
│  │  ├─地图设置
│  │  └─添加地图
│  │  └─地图数据隔离
│  ├─图表
│  │  ├─柱形图
│  │  ├─折线图
│  │  ├─折柱图
│  │  ├─饼图
│  │  ├─象形图
│  │  ├─雷达图
│  │  ├─散点图
│  │  ├─漏斗图
│  │  ├─文本框
│  │  ├─跑马灯
│  │  ├─超链接
│  │  ├─实时时间
│  │  ├─地图
│  │  ├─全国物流地图
│  │  ├─地理坐标地图
│  │  ├─城市派件地图
│  │  ├─图片
│  │  ├─图片框
│  │  ├─轮播图
│  │  ├─滑动组件
│  │  ├─iframe
│  │  ├─video
│  │  ├─翻牌器
│  │  ├─环形图
│  │  ├─进度条
│  │  ├─仪盘表
│  │  ├─字浮云
│  │  ├─表格
│  │  ├─选项卡
│  │  ├─万能组件
└─其他模块
   └─更多功能开发中。。