Project introduction
Building block report, a free Visual Web Report tool, online drag and drop design like building blocks! Functions include data report, print design, chart report, large screen design, etc!
Adhering to the product concept of "simple, easy-to-use and professional", it greatly reduces the difficulty of report development, shortens the development cycle, saves costs and solves all kinds of report problems. It is completely free!
Current version: v1.0 5.0-beta | 2022-04-18
Integration dependency
<dependency> <groupId>org.jeecgframework.jimureport</groupId> <artifactId>jimureport-spring-boot-starter</artifactId> <version>1.5.0-beta</version> </dependency>
If there is a jsqlparser incompatibility problem, please refer to it in this way
<dependency> <groupId>org.jeecgframework.jimureport</groupId> <artifactId>jimureport-spring-boot-starter</artifactId> <version>1.5.0-beta</version> <exclusions> <exclusion> <artifactId>minidao-spring-boot-starter</artifactId> <groupId>org.jeecgframework</groupId> </exclusion> </exclusions> </dependency> <dependency> <groupId>org.jeecgframework</groupId> <artifactId>minidao-spring-boot-starter</artifactId> <version>1.8.8</version> </dependency>
Upgrade log
Focus on upgrading minidao1 9.0 (jsqlparser upgraded to 4.3) may be incompatible, and the code will be greatly refactored, optimized and security enhanced.
Key functions
- SQL execution interface plus signature check to prevent illegal SQL attacks
- Upgrade minidao1.0 9.0 (upgrade the underlying jsqlparser to 4.3)
- Upgrade springboot2.0 six point six
- Support to cancel sharing password
- Reconstruction of drop-down single selection and drop-down multiple selection
Issues processing
- In microservice mode, the customPrePath project name will not be added #890
- The automatic refresh of 180 degree instrument panel data is invalid #897
- Redis and Mongodb chart data source configuration problem #887
- When using Excel to export, there is an exception prompt of Blank expression #859
- When the report is drilled down, the query parameters returned to the previous page will be lost #881
- 1.4.4 dictionary single choice drop-down question #866
- The dictionary is invalid. Take the name as a parameter without taking the data value #I50J2C
- The pie chart displays the values of each category on the chart #I50IKB
- About customGroup grouping #836
- oracle is selected as the data source, and the data cannot be queried through the stored procedure #816
Code download
Technical documentation
- Experience official website: http://jimureport.com
- Quickly integrate documents: http://report.jeecg.com/2078875
- Technical documentation: http://report.jeecg.com
Why choose JimuReport?
Permanent free, support various 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 designer, similar to excel operation style, completes report design by dragging
- Bind the data source to the template through SQL, API, etc. At the same time, it supports functions such as expression and automatic calculation of total, so as to reduce the calculation workload
- Development efficiency is very high, fool online report design, one report per minute, simple and powerful
- It supports ECharts. Currently, it supports 28 kinds of charts, online drag and drop design, and supports two data sources: SQL and API
- Support grouping, cross, total, expression and other complex reports
- Support printing design (support template printing, background printing, etc.) can set parameters such as printing margin, direction, header and footer, and print quickly with one key. At the same time, it can realize template printing, real estate certificate and other accurate and seamless printing
- The large screen designer supports dozens of chart styles, which can be spliced and combined freely to design Cool large screens
- Various types of documents and large screens can be designed, such as stock in and stock out documents, sales documents, financial statements, contracts, monitoring screens, tourism data screens, etc
System screenshot
- Report designer (professional first-class data visualization to solve various report problems)
- Report designer (fully online design, easy to use)
- Print design (support template printing and background printing)
- Data report (supporting complex reports such as grouping, cross and total)
- Graphical report (currently supports 28 kinds of charts)
- Data report zebra crossing
Function list
├─Report Designer │ ├─data source │ │ ├─Support multiple data sources, such as Oracle,MySQL,SQLServer,PostgreSQL And other mainstream databases │ │ ├─support SQL Write the page intelligently, and you can see the table list and field list under the data source │ │ ├─Support parameters │ │ ├─Single data source and most data source settings are supported │ │ ├─support Nosql data source Redis，MongoDB │ │ ├─Support stored procedures │ ├─Format cells │ │ ├─frame │ │ ├─font size │ │ ├─Font color │ │ ├─Background color │ │ ├─Bold font │ │ ├─Support horizontal and vertical scattered alignment │ │ ├─Support word wrap settings │ │ ├─Set picture as picture background │ │ ├─Supports wireless rows and unlimited columns │ │ ├─Supports freezing windows in the designer │ │ ├─Supports functions such as copying, pasting and deleting cell contents or formats │ │ ├─wait │ ├─Report element │ │ ├─Text type: write text directly; Supports setting decimal places for numeric text │ │ ├─Image type: supports uploading a chart; Support dynamic image generation │ │ ├─Chart type │ │ ├─Function type │ │ └─Support summation │ │ └─average value │ │ └─Maximum │ │ └─minimum value │ ├─background │ │ ├─Background color settings │ │ ├─Background picture settings │ │ ├─Background transparency settings │ │ ├─Background size setting │ ├─data dictionary │ ├─Report printing │ │ ├─Custom printing │ │ └─Custom style design and printing of medical notes, arrest warrants, letters of introduction, etc │ │ ├─Simple data printing │ │ └─Print receipt / issue document and sales table │ │ └─Print with parameters │ │ └─page printing │ │ ├─Set beating │ │ └─Printing of real estate certificate │ │ └─Print │ ├─Data report │ │ ├─Group data report │ │ └─Horizontal data grouping │ │ └─Vertical data grouping │ │ └─Multi level cycle header grouping │ │ └─Subtotal, horizontal grouping │ │ └─Subtotal, vertical grouping │ │ └─Partition │ │ └─Column │ │ └─Dynamic merge cell │ │ └─Number of custom pages │ │ └─total │ │ ├─Cross Report │ │ ├─Schedule │ │ ├─Conditional query report │ │ ├─Expression Report │ │ ├─With QR code/Barcode Report │ │ ├─Multi header Complex Report │ │ ├─Master sub report │ │ ├─Early warning report │ │ ├─Data drilling Report │ ├─Graphical report │ │ ├─Column chart │ │ ├─Stacked column chart │ │ ├─Broken line │ │ ├─Pie chart │ │ ├─Dynamic rotation chart │ │ ├─Column folding diagram │ │ ├─Scatter diagram │ │ ├─Funnel diagram │ │ ├─Radar chart │ │ ├─Pictogram │ │ ├─Map │ │ ├─Instrument panel table │ │ ├─Relation diagram │ │ ├─Chart background │ │ ├─Chart dynamic refresh │ │ ├─Chart data dictionary │ ├─parameter │ │ ├─Parameter configuration │ │ ├─Parameter management │ ├─Import and export │ │ ├─Support import Excel │ │ ├─Support export Excel,pdf；Support export excel,pdf With parameters │ ├─Print settings │ │ ├─Print locale │ │ ├─Printer settings │ │ ├─preview │ │ ├─Print page number setting ├─Large screen Designer │ ├─system function │ │ ├─Static and dynamic data source settings │ │ ├─Basic functions │ │ └─Support drag and drop design │ │ └─It supports adding, deleting, modifying and checking the large screen │ │ └─Supports copying large screen data and styles │ │ └─Support large screen preview and sharing │ │ └─Support the system to save data automatically and recover data manually │ │ └─Support setting large screen password │ │ └─Support the deletion, combination, up, down, top and bottom of component layers │ │ ├─Background settings │ │ └─Width and height setting of large screen │ │ └─Large screen introduction settings │ │ └─Background color and background picture settings │ │ └─Cover map settings │ │ └─Scale settings │ │ └─Environment address setting │ │ └─Watermark settings │ │ ├─Map settings │ │ └─Add map │ │ └─Map data isolation │ ├─Chart │ │ ├─Column chart │ │ ├─Broken line │ │ ├─Column folding diagram │ │ ├─Pie chart │ │ ├─Pictogram │ │ ├─Radar chart │ │ ├─Scatter diagram │ │ ├─Funnel diagram │ │ ├─Text box │ │ ├─horse race lamp │ │ ├─Hyperlinks │ │ ├─Real time │ │ ├─Map │ │ ├─National logistics map │ │ ├─Geographic coordinate map │ │ ├─City dispatch map │ │ ├─picture │ │ ├─Picture box │ │ ├─Rotation map │ │ ├─Slide assembly │ │ ├─iframe │ │ ├─video │ │ ├─Flop │ │ ├─Ring diagram │ │ ├─progress bar │ │ ├─Instrument panel table │ │ ├─Word floating cloud │ │ ├─form │ │ ├─tab │ │ ├─Universal component └─Other modules └─More functions are under development..