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.7 | 2021-08-02
Integration dependency
<dependency>
<groupId>org.jeecgframework.jimureport</groupId>
<artifactId>jimureport-spring-boot-starter</artifactId>
<version>1.3.75</version>
</dependency>
Incremental SQL
ALTER TABLE `jimu_report_db_param`
ADD COLUMN `widget_type` varchar(50) NULL COMMENT '查询控件类型' AFTER `search_flag`,
ADD COLUMN `search_mode` int(1) NULL COMMENT '查询模式1简单2范围' AFTER `widget_type`,
ADD COLUMN `dict_code` varchar(255) NULL COMMENT '字典' AFTER `search_mode`;
Upgrade log
Key new features
- Toolbar supports hiding custom settings
- Add expression engine to support complex expressions
- Database compatibility optimization, support 14 kinds of databases including domestic products
- sql parsing optimization
- Support double-click to copy text
- Wrap adaptive height
- The row height and column width cannot be quantitatively set during report design
- Blank line filling function
Issues handling
- JSON text causes abnormal report data parsing issues/I3Y8Y9
- I hope the report content can support the option to copy #355
- The field content is too long and the line height cannot automatically adapt to issues/I3Y6PZ
- A single category chart cannot be saved after changing the color #361
- There are more options in the drop-down box of the parameter report than the actual content #326
- issues/I3Y36C
- when exporting Excel #362
- Enter when querying, the page will be refreshed instead of returning the query result 16110a021f08ce #374
- Report design authority management (you can only see the reports you created) #368
- Linkage drill report hyperlink settings-the original parameter drop-down box has no optional data field issues/I40TVU
- When a large amount of data is used, an error is reported when the result obtained by the export Excel method is used. issues/I40NLQ
- Report copy, the binding relationship between the main and sub-parameters is lost issues/I40IMT
- Show issue #390
- If there is no value in the dynamic attribute, 0 should be displayed. It should be empty. It is not a numeric type issues/I40E4A
- Api data source field display issues issues/I409J8
- Export pdf date formatting is invalid issues/I412JQ
- Can you close the top page control bar #191
- When parsing column names, will be generated twice #387
- Obtain table data by page, when you enter the page number, then click on the previous page and the home page does not respond issues/I40KH4
- Group report, set table border, export excel error report when more than 200 records are exported (emergency solution when the project is online) #397
- The date cannot be formatted and displayed #394
- Does the data source support database 16110a021f0a8d #399
- Support the function of automatically adding blank lines issues/I40QED
- Formula add #310
- Data report adds color change setting options between row levels #288
- Report design cell settings #338
- Export custom rules for excel, the display rules do not display the value issues/I3MX8U
- Decimal place with thousandth sign #391
- After setting the number of decimal places, the exported #392
Code download
Technical documentation
- Experience official website: http://jimureport.com
- Quick integration document: http://report.jeecg.com/2078875
- 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.
System 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)
Function list
├─报表设计器
│ ├─数据源
│ │ ├─支持多种数据源,如Oracle,MySQL,SQLServer,PostgreSQL等主流的数据库
│ │ ├─支持SQL编写页面智能化,可以看到数据源下面的表清单和字段清单
│ │ ├─支持参数
│ │ ├─支持单数据源和多数数据源设置
│ ├─单元格格式
│ │ ├─边框
│ │ ├─字体大小
│ │ ├─字体颜色
│ │ ├─背景色
│ │ ├─字体加粗
│ │ ├─支持水平和垂直的分散对齐
│ │ ├─支持文字自动换行设置
│ │ ├─图片设置为图片背景
│ │ ├─支持无线行和无限列
│ │ ├─支持设计器内冻结窗口
│ │ ├─支持对单元格内容或格式的复制、粘贴和删除等功能
│ │ ├─等等
│ ├─报表元素
│ │ ├─文本类型:直接写文本;支持数值类型的文本设置小数位数
│ │ ├─图片类型:支持上传一张图表;支持图片动态生成
│ │ ├─图表类型
│ │ ├─函数类型
│ │ └─支持求和
│ │ └─平均值
│ │ └─最大值
│ │ └─最小值
│ ├─背景
│ │ ├─背景颜色设置
│ │ ├─背景图片设置
│ │ ├─背景透明度设置
│ │ ├─背景大小设置
│ ├─数据字典
│ ├─报表打印
│ │ ├─自定义打印
│ │ └─医药笺、逮捕令、介绍信等自定义样式设计打印
│ │ ├─简单数据打印
│ │ └─出入库单、销售表打印
│ │ └─带参数打印
│ │ └─分页打印
│ │ ├─套打
│ │ └─不动产证书打印
│ │ └─发票打印
│ ├─数据报表
│ │ ├─分组数据报表
│ │ └─横向数据分组
│ │ └─纵向数据分组
│ │ └─多级循环表头分组
│ │ └─横向分组小计
│ │ └─纵向分组小计
│ │ └─合计
│ │ ├─交叉报表
│ │ ├─明细表
│ │ ├─带条件查询报表
│ │ ├─表达式报表
│ │ ├─带二维码/条形码报表
│ │ ├─多表头复杂报表
│ │ ├─主子报表
│ │ ├─预警报表
│ │ ├─数据钻取报表
│ ├─图形报表
│ │ ├─柱形图
│ │ ├─堆叠柱形图
│ │ ├─折线图
│ │ ├─饼图
│ │ ├─动态轮播图
│ │ ├─折柱图
│ │ ├─散点图
│ │ ├─漏斗图
│ │ ├─雷达图
│ │ ├─象形图
│ │ ├─地图
│ │ ├─仪盘表
│ │ ├─关系图
│ │ ├─图表背景
│ │ ├─图表动态刷新
│ │ ├─图表数据字典
│ ├─参数
│ │ ├─参数配置
│ │ ├─参数管理
│ ├─导入导出
│ │ ├─支持导入Excel
│ │ ├─支持导出Excel、pdf;支持导出excel、pdf带参数
│ ├─打印设置
│ │ ├─打印区域设置
│ │ ├─打印机设置
│ │ ├─预览
│ │ ├─打印页码设置
├─大屏设计器
│ ├─系统功能
│ │ ├─静态数据源和动态数据源设置
│ │ ├─基础功能
│ │ └─支持拖拽设计
│ │ └─支持增、删、改、查大屏
│ │ └─支持复制大屏数据和样式
│ │ └─支持大屏预览、分享
│ │ └─支持系统自动保存数据,同时支持手动恢复数据
│ │ └─支持设置大屏密码
│ │ └─支持对组件图层的删除、组合、上移、下移、置顶、置底等
│ │ ├─背景设置
│ │ └─大屏的宽度和高度设置
│ │ └─大屏简介设置
│ │ └─背景颜色、背景图片设置
│ │ └─封面图设置
│ │ └─缩放比例设置
│ │ └─环境地址设置
│ │ └─水印设置
│ │ ├─地图设置
│ │ └─添加地图
│ │ └─地图数据隔离
│ ├─图表
│ │ ├─柱形图
│ │ ├─折线图
│ │ ├─折柱图
│ │ ├─饼图
│ │ ├─象形图
│ │ ├─雷达图
│ │ ├─散点图
│ │ ├─漏斗图
│ │ ├─文本框
│ │ ├─跑马灯
│ │ ├─超链接
│ │ ├─实时时间
│ │ ├─地图
│ │ ├─全国物流地图
│ │ ├─地理坐标地图
│ │ ├─城市派件地图
│ │ ├─图片
│ │ ├─图片框
│ │ ├─轮播图
│ │ ├─滑动组件
│ │ ├─iframe
│ │ ├─video
│ │ ├─翻牌器
│ │ ├─环形图
│ │ ├─进度条
│ │ ├─仪盘表
│ │ ├─字浮云
│ │ ├─表格
│ │ ├─选项卡
│ │ ├─万能组件
└─其他模块
└─更多功能开发中。。
**粗体** _斜体_ [链接](http://example.com) `代码` - 列表 > 引用
。你还可以使用@
来通知其他用户。