“We want to use a reporting tool, do you have any recommendations?” This is the question that xiaobian has been asked most in the past two years. As long as any company with a certain size wants to use reporting tools.
That report tool how to choose in the end, from which dimensions? Based on my years of working experience, here are a few points that I think are important:
- 1. Target group: Is this reporting tool aimed at senior corporate leaders or technical staff in THE IT department?
- 2. Technology: Does the reporting tool data source meet your requirements? Which operating systems does the reporting tool support, Windows, Mac or Linux? What are the operating hardware requirements? Can reporting tools be redeveloped?
- 3. Learning community: Is using documentation, learning videos, and tutorials comprehensive? Is there a learning community or exchange group for consultation? Is there a professional who can help with problems? .
Next, I would like to introduce what are the mainstream reporting tools in China:
1. Block report Jimureport:
Jimureport is a report tool under Jeecgboot open source community. It can design reports and large screen for free online, and can also be installed offline. Just a few months online, by a large number of developers love.
Let’s take a look at the building block reports that can be designed:
(1) Perfect realization of set play
(2) No matter how complex the report can be achieved
(3) Cool big screen of charts, easy to handle
Let’s take a look at the advantages of building block reports:
(1) Report design: Excel design interface, greatly reducing the cost of learning. Support a variety of function expressions, data dictionary, etc., users can design arbitrary complex table sample (such as: cross report, group report, master and sub report, drill, etc.), easy to achieve Chinese type complex report.
(2) Data processing: support multiple data sources, including Oracle, SqlServer, MySql, etc.; Data sets support both SQL and API methods, and designers can flexibly choose appropriate methods according to specific requirements. SQL statements are also more flexible, whether you are a single table query, or multiple tables; Whether it’s where conditions or Order Derby, we support them all!
(3) Large screen display: The large screen designer using building block reports can realize the dynamic display of data by dragging components and configuring data, and can display the data adaptively on screens of various sizes and types.
(4) Services: There are detailed usage documents and installation documents on the official website of building blocks report, as well as a large number of video tutorials to help developers better use reports; Building block report is also equipped with exchange group and question community, not only there are professional staff to answer your questions, but also exchange development and use experience here. Building blocks report team also constantly collect everyone’s opinions, do meet the needs of the public, unique report products. Most important: everything here is free!
Free use address:www.jimureport.com/
2. Finereport report tool
Fan soft is a domestic statements relatively early a company, the function is relatively comprehensive, but the interface is relatively old.
Let’s take a look at some of the problems Finereport solves:
- The changing market environment and business requirements cannot quickly meet the changing reporting requirements
- The traditional SQL+Excel way to integrate data to make reports, low efficiency and poor accuracy
- Service system data is too scattered to form data islands, which are difficult to use effectively
- Lack of unified report tool management portal, unable to form a global data vision, assist decision-making
Consider Finereport’s advantages:
(1) Simple report design: Excel like design mode greatly reduces the cost of learning. If you can use Excel, you will basically use FineReport. Support multi-sheet and cross-sheet calculation, perfectly compatible with EXCEL formula, users can design arbitrary complex table sample as what they see is what they get, easily realize Chinese complex report form.
(2) Data source processing: Sql visual statement editing, report tool developers do not need to write Sql line by line, only need through simple drag and drop, you can generate Sql statement zero code development, especially data dictionary, actual value and display value design is cut into the key of rapid development, These functions in other languages and systems often require a lot of code to achieve and are frequently needed in Finereport, but only a few operations in the data filling function, to avoid the chaos of Excel data collection, can also develop a variety of flow forms to support a variety of database data sources: Including Oracle, SqlServer, MySql, DB2, Sybase, Informix and other mainstream relational databases; Supports SQL fetching tables or views, as well as stored procedures.
(3) Service: Fansoft has the best community forum in the domestic data industry, 99% of the problems can be found in the help document solutions, industry cases and product teaching videos are essential; At the same time technical support team, telephone hotline, marketing QQ ready to call. Enjoy good service at the same time, you need to pay corresponding fees, just the so-called wool out of the sheep.