Project introduction

Building blocks report, is a free visual Web report tools, like building building blocks online drag and drop design report! Features cover, data report, print design, chart report, large screen design, etc.


Adhering to the “simple, easy to use, professional” product concept, greatly reduce the difficulty of report development, shorten the development cycle, save costs, solve all kinds of report problems, the focus of this software is completely free!!

The current version: v1.3.4 – beta | 2021-06-07

Integration depends on
<dependency> <groupId>org.jeecgframework.jimureport</groupId> <artifactId>spring-boot-starter-jimureport</artifactId> < version > 1.3.4 - beta < / version > < / dependency >

Incremental SQL

ALTER TABLE 'jimu_report_link' ADD COLUMN 'link_chart_id' varchar(50) NULL COMMENT 'AFTER' api_url '; ALTER TABLE 'JIMU_REPORT_DB' ADD COLUMN 'API_CONVERT' VARCHAR (255) NULL COMMENT 'AFTER' JSON_DATA ';
The upgrade log
New features
  • Charts support JavaBeans and JSON datasets
  • HTML printing mode supports chart and picture printing
  • Supports master and child reports
  • Exporting Excel picture location problem solved
  • Chart linkage reconstruction
  • Compatible with MariaDB databases
  • Gitee i3R92i, i3NSQK, i3O1R2 GitHub 238, 255, 224
  • Exporting the Excel API can export the current page. Exporting all can be done using printAll
  • Preview page token issue
  • Preview page display number per page drop – down box support customization
  • Map made to drop – down selection, do not need manual configuration
  • Preview page MySQL decryption function after decryption of data is not properly displayed in GitHub 262
  • Can the query condition support the input retrieval function github #256? The size of the query box is not consistent github #257
  • SQL parsing failed, using pop-up parameter filling way
  • Excel big data export, Excel sub-sheet export, less than 1000 to set the style, more than 1000 set the default style
  • Drill support returns to the previous page
  • Support for API converters
  • Excel imports support XLS
Issues to deal with
  • The chart linkage can not be bound to upload the cover feature has not been developed #214
  • Version 1.2.0 updated to 1.3.21-beta — Report List Query — Paging Issues /I3QJKH
  • Unable to obtain system date #{sys_date} as default query condition, can this be implemented now
  • Map using static data no change #2528
  • When the report previews, sometimes the loading time is long, can you add a loading prompt, long blank, it feels a bit like BugIssues /I3OGJ7
  • When exporting Excel, the operation failed :1, according to background display should be array out of bounds issues/I3IT1X
  • Undertow container, Excel export function not good make #255
  • Error #238 for exporting Excel to Linux
  • Preview template function of the report homepage, click and then jump to the page without Token #218
  • Export Excel without paging! issues/I3NPN2
  • Exception Issues /I3NSQK in Export Excel
  • Can the query condition support input retrieval function #256
  • Query box size not consistent #257
  • Dictionary dynamic acquisition issues/I3S172
  • The data report preview returns an error #270 when a field in the SQL result set has JSON data
  • Print handwriting, blur #286
  • Blockblock report does not support MySQL built-in functions. Error #277 in view parsing
  • When Excel was exported, the image was not exported #230
  • Table decimal value is 0, set display number invalid #136
  • Unable to display the default value Issues /I3SN3P in the query bar
  • Drill to the next page, can increase the return to the previous page operation issues/I3SL05
  • The chart linkage can see the deleted icon Issues /I3SEV4
  • Issues /I3RQIT cannot be changed due to the fact that the column is only displayed to AX column when editing
  • When you change the option of 10 items per page to no 20 items, you print and export the wrong amount of data, both 10 items
  • Issues of SQL parsing in SQL dataset
The code download
  • https://github.com/zhangdaiscott/JimuReport
  • https://gitee.com/jeecg/JimuReport
Technical documentation
  • Integrated document http://report.jeecg.com/2078875
  • The database script jimureport.sql
  • Technology official website: http://jimureport.com
  • Technical documentation: http://report.jeecg.com
  • QQ group: 212391162

Why JimuReport?

Free forever, support a variety of complex reports, and fool online design, very intelligent, low code era, this is your first choice!

  • Scaffolding projects using SpringBoot can be quickly integrated
  • Web version of the designer, similar to the Excel operation style, through drag and drop to complete the report design
  • The data source is bound to the template through SQL, API, etc. At the same time support expression, automatic calculation of total and other functions, so that the calculation workload is greatly reduced
  • Development efficiency is very high, stupid online report design, a minute to design a report, simple and powerful
  • Support for Echarts, currently support 28 kinds of charts, online drag and drop design, support SQL and API two data sources
  • Support group, crossover, total, expression and other complex reports
  • Support printing design (support set printing, background printing, etc.) You can set printing margin, direction, page header and footer and other parameters to print quickly with one key. At the same time, accurate and seamless printing of invoice set printing and real estate certificate can be realized
  • Large screen designer supports dozens of chart styles, can be freely spliced, combination, design cool large screen
  • Various types of documents and screens can be designed, such as inbound and outbound receipts, sales receipts, financial statements, contracts, monitoring screens, tourism data screens, etc
