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 various report problems. It is completely free!
Current version: v1.0 4.2 | 2021-12-06
Integration dependency
<dependency> <groupId>org.jeecgframework.jimureport</groupId> <artifactId>jimureport-spring-boot-starter</artifactId> <version>1.4.2</version> </dependency>
Upgrade log
Key new features
- Paging is set for the data source, and the exported excel data is empty.
- When setting the English or six digit color value, the color will not be displayed when the decimal data is set
- Set three digit color value to export excel without display color
- The map control adopts SQL data source and cannot be updated regularly
- If the slash header color is empty, a null pointer will be reported
- The average does not calculate empty cells
- The drop-down option effect is changed, but the query condition value is not changed
- The number of pages set for exporting excel is greater than the number. The first data source cannot be exported
- Multiple parameters cannot be resolved simultaneously in the same cell
- [import report] error report list page query is not transferred to json_str to avoid missing data
- Divisor cannot be 0
- Exporting excel and parameter replacement plus log does not work online
- When previewing the interface, click query and the scroll bar will disappear
- Memory problem export pdf empty map and json after processing
- Export excel and pdf, and use response to obtain the stream
- If the key does not exist, it should be cleared. Otherwise, sql can be parsed in saas mode
- The drop-down box of data source key prompts to display the data source id
- Export excel and pdf date format reconstruction, and support basic date format
- Replace mongo driver with mongodb driver sync, which is consistent with spring boot starter data mongodb
- Pagination is selected by default
- By default, the search drop-down box only displays 10 pieces of data. You can set the number of drop-down displays
- New building block report processing extJson parameter configuration constant class and name modification
- Upgrade the minidao version to solve the sql paging problem with limit
- Drill through jump carry token
- The numerical calculation is handed over to bigdecimal
- The number of decimal places is not set by default for numeric formatting
- Reconstruct the expression to solve the problem of inaccurate amount calculation
Issues processing
- When previewing the interface, click query and the scroll bar will disappear issues/#599
- Data display error after grouping issues/I4DSDM
- Total line issue = SUM(E4:L4) issues/I4FUJT
- Adding js enhanced code preview page to building block report is invalid issues/#610
- The average() dataset expression averages columns without excluding empty data issues/#I4EUZV
- Use horizontal and vertical combination dynamic column grouping, and the background template reports an error issues/#I4EB9G
- Stored procedure SQL parsing sorted by field name issues/#640
- Support saas configuration issues/#I4HWAM
- When selecting multiple drop-down tree controls, if they are selected incorrectly, they will not take effect in time after being detected. They must be reset issues/#I4FKR0
- Multiple parameters cannot be resolved simultaneously in the same cell issues/#I4EQ2K
- Combined dynamic column grouping bug issues/#607
- If the authentication database name and user name are inconsistent, mongo cannot be connected issues/#601
- Pagination is set for the data source, and the exported excel data is empty issues/#I4EAUY
- Tripping function problem issues/#I4IZ64
- Group aggregation problem optimization issues/#673
- Report export excel or PDF time data is missing issues/#663
- The table name item in the database of the National People's Congress gold warehouse is rendered empty. The first letter is required to be capitalized according to the rendering page, which can be configured issues/#I4IU2U
- 1.4. 0 conflicts with mongodb dependency, and an error is reported when starting issues/#I4ITG0
- The javabean data source is optimized, and the parsed field name is based on the passed field name issues/#I4HK1I
- excel contains custom format, upload failed issues/#I4HVDU
- Building block report configuration report drilling cell value transfer and table value transfer issues/#658
- One of the [parameter settings] of adding hyperlinks is parameters that cannot be obtained. issues/#I4HX60
- Display the total number of data in the data query toolbar issues/#672
- When using the NPC gold warehouse data source, the name returned by the back end is lowercase, so the table cannot be generated issues/#I4JBLE
- The search drop-down box displays only 10 pieces of data at most, and the number of pieces is displayed according to the configuration issues/#675
- Adding the built-in limit condition in SQL will report an error issues/#I4JFKQ
- When the chart is bound to the javaBean data source, an error is reported, and the error problem is reported to attach the solution issues/#I4I2X8
- Report drilling problem when using non administrator account issues/#680
- After setting the cell to the [number] type, an error will be reported when exporting to Excel. issues/#I4JWH3
- Drill through jump carry token issues/#I4JM0I
- The new SQL data source of graphical report cannot be displayed in the report issues/#I4FNJC
Code download
Technical documentation
- Experience official website: http://jimureport.com
- Quickly integrate documents: http://report.jeecg.com/2078875
- Technical documentation: http://report.jeecg.com
- QQ group: 212391162
Why choose JimuReport?
Permanent free, support all kinds 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 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, which greatly reduces the calculation workload
- High development efficiency, 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
- Complex reports such as grouping, crossing, total and expression are supported
- It supports print design (template printing, background printing, etc.) and can set parameters such as print margin, direction, header and footer. At the same time, it can realize accurate and seamless printing of invoice template printing and real estate certificate
- 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 warehouse in / 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 (supports 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 text 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 │ │ ├─Picture 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 issue / receipt doc and sales table │ │ └─Print with parameters │ │ └─page printing │ │ ├─Set beating │ │ └─Printing of real estate certificate │ │ └─Invoice printing │ ├─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 lattice │ │ └─Number of custom pages │ │ └─total │ │ ├─Cross Report │ │ ├─Schedule │ │ ├─Query report with criteria │ │ ├─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 │ │ ├─Line chart │ │ ├─Pie chart │ │ ├─Dynamic rotation chart │ │ ├─Column folding diagram │ │ ├─Scatter diagram │ │ ├─Funnel diagram │ │ ├─Radar chart │ │ ├─Pictogram │ │ ├─Map │ │ ├─Instrument panel table │ │ ├─Diagram │ │ ├─Chart background │ │ ├─Chart dynamic refresh │ │ ├─Chart data dictionary │ ├─parameter │ │ ├─Parameter configuration │ │ ├─Parameter management │ ├─Import export │ │ ├─Support import Excel │ │ ├─Support export Excel,pdf；Support export excel,pdf With parameters │ ├─Print settings │ │ ├─Print locale │ │ ├─Printer settings │ │ ├─preview │ │ ├─Print page number settings ├─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 │ │ └─It supports 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 │ │ ├─Line chart │ │ ├─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 chart │ │ ├─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..