Building block report · JimuReport 1.3.64 version released, a free enterprise-level visual report tool

project introduction

Block report, a free visual web report tool, drag and drop design online 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. It is completely free! ! !

current version : v1.3.64-beta | 2021-07-13

integration depends on

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

Incremental SQL

ALTER TABLE `jimu_report_db_param`
ADD COLUMN `search_flag` int(1) NULL COMMENT '查询标识0否1是 默认0' AFTER `update_time`;
update jimu_report_db_param set search_flag = 0;
create table jimu_dict like sys_dict;
insert into jimu_dict select * from sys_dict;
create table jimu_dict_item like sys_dict_item;
insert into jimu_dict_item select * from sys_dict_item;

log

new features

• Refactored group report function, supports subtotals in groups, supports setting group field sorting, dynamic data supplementation, etc.
• The new version of the export pdf function is reconstructed, and it supports expressions, font styles, backgrounds, overlays, and cross table headers.
• The dictionary table name is changed to jimu_* prefix to distinguish it from system tables
• The hyperlink color follows the font color and does not set the default blue
• Export excel supports api method call
• Fix the bug of repeated setting of loop block
• If the dynamic loop header is empty, there will be a null pointer problem
• Horizontal grouping background error
• api timeout prompt, select * multiple fields cause an error, the page shows that the table name does not exist, the prompt is incorrect, and it prompts to modify tb JMREP-2066
• The custom project prefix parameter customPrePath under microservices is not easy to use
• Solve the problem of springboot2.5 integrating minidao null pointer
• Support dynamic data source configuration (minidao default data source name: minidaoDataSource, if not configured, the first data source configuration will be taken randomly)
• Drill through new window does not display the next page
• Serious: The row height set in the template is restored to the default height when previewing
• The main sub-report has dictionary values but no translations, resulting in the sub-table query not coming out

Issues deal with

• When exporting excel, the picture is not exported #230
• The building block report does not support MYSQL built-in functions, error #277
• The decimal point value of the table is 0, and the display digits are invalid. #136
• Upload template does not support xls I3SSJ0
• The query bar searches for the time type and range, the default value 3SN3P
• Drill down to the next page, can you add an operation to return to the previous page I3SL05
• Chart linkage can see the deleted icon I3SEV4
• There are many columns. When editing, the column is only displayed to the AX column, and the latter column is not displayed, which makes it impossible to modify I3RQIT
• the option of 10 items per page to no 20 information, the number of printed and exported data is not correct, all are 10 160efa4c2ba022 I3NZF8
• SQL parsing failure in sql data set I3NCM7
• Use function hope to support cell drag and drop selection I3SZPP
• The database is not initialized after SpringBoot 2.5.0 integration I3TD7G
• integrates error 160efa4c2ba1cc I3QC15 according to the documentation
• Startup report MinidaoAutoConfiguration initialization failure I3SIEX
• I hope to cancel the intrusive behavior of the data dictionary, and perform front-end caching through api or json I3UIJ4
• Can url parameters be placed in the report? I3U3Q5
• Online design is not well managed I3UQEE
• The browser parameters are displayed directly on the report. Export without parameters. I3ZAEU
• When the mouse loses focus in the api address input box, the interface parameters will be cleared I3YP2X
• Horizontal grouping, if the data is missing, the report shows an error. I3XT94
• According to the query, export Excel does not parameter 160efa4c2ba394 I3XI9M
• Can the subtotals be dynamically listed to other grids that are not a column? I3XYZ3
• api data set get request cannot get parameters #322
• After the building block report column exceeds the set paper width, the adjustment will have formatting problems #359
• Report designer function optimization #321
• The problem of layer data confusion when searching for conditions of graphics reports #325
• For non-jeecg-boot project integrated building block report, when uploading the background image, the token is not added in the request header, can it be added? #318
• First page paging problem #291
• When using multiple data comparison histograms, if the charts overlap after the query conditions #305
• There are negative numbers in the table. When adding up, setting two decimal places does not work, and the data is incorrect #293
• API data source request timeout 160efa4c2ba59c #319
• Combine the two rows of the table, the print data shows that there is a problem #298
• Preview and design load external network js, slow loading #316
• [Bug] Cross report export error #339
• The report is connected to the SQL Server with more than 600 tables, and the SQL page is stuck after editing #333
• If the header is grouped horizontally, the excel export fails #353
• If there is no data in the main table of the main table of the building block report, the page will have an error #2660
• [Report Designer] The font cannot be changed after the link is added #2702
• [Report Designer] The loop block cannot be cancelled #2606

download

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

document

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

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 margins, directions, headers and footers and other parameters, one-click quick printing, at the same time, it can realize accurate and seamless printing of invoice printing, real estate certificate, etc.
• 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.

screenshot

• Report designer (professional first-class data visualization, solve all kinds of report problems)
  
• 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)

list

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