Jimureport building block report v1 Version 4.2 release, free visual low code report

scott 2022-01-15 02:01:17
Project introduction
Building block Report , A free Visualization Web Report tool , Online drag and drop design like building blocks ! Function coverage , Data reports 、 Print design 、 Chart report 、 Large screen design, etc !
Uphold “ Simple 、 Easy to use 、 major ” The product concept of , Greatly reduce the difficulty of report development 、 Shorten development cycle 、 Cost savings 、 Solve all kinds of report problems , Completely free !

current version :v1.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
Focus on new features
  • Data source settings paging , export excel Data is empty .
  • When setting English or six digit color values , Encountered setting decimal data , The color does not show
  • Set the three digit color value export excel No display color
  • The map control uses SQL The data source 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 changes, but the query condition value does not change
  • export excel The number of pages set is greater than the number. The first data source cannot be exported
  • Multiple parameters cannot be resolved simultaneously in the same cell
  • 【 Import Report 】 Report errors list Page query is not transmitted json_str, Avoid missing data
  • The dividend cannot be zero 0
  • export excel And parameter replacement plus log , Online doesn't work
  • When previewing the interface , After clicking query , The scroll bar disappears
  • Memory problems export pdf Empty... After processing map、json
  • export excel、pdf reform Use response Get stream
  • If key Does not exist and should be emptied , Otherwise, in the saas In mode sql Can be parsed
  • data source key There is a drop-down box prompting to display the data source id
  • export excel、pdf Date format refactoring , Support basic date format
  • mongo Change the drive to mongodb-driver-sync, And spring-boot-starter-data-mongodb bring into correspondence with
  • Paging is selected by default
  • By default, the search drop-down box only displays 10 Data , You can set the number of drop-down displays
  • New building block report processing extJson Parameter configuration constant class and name modification
  • upgrade minidao edition , Solution containing limit Of sql Paging problem
  • Drill jump carry token
  • The numerical calculation is given to bigdecimal Handle
  • Value formatting The decimal places are not set by default
  • Refactoring expressions , Solve the problem of inaccurate amount calculation
Issues Handle
  • When previewing the interface , After clicking query , The scroll bar disappears issues/#599
  • Data display error after grouping issues/I4DSDM
  • Total line problem =SUM(E4:L4)issues/I4FUJT
  • Building block report add js Enhanced code preview paging is invalid issues/#610
  • average() The dataset expression averages the columns without excluding empty data issues/#I4EUZV
  • Dynamic column grouping using horizontal and vertical combinations , The background template reports an error issues/#I4EB9G
  • stored procedure SQL Resolve sorting by field name issues/#640
  • Support saas To configure issues/#I4HWAM
  • The drop-down tree control is used for multiple selections , If you choose the wrong one , It will not take effect in time , It must be reset issues/#I4FKR0
  • Multiple parameters cannot be resolved simultaneously in the same cell issues/#I4EQ2K
  • Group dynamic columns bug issues/#607
  • If the authentication database name and user name are inconsistent , Not even mongo issues/#601
  • Data source settings paging , export excel Data is empty issues/#I4EAUY
  • Tripping function problem issues/#I4IZ64
  • Group summary problem optimization issues/#673
  • Report export excel or PDF Time data missing issues/#663
  • People's Congress Jincang database The table name item is rendered empty , Look at the rendered page. The first letter is required to be capitalized , You can configure the issues/#I4IU2U
  • 1.4.0 And mongodb Dependency conflict , Initiate error reporting issues/#I4ITG0
  • javabean Data source optimization , The parsed field name is based on the passed field name issues/#I4HK1I
  • excel Contains custom formats , Upload failed issues/#I4HVDU
  • Building block report configuration report drilling cell value transfer and table value transfer issues/#658
  • Add hyperlink 【 Parameter setting 】 One of them is the of parameters that cannot be obtained .issues/#I4HX60
  • Display the total number of data when querying the toolbar issues/#672
  • When using the data source of the people's Congress gold warehouse, the back-end returns name It is lowercase, so the table cannot be generated issues/#I4JBLE
  • The search drop-down box displays at most 10 Data , Display the number of bars according to the configuration issues/#675
  • SQL Add your own limit The condition will report an error issues/#I4JFKQ
  • Charts and javaBean Data source binding error , Report an error problem to attach a solution issues/#I4I2X8
  • When using a non administrator account , Report drilling problem issues/#680
  • Set the cell to 【 Numbers 】 After the type , export Excel Report errors .issues/#I4JWH3
  • Drill jump carry tokenissues/#I4JM0I
  • Graphical report new SQL data source , Cannot show in report issues/#I4FNJC