The system screenshots
  • Report Designer (completely online design, easy to use)

  • Print design (support set printing, background printing)

  • Data report (support group, cross, total and other complex reports)

  • Graphic report (28 types of charts currently supported)
Feature list
├ ─ report designer │ ├ ─ data source │ │ ├ ─ supports multiple data sources, such as Oracle, MySQL, essentially, PostgreSQL and other mainstream database │ │ ├ ─ intelligent support SQL code page, │ │ ├─ Support Parameters │ │ ├─ Support Single Data Source and Multiple Data Source Setup │ ├─ Bass Format │ │ ├─ Bass Bass - Font Size │ │ ├─ Fass Color │ Background Color │ ├─ Bold Font Setup There is also support for text and images to be used in the background. There is also support for wireless lines and unlimited columns. There is also support for freezing Windows in the drawer │ ├─ Bass Exercises - Report Elements │ ├─ Bass Exercises - Text Type: Write text directly; Support for setting fractional bits of text for numeric types. Support image dynamically generated │ │ ├ ─ chart type │ │ ├ ─ function types │ │ └ ─ support sum │ │ └ ─ average │ │ └ ─ the maximum │ │ └ ─ minimum │ ├ ─ background │ │ ├ ─ background color set │ │ ├ ─ the background image set │ │ ├ ─ background │ transparency setting Size set │ │ ├ ─ background ├ ─ data dictionary │ ├ ─ print │ │ ├ ─ custom print │ │ └ ─ medicine thinks, warrant, references and other custom style design print │ │ ├ ─ simple data printing │ │ └ ─ for single, sales table printing │ │ └ ─ with parameter print │ │ └ ─ paging print │ │ ├ ─ set play │ │ └ ─ real estate certificate print │ │ └ ─ invoice printing │ ├ ─ data report │ │ ├ ─ grouped data report │ │ └ ─ transverse data grouping │ │ └ ─ longitudinal data grouping │ │ └ ─ multistage circulation header grouping │ │ └ ─ transverse grouping subtotal │ │ └ ─ longitudinal grouping subtotal │ │ └ ─ combined │ │ ├ ─ cross statements │ │ ├ ─ list │ │ ├ ─ with conditions query statements │ │ ├ ─ expression statements │ │ ├ ─ take qr code/bar code statements │ │ ├ ─ header more complex statements │ │ ├ ─ master report │ │ ├ ─ │ warning statements │ │ ├ ─ drilling data statements ├ ─ graphical reports │ │ ├ ─ bar chart │ │ ├ ─ stacked bar chart │ │ ├ ─ line chart │ │ ├ ─ pie │ │ ├ ─ dynamic shuffling figure │ │ ├ ─ fold column figure │ │ ├ ─ scatterplot │ │ ├ ─ funnel figure │ │ ├ ─ entirely │ │ ├ ─ pictogram │ │ ├ ─ map │ │ ├ ─ instrument tray table │ │ ├ ─ diagram │ │ ├ ─ the chart background │ │ ├ ─ chart dynamic refresh │ │ ├ ─ the chart data dictionary │ ├ ─ parameter │ │ ├ ─ parameter configuration │ │ ├ ─ parameter management │ ├ ─ import and export │ │ Support for Exporting Excel and PDF; Support for Exporting Excel and PDF with Parameters │ │ ├─ Bass Exercises - Print Area Settings │ │ ├─ Bass Exercises - Preview │ │ ├─ Bass Exercises - Print Page Number Settings - System Functions │ │ ├─ Bass Exercises - Static and Dynamic Data Sources Settings │ │ ├─ Bass Exercises - Basic Functions │ │ └ ─ support drag and drop design │ │ └ ─ support for add, delete, change, check │ │ └ ─ support copy screen data and style │ │ └ ─ support preview screen, sharing │ │ └ ─ support system automatically save the data, │ ├─ └, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton, Triton │ └ ─ cover set │ │ └ ─ scaling set │ │ └ ─ environment address set │ │ └ ─ watermark set │ │ ├ ─ map set │ │ └ ─ add maps │ │ └ ─ map data isolation │ ├ ─ chart │ │ ├ ─ bar chart │ │ ├ ─ line chart │ │ ├ ─ figure │ fold column │ ├ ─ pie │ │ ├ ─ pictogram │ │ ├ ─ entirely │ │ ├ ─ scatterplot │ │ ├ ─ funnel figure │ │ ├ ─ text box │ │ ├ ─ entertaining diversions │ │ ├ ─ hyperlinks │ │ ├ ─ real time │ │ ├ ─ map │ │ ├ ─ the logistic map │ │ ├ ─ geographic coordinates map │ │ ├ ─ city sent a map │ │ ├ ─ image │ │ ├ ─ picture box │ │ ├ ─ shuffling figure │ │ ├ ─ sliding component │ │ ├ ─ iframe │ │ ├ ─ video │ │ ├ ─ double dealer │ │ ├ ─ circular diagram │ │ ├ ─ progress bar │ │ ├ ─ instrument tray table │ │ ├ ─ word cloud │ │ ├ ─ form │ │ ├ ─ TAB │ │ ├ ─ universal component └ ─ other modules └ ─ development. More features.