“Old K, the company is about to make a mid-year resume, the boss wants to see the business data of the first half of the year, you hurriedly pull through the data with the business these two days, after two days I will see the data report?”

“Don’t we have SAP in our company, and let business people take numbers from the system themselves?”

“They don’t understand that. They just use Excel to do data on any system.”

Whenever the company carried out data review, Mr. K began to have a headache. He had done a good job in IT system, but he often had to communicate with business staff because of data problems, and sometimes communication was routine all day long.

IT’s also a place where many IT people in pain, most of the domestic company’s core data are concentrated in the hands of IT, for example, data stored in enterprise database system, but there are a lot of business data scattered in various business of the company system, business people usually want to pull data for a report, will find IT people to find the data in each system.

The pull data is just the beginning of the headache, the most frustrating thing for IT people is that even if the data has been pulled out for business people, once the business needs change or the data caliber is wrong, IT people have to re-take the number – re-make the template – re-argue with the business, do not mention much effort.

At the beginning, Mr. K also wanted to teach business personnel how to use SQL to fetch numbers directly from the database, and held several internal training sessions. However, IT proved that the learning cost was too high. As a result, simple report requirements were still handed over to IT, but the requirements were more stringent.

Finally, Mr. K found a way to realize the automation of report development by using the report platform. As long as the IT department puts the data below, the business can take the number from the platform to make reports. Finally, IT proved that using the report platform greatly reduced the energy of IT personnel.

In order to ensure that the learning threshold is not high, Mr. K deliberately chose FineReport, which has the highest cost performance in the market. The Excel like design allows business personnel to learn it quickly and completely solves the company’s report problems. (Tools are given at the end of the article)

How does that work? Here’s something dry:

1. Data architecture

FineReport is pure Java software with good cross-platform compatibility. The data architecture is divided into three layers: data layer, application layer and presentation layer:

• Data layer: Designers create report data sources.
• Application layer: designers design reports, and administrators configure users and permission systems.
• Display layer: Ordinary users can query, analyze, print, export, and fill reports in the front end. It supports PC, tablet, mobile terminal, large-screen and other devices and is compatible with mainstream browsers.

From the perspective of product architecture, FineReport report system is mainly composed of report designer and report server. All report design work is completed in the designer, and finally displayed to users through server parsing.

1) FineReport designer can design various elements in report design documents such as table samples, data, display and print, and is an integrated platform for report design and report application development, debugging and deployment.

2) FineReport is a servlet application, and reports produced must be deployed on the server side. Through the report server’s analysis of reports, users can interact with the report server through terminals (such as browsers) to view reports.

2. Complex reporting solutions

FineReport provides three report design modes for complex reports common to companies, such as line reports, weekly reports, and monthly reports.

General template design:

FineReport is the most commonly used and most used design mode. It relies on the relationship between the expansion of cells and parent cells to achieve the template effect, and can be used for parameter query, report filling, chart design and so on.

Aggregate report Design:

This method is applicable to reports that display multiple independent modules in a template

Decision report Design:

It is generally applicable to the display of controls, which makes up for the problem that the control can not be displayed in the paging preview of ordinary reports. At the same time, the decision-making reports can be designed with free drag and drop, and the page size can be displayed automatically

3, low code, zero cost

Low code is a hot word now, but also the inevitable trend of software development in the future. For us IT people, FineReport, a low-code tool, is very friendly, and the visual SQL interface is modular, so we can call IT directly.

For business people, the report design interface is more simple and clear, there is no need to write code, with the mouse drag several indicators, click a few charts can quickly produce a high quality report, which also benefits from the visual module encapsulation in FineReport.

Finally, the tools were sent

Finally share the tool to everyone, back to a “report” can get the tool!