Excel-like report processing method

Abstract

The invention provides an excel-like report processing method. The method comprises the following steps of: generating a user report template which at least comprises report type information, report data area setting information, base value setting information, report format setting information and formula setting information; compressing the generated user report template and storing the compressed report template in a structured query language (SQL) database server; selecting the report type needed to be filled by a user and obtaining a corresponding user report template from the SQL database sever; decompressing the obtained user report template and generating report basic data; loading the user report template and monthly reported basic data to a client for the user to fill the report; and generating report data by using the user report filled by the user and storing the report data in the SQL database server.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to an Excel-like report processing method. Background technique [0002] As the level of user needs continues to deepen, users have higher and higher requirements for reports. They no longer only meet related needs such as report statistics, but need more control over the report interface and data display. Users need Ability to customize the report and customize the report you need in your own way. In order for users to customize the report, it is very important to actually conform to the user's usage habits. The Excel-like operation method just meets the habits of most users, and this operation method is exactly what you can do without training. A way of direct acceptance. Custom functions have become a new trend of report products. Compared with simply allowing users to modify the display form of reports in the past, users' requirements for customization have been impro...

AI Technical Summary

Problems solved by technology

[0007] Disadvantages: There are certain limitations in the production of complex reports. Generally, only regular and simple-format reports can be displayed, and it is difficult to handle fill-in reports.

[0011] Disadvantages: There is basically no or very simple data interface with the database, and the integration with the database is not very close. The statistical data in the report needs to be implemented by the program code and then filled in the form

[0014] 2. There are extremely complex formula references between each worksheet

[0015] 3. The report format is complex

[0016] Therefore, these features will cause obstacles to the use of users. For example, formula calculations are generally hard-coded in the program, and at most only simple configuration can be realized with SQL statements. Once the user's business changes, the report format changes, indicators change or the formula changes. , it is difficult for users to change, resulting in the system being unusable, and only developers are asked to modify

In addition, there are more than 200 formulas in the entire workbook. After the business changes, it is very likely that all the calculation formulas need to be recoded, and sometimes it is difficult for developers to maintain

Images