Project introduction

Building blocks report, a free visual Web report tools, like building building blocks online drag and drop design! 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, completely free!!

The 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 '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;
# update log
New features
  • Group report function reconstruction, support subtotal within the group, support setting the sorting of group fields, dynamic data complement, etc
  • The new export PDF features refactoring to support expressions, font styles, backgrounds, typing, and crossover headers
  • The dictionary table name is changed to the prefix JIMU_ * to distinguish it from the system table
  • The hyperlink color follows the font color without setting the default blue
  • Exporting Excel supports API way calls
  • Fixed bug of loop block repeat setting
  • Null pointer problems occur in dynamic loop headers if list is empty
  • Horizontal grouping background error report
  • The table name does not exist. The table name does not exist. The table name does not exist. The table name does not exist
  • Microservice under the custom project prefix parameter customPrePath, not good
  • Resolved Spring Boot2.5 integration with minidao null pointer issue
  • Support for dynamic data source configuration (MiniDAO default data source name: MiniDAO DataSource, if not configured randomly select the first data source configuration)
  • Drill out a new window without showing the next page
  • Serious: the row height set in the template is restored to the default height when previewing
  • A dictionary value in the master and child report is not translated, resulting in a query for the child table
Issues to deal with
  • When Excel was exported, the image was not exported #230
  • Blockblock report does not support MySQL built-in functions. Error #277 in view parsing
  • Table decimal value is 0, set display number invalid #136
  • The upload template does not support XLS I3SSJ0
  • The default value 3SN3P cannot be displayed in the query bar for time type and range search
  • Drill to the next page, can add return to the previous page operation I3SL05
  • The chart linkage can be seen with the deleted icon I3SEV4
  • There are too many columns. When editing, the columns are only displayed to AX. The following columns are not displayed, which makes it impossible to modify them
  • 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
  • The problem of SQL parsing failure in SQL dataset
  • Use functions that want to support cell drag and drop selection I3SZPP
  • SpringBoot 2.5.0 integration database not initialized I3TD7G
  • SpringBoot reports an error I3QC15 by the document integration
  • The startup report MINIDAOAUTOCONFIGURATION failed to initialize I3SIEX
  • We want to cancel the intrusion behavior of the data dictionary and use API or JSON to cache I3UIJ4 in the front end
  • Can URL parameters be placed in the report? I3U3Q5
  • Online design is not good for managing I3UQEE
  • Browser Passing shows the export directly on the report without exporting I3ZAEU with parameters
  • Interface parameters are cleared when the mouse loses focus in the API address input box
  • Horizontal grouping. If data is missing, the report displays an error. I3XT94
  • According to the query condition query, the export Excel does not pass in the parameter I3XI9M
  • Can you subtotal dynamic column to other non-column cells? I3XYZ3
  • The API data set GET request could not fetch parameter #322
  • Block report column beyond the set width of the paper, resizing will cause formatting problems #359
  • Report Designer feature optimization #321
  • Layer data error problem #325 in graph report condition search
  • The non-JEECG-BOOT project integrates the report of building blocks. When uploading the background image, there is no token added to the request header, can we add it? # 318
  • Home page problem #291
  • When comparing bar graphs with multiple data, the graphs overlap #305 after querying the condition
  • There are negative numbers in the table. When summing up, setting two decimal numbers does not work and the data is incorrect #293
  • 1.3.1- Beta4 API data source request timeout #319
  • Merge two rows of table, print data shows problem #298
  • Preview and design to load extranet js, load slow #316
  • [Bug] Cross-report export error #339
  • SQL Server, SQL Server, SQL Server, SQL Server, SQL Server, SQL Server, SQL Server
  • Excel export fails #353 in case of horizontal grouping of table headers
  • The page error #2660 occurs if the master table has no data in the master table
  • [Report Designer] Font cannot change color #2702 after adding link
  • [Report Designer] Looping block cannot be cancelled #2606
# code download
  • https://github.com/zhangdaiscott/JimuReport
  • https://gitee.com/jeecg/JimuReport
# Technical documentation
  • Integrated document: http://report.jeecg.com/2078875
  • 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
# 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 set printing, background printing)

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

  • Graphic report (28 types of charts currently supported)
# function 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.