Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to use FineReport, a tool that can replace Excel, and the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

In daily work, when it comes to tables, calculations, charts and analysis of data, Excel must be the first choice.

But I also see that many bosom friends are confused about the difficulty of in-depth study of Excel and the efficiency of big data's handling.

For example, a colleague crashes nearly 10,000 pieces of data in order to deal with seven or eight dimensions; some people frequently collapse the computer with hundreds of thousands of rows of data; moreover, with the intersection of multitasking lines, the summary task increases exponentially.

This is not to say that Excel can not accomplish this kind of task, if it is daily tabular records, data calculation, Excel really can not be replaced. But if we say to do business reports of enterprise management, huge and complex data analysis, financial analysis, budget preparation, Excel is not very good at it, because its data is not unified, there is no independent calculation engine, data exists independently in each Excel file, data consolidation is very troublesome.

For example, my wife recently joined a new company as a store data specialist for a brand. Although he used to be in this industry, he is not good at making data reports.

The colleague in charge of the handover is an old employee who joined the company for more than 3 years after graduation. he has been working on the report form. In order to be more accurate, I asked my wife to use screencap software to record what he had to do every day.

It turns out that this guy has been asking the Ministry of Information for data since morning, and then using excel to copy, paste, sum, vlookup, copy, paste, sum, calculate percentage, vlookup, delete, adjust. A few hours later, the first report was born.

After watching the video, I was devastated, which was too unnatural. Well, this guy is really good, the operation speed is absolutely first-class, at least there is a diamond V in the LOL.

But I don't want my wife to do this every day, and for me as a computer major, as long as I have a database, these repetitive tasks can be solved by minute-by-minute code / tools.

Considering that there will be a lot of demand changes, it is completely impossible for my wife to change the code, so I look for a ready-made reporting tool. After comparing SPSS, SAS, cognos, Crystal, foxtable and finereport, the report software finereport is determined. From the mysql table, data import, the production of daily, weekly, monthly reports, various comparative reports began to break one by one, and finally in the hand speed of not lower than the golden level of my efforts for a week, all completed, after proofreading with the young man's manual meter, confirmed that there is no problem, installed and deployed to my wife's office computer.

A few days later, the young man left his job. From then on, his wife only needs to collect data from the person in charge of a store in the morning, then take a few minutes to import the database, then click the mouse to generate various reports, and then. Save it first, drink water, eat snacks, fruit, rest, surf the Internet.

Therefore, in terms of efficiency, professional reporting tools can replace a lot of repetitive excel processing work, such as FineReport. After the information department is deployed and installed, it can connect the data of various business systems and develop routine business reports, as well as weekly and monthly reports, into templates that can automatically extract data and display them.

Because this tool is mostly used by the Ministry of Information to develop reports, many people may not know much about it! I try to talk about this reporting tool from a technical point of view in a concise and easy-to-understand language, why it can save time and manpower in operation, and have amazing visualization that can replace PivotTable.

First, use FineReport to make a template, which can replace N pieces of manual repeated work Excel!

Why would you say that? Let's first understand the watchmaking principle of FineReport.

1. The tabulation principle of FineReport.

To make a report, you must first have data. Where does the data come from? One is the data directly connected to the business system or database, and the data can be imported into the excel file. After the data is connected, the template is made, which is similar to the excel table. The design shows the style, the calculation formula, and finally displays it on the web.

But it is not used with excel. Excel processes data one by one. When making a template, finereport handles data fields. One data field is placed in each cell in the template, and the field is expanded when it is displayed on the web. The expansion of cells in FineReport reports has a direction, which can be expanded vertically, horizontally or unextended.

2, three types of report design, to solve all daily report requirements, and a table reuse.

1) ordinary template design, which is the most commonly used. Relying on the relationship between the expansion of the cell and the parent-child cell to achieve the template effect, you can query parameters, fill in reports, chart design and so on. Such as cross reports, row reports, group reports and so on.

2) aggregate report design, aiming at irregular large report. It is suitable for complex reports that display multiple independent modules in a template and several report blocks are summarized together.

Here are some examples of common report formats:

Crosstab

Grouping report

3. Parameters to realize data query and filtering

How to query the report? In FineReport, by setting parameters to bind data fields and filter controls (check boxes, check boxes, etc.), enter query conditions through the interface to control the content and form of the report display, and then export and print.

Many people do weekly reports, monthly reports and quarterly reports at work, and some national companies have branches, stores and offices. It is often necessary to make these repetitive reports. Then you can use FineReport to upload each piece of data to the database (fill in the function, which will be discussed below). When making a report, do some commonly used dimensions "region", "time", "city" and so on as a query parameter control, similar to the filter in Excel, export. Basically, a weekly report template solves the workload of some people with 52 manual excel reports a year.

4. Fill in the report

Data acquisition is a very important step. Filling in is to enter data into the database to collect data, just like the mailbox, collection, user name and password you submitted when you registered the website, which will be stored in the database in accordance with the format.

A template is also required to fill in the report. The operation procedure is as follows:

The biggest use of filling in the report is to replace excel to collect data, to make a template, and to send a link to the award template to relevant people, which can be stored in the database after filling in the data, so that it can be passed around by excel and filled in on the web, which is very convenient.

Second, not only reports, but also data visualization

Cool dashboard needs to be designed and displayed through FineReport forms (decision reports). The interface is designed preliminarily by dragging and dropping report blocks, chart blocks and various controls.

Different from the ordinary report, the ordinary report is a whole and can not be refreshed locally. The form is composed of various components, which can be refreshed within the component, that is, local refresh. For example, dynamic large screens are refreshed globally or locally, so they need to be made and implemented with decision reports.

GIS map is based on GIS map layer for data display, supports custom GIS theme style, and can be linked with data table drilling. For example, provincial drilling to the city level, county level, streets.

When it comes to efficiency, the biggest advantage is that the data are read out from the database to automatically generate reports, and a class of reports are made into a fixed style template, as long as synchronized each time, automatically produce periodic reports, such as daily, weekly, monthly, quarterly and so on. Each time according to the conditions of the query, Excel batch export / print, less manpower to a statistical summary with Excel.

And in operation, most of the functions FineReport are packaged into modules, including writing SQL fetch, summary filtering, filtering and so on, basically have corresponding function keys. Like the famous balance sheet, if you write code or complex SQL statements in the past, it will be a bit life-destroying, and if there is something wrong with the SQL statement, who will check it? if the data comes from multiple sources, it will be completely impossible to extricate itself.

Secondly, in terms of data processing speed, because the performance depends partly on the database and partly on the row report engine of FineReport, hundreds of thousands of rows of data are produced in seconds compared with the stand-alone efficiency of Excel. In addition, the enterprise database has a variety of built-in or third-party cluster solutions, through the heap machine can be approximately unlimited increase in data storage capacity.

About can replace the Excel tool FineReport how to share here, hope that the above content can have some help to everyone, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.