Jimureport
免费的AI可视化报表。一句话描述需求，AI 自动生成报表与数据大屏；同时提供类 Excel 拖拽设计器，兼容 30 余种数据源，轻松应对各类复杂报表场景——帆软、Tableau 的高性价比开源替代。
Last verified:
What is Jimureport?
JimuReport (积木报表) is a free, open-source enterprise-level AI report and large-screen dashboard platform. It allows users to generate AI reports and AI dashboards with just one sentence, featuring Excel-like drag-and-drop design and supporting 30+ data sources out of the box.
Key features include Chat2BI conversational data analysis, data reports, print design, chart reports, portal design, and large-screen/dashboard design. The web-based report designer offers Excel-like operation style with drag-and-drop functionality for what-you-see-is-what-you-get design. The large-screen designer uses a Word-like style allowing free component dragging to create stunning visual dashboards like those from Baidu and Alibaba.
JimuReport is designed for enterprises, developers, and data analysts who need to create complex reports, data visualizations, and dashboards without extensive coding. It supports grouping, cross-tabulation, subtotals, expressions, 28+ chart types including bar, line, pie, scatter, funnel, radar, maps, gauges, and more. The tool integrates easily via SpringBoot framework and supports mobile charts and data filing.
The platform supports 30+ database sources including MySQL, Oracle, SQL Server, PostgreSQL, DB2, MariaDB, SQLite, Hive, HBase, MongoDB, Elasticsearch, TiDB, Doris, ClickHouse, and various domestic Chinese databases. It includes print design supporting nail printing, background printing, invoice printing, and real estate certificate printing with precise alignment.
Jimureport pricing
Pricing model: Freemium
JimuReport offers a permanently free tier with all core features available. The free version includes full access to report designer, dashboard designer, large-screen designer, print design, 28+ chart types, 30+ data source support, and mobile support. A commercial/business version is also available at a low cost (described as 'very cheap' compared to competitors like FineReport which costs tens of thousands). The free tier allows commercial usage. License: features free, can be used commercially, but source code is not fully open.
Jimureport pros
- Permanently free with commercial version available at low cost
- Open source with commercial usage allowed
- Excel-like drag-and-drop web designer
- One-sentence AI report and AI dashboard generation
- Chat2BI conversational data analysis
- 30+ data sources out of the box
- 28+ chart types supported via ECharts
- Supports complex reports: grouping, cross-tabulation, subtotals
- Print design with nail printing and invoice printing support
- Mobile chart and dashboard support
- SpringBoot framework for quick integration
- Automatic calculation of subtotals via expressions
- SQL and API data source support
- Export to Excel and PDF with parameters
- Dashboard layer management: combine, move up/down, pin top/bottom
- Watermark support for dashboards
- Auto-save and manual data recovery
- 二维码/barcode report support
- Fool-proof online design, low-code approach
Jimureport cons
- Source code not fully open (code closed despite feature free)
- Chinese interface primarily, limited English support
- Some advanced features still in development
- Security vulnerability CVE-2025-66913 in versions through 2.1.3
- Less brand recognition compared to FineReport
- Fewer template cases and examples available
- Community support mainly via QQ groups
- Documentation primarily in Chinese
- H2 database JDBC URL validation issues in older versions
Frequently asked questions about Jimureport
What is JimuReport?
JimuReport (积木报表) is a free, open-source enterprise-level AI report and large-screen dashboard platform. It supports one-sentence AI report and AI dashboard generation, Excel-like drag-and-drop design, and 30+ data sources out of the box. Features include Chat2BI conversational data analysis, data reports, print design, chart reports, portal design, and large-screen design.
Is JimuReport free to use?
Yes, JimuReport is permanently free with all core features available. It can be used commercially. A commercial/business version is also available at a low cost for those who want additional support or features. The license states features are free, commercial usage is allowed, but full source code is not open.
What data sources does JimuReport support?
JimuReport supports 30+ data sources including MySQL, Oracle, SQL Server, PostgreSQL, DB2, MariaDB, SQLite, Hive, HBase, CouchBase, TiDB, Doris, ClickHouse, MongoDB, Elasticsearch, Redis, and various domestic Chinese databases like Dameng,人大金仓, 神通, Huawei Gauss, and others. It also supports SQL, API, JSON, and WebSocket datasets.
How do I design reports in JimuReport?
JimuReport uses a web-based report designer with Excel-like operation style. You drag and drop components to complete report design with what-you-see-is-what-you-get. The process is described as 'fool-proof' online design. You can bind data sources via SQL or API, use expressions for automatic calculations, and design completely online like building blocks.
What chart types are supported?
JimuReport supports 28+ chart types via ECharts including bar charts, line charts, pie charts, line-column charts, scatter plots, funnel charts, radar charts, pictogram charts, maps, gauges, relationship charts, ring charts, progress bars, word clouds, and more. The dashboard designer supports dozens of chart styles that can be freely combined.
Can I print reports with JimuReport?
Yes, JimuReport includes print design functionality supporting nail printing (套打), background printing, invoice printing, real estate certificate printing, entry/exit warehouse slips, sales forms, and more. You can set print margins, direction, headers/footers, and achieve precise seamless printing for invoices and certificates.
Does JimuReport support mobile devices?
Yes, JimuReport supports mobile charts and mobile dashboard design. Starting from version v1.9+, the JimuBI product supports dashboards, large screens, portals (with interaction), and mobile devices.
How does JimuReport compare to FineReport?
JimuReport is free and open-source while FineReport costs tens of thousands of yuan. JimuReport supports source download, Maven integration, and Windows/Docker no-install versions, while FineReport is offline-only. JimuReport releases 1-2 versions monthly with weekly issue fixes, while FineReport releases infrequently. JimuReport has better UI/UX and more data sources including SQL, API, JSON, WebSocket vs FineReport's SQL and JDBC only.
How do I register and start using JimuReport?
You can register online at the official website http://www.jimureport.com using a mobile phone number for one-click registration. After registration, you can permanently use the tool for free to create reports and dashboards online.
What is the latest version of JimuReport?
As of the documentation, JimuReport has iterated to version 1.9.1. Version v1.7.0+ introduced a paid commercial version while continuing to release a free version. Version v1.9+ introduced the JimuBI product supporting dashboards, large screens, portals with interaction, and mobile.