Custom dynamic report system and implementation method thereof

Abstract

The invention relates to a custom dynamic report system and an implementation method thereof. A custom dynamic report consists of a data layer, a service layer, a definition layer and a display layer; and the implementation method of the custom dynamic report comprises the following steps of: defining a report type according to a requirement of a report; defining an extensible markup language (XML) configuration file according to the report type; revolving the XML configuration file through the service layer so as to obtain configuration file information, meanwhile, uploading the display layer, namely an EXCEL template file, into a system memory so as to form a general report; acquiring original data from the data layer according to the configuration file information and manufacturing the original data into report data; combining the report data and the display layer, namely the EXCEL template file and generating a report in the system memory; and processing the generated report according to the configuration file so as to obtain the report. By the method, the execution and maintenance costs of the report system can be reduced greatly; due to simple configuration, the variable report requirement can be met; moreover, the report system is easy to manufacture and flexible in use; the data layer, the service layer, the definition layer and the display layer can be separated from one another; and the report system has ultrahigh flexibility, usability and practicability.

Description

[0001] technical field [0002] The invention relates to a report processing and generating method, in particular to a self-defined dynamic report system based on XML and EXCEL and its realization method. Background technique [0003] The report is mainly used to display some comprehensive data, which was previously completed by manual filling, which is not only inefficient, labor-intensive, but also has a high error rate. With the development of computer technology, in the current practical application, some enterprises purchase special report software to complete the report filling, and some enterprises use hard-coded drawing in computer programming language. These methods have one or another deficiency in terms of implementation cost, maintenance cost, and flexibility. Especially when user report requirements change, it is often necessary to wait for the developer to modify the report, or even to redevelop a new program before it can be realized. It cannot meet the real-...

AI Technical Summary

Problems solved by technology

These methods have one or another deficiency in terms of implementation cost, maintenance cost, and flexibility. Especially when user report requirements change, it is often necessary to wait for the developer to modify the report, or even to redevelop a new program before it can be realized. It cannot meet the real-time requirements that the reports need to change frequently. Even if it is barely met, it will make the development and maintenance personnel exhausted and increase the cost of implementation and post-maintenance

As for the existing report processing technology that uses EXCEL as the medium, in addition to the lack of flexibility and configurability, it can only be realized on Windows systems, but it is powerless on systems such as Linux or Unix.

Images