The code download
Technical documentation

Why choose JimuReport?

Free forever , Support various complex reports , And goofy online design , Very intelligent , The age of low code , This is your first choice !
  • use SpringBoot The scaffolding project , Can be quickly integrated
  • Web Version Designer , Be similar to excel Operation style , Drag and drop to complete the report design
  • adopt SQL、API Methods such as , Bind the data source to the template . It also supports expressions , Automatic calculation of total and other functions , So that the calculation workload is greatly reduced
  • Development efficiency is very high , Fool online report design , Design a report in one minute , It's simple and powerful
  • Support ECharts, At present, we support 28 Species chart , Online drag and drop design , Support SQL and API Two data sources
  • Support grouping 、 cross , total 、 Expressions and other complex reports
  • Support print design ( Support template printing 、 Background printing, etc ) Print margins can be set 、 Direction 、 Header, footers, etc One click printing At the same time, invoice printing can be realized , Real estate certificate, etc 、 Seamless printing
  • The large screen designer supports dozens of chart styles , It can be spliced freely 、 Combine , Design Cool big screen
  • Various types of documents can be designed 、 screen , Such as warehouse in and warehouse out order 、 sales slip 、 Financial statements 、 contract 、 Monitor the big screen 、 Big screen of tourism data, etc
System screenshot
  • Report designer ( Professional first-class Data visualization , Solve all kinds of report problems )
  • Report designer ( Completely online design , Simple and easy to use )

  • Print design ( Support template printing 、 Background printing )

  • Data reports ( Support grouping 、 cross , Total and other complex reports )

  • Graphical reports ( At present, we support 28 Species chart )
  • Data report zebra crossing

Feature list
├─ Report designer
│ ├─ data source
│ │ ├─ Support multiple data sources , Such as Oracle,MySQL,SQLServer,PostgreSQL And other mainstream databases
│ │ ├─ Support SQL Write pages intelligently , You can see the list of tables and fields under the data source
│ │ ├─ Support parameters
│ │ ├─ Support single data source and most data source settings
│ │ ├─ Support Nosql data source Redis,MongoDB
│ │ ├─ Support stored procedures
│ ├─ Format cells
│ │ ├─ Frame
│ │ ├─ font size
│ │ ├─ The font color
│ │ ├─ Background color
│ │ ├─ Bold font
│ │ ├─ Support horizontal and vertical distributed alignment
│ │ ├─ Support text wrap settings
│ │ ├─ Picture set as picture background
│ │ ├─ Supports wireless rows and unlimited Columns
│ │ ├─ Supports freezing windows in the designer
│ │ ├─ Support the copy of cell content or format 、 Paste and delete functions
│ │ ├─ wait
│ ├─ Report elements
│ │ ├─ Text type : Write the text directly ; Support text of numeric type to set decimal places
│ │ ├─ Picture type : Supports uploading a chart ; Support image dynamic generation
│ │ ├─ Chart type
│ │ ├─ Function type
│ │ └─ Support for summation
│ │ └─ Average
│ │ └─ Maximum
│ │ └─ minimum value
│ ├─ background
│ │ ├─ Background color settings
│ │ ├─ Background image settings
│ │ ├─ Background transparency settings
│ │ ├─ Background size settings
│ ├─ The data dictionary
│ ├─ Report printing
│ │ ├─ Custom printing
│ │ └─ Medical paper 、 warrant of arrest 、 Introduction letter and other custom style design printing
│ │ ├─ Simple data printing
│ │ └─ Warehouse in and warehouse out order 、 Sales form printing
│ │ └─ Print with parameters
│ │ └─ Page printing
│ │ ├─ Overprint
│ │ └─ Real estate certificate printing
│ │ └─ Invoice printing
│ ├─ Data reports
│ │ ├─ Group data reports
│ │ └─ Horizontal data grouping
│ │ └─ Vertical data grouping
│ │ └─ Multi level loop header grouping
│ │ └─ Subtotal of horizontal grouping
│ │ └─ Vertical grouping subtotal
│ │ └─ Partition
│ │ └─ Columns
│ │ └─ Dynamically merge cells
│ │ └─ Number of custom pages
│ │ └─ total
│ │ ├─ Cross Report
│ │ ├─ A detailed list
│ │ ├─ Query report with conditions
│ │ ├─ Expression report
│ │ ├─ With QR code / Bar code reports
│ │ ├─ Multi header complex report
│ │ ├─ Master sub report
│ │ ├─ Alert report
│ │ ├─ Data drilling report
│ ├─ Graphical reports
│ │ ├─ Bar charts
│ │ ├─ Stacked Columns
│ │ ├─ Broken line diagram
│ │ ├─ The pie chart
│ │ ├─ Dynamic carousels
│ │ ├─ Column chart
│ │ ├─ Scatter plot
│ │ ├─ Funnel diagram
│ │ ├─ Radar map
│ │ ├─ Pictogram
│ │ ├─ Map
│ │ ├─ Instrument panel and watch
│ │ ├─ The diagram
│ │ ├─ Chart background
│ │ ├─ Chart dynamic refresh
│ │ ├─ Graph data dictionary
│ ├─ Parameters
│ │ ├─ Parameter configuration
│ │ ├─ Parameter management
│ ├─ Import and export
│ │ ├─ Support import Excel
│ │ ├─ Support export Excel、pdf; Support export excel、pdf With parameters
│ ├─ Print settings
│ │ ├─ Print area settings
│ │ ├─ Printer settings
│ │ ├─ preview
│ │ ├─ Print page number settings
├─ Big screen designer
│ ├─ system function
│ │ ├─ Static data source and dynamic data source settings
│ │ ├─ Basic function
│ │ └─ Supports drag and drop design
│ │ └─ Support for growth 、 Delete 、 Change 、 Check the big screen
│ │ └─ Support copying large screen data and styles
│ │ └─ Support large screen preview 、 Share
│ │ └─ Support the system to save data automatically , It also supports manual data recovery
│ │ └─ Support setting the password of large screen
│ │ └─ Support the deletion of component layers 、 Combine 、 Move upward 、 Move down 、 Roof placement 、 And so on
│ │ ├─ Background setting
│ │ └─ The width and height settings of the large screen
│ │ └─ Big screen profile settings
│ │ └─ The background color 、 Background image settings
│ │ └─ Cover map settings
│ │ └─ Zoom settings
│ │ └─ Environment address settings
│ │ └─ Watermark settings
│ │ ├─ Map settings
│ │ └─ Add map
│ │ └─ Map data isolation
│ ├─ Chart
│ │ ├─ Bar charts
│ │ ├─ Broken line diagram
│ │ ├─ Column chart
│ │ ├─ The pie chart
│ │ ├─ Pictogram
│ │ ├─ Radar map
│ │ ├─ Scatter plot
│ │ ├─ Funnel diagram
│ │ ├─ The text box
│ │ ├─ Running lights
│ │ ├─ Hyperlinks
│ │ ├─ Real time
│ │ ├─ Map
│ │ ├─ National logistics map
│ │ ├─ Geographic Maps
│ │ ├─ City dispatch map
│ │ ├─ picture
│ │ ├─ Picture box
│ │ ├─ Shuffling figure
│ │ ├─ Sliding components
│ │ ├─iframe
│ │ ├─video
│ │ ├─ Flop
│ │ ├─ Ring chart
│ │ ├─ Progress bar
│ │ ├─ Instrument panel and watch
│ │ ├─ Words float in the clouds
│ │ ├─ form
│ │ ├─ tab
│ │ ├─ Universal components
└─ Other modules
└─ More functions are being developed ..

thank
Similar articles

2022-01-15

2022-01-15