Method and device for generating management system report

Abstract

The invention discloses a method and a device for generating a management system report. The method comprises the following steps: (1) according to a function module of a system, determining the marksof the report type and the report data item of the module; (2) defining an interface for acquiring report data, and using the data interface to define an expression mode of parameter information necessary for acquiring data and a storage mode of data results, wherein the return value of the interface is expressed by a key value-pair-set way; (3) creating a report template; (4) creating a data acquisition interface; (5) opening the report template, reading the data item information of the report template, calling the data acquisition interface for acquiring data, and writing the data into theassigned position of the report template; and (6) generating the report filled with the report data to the assigned path, and finishing the generation of the report. The device comprises a report datamanager, an Excel engine, a report template mark analyzer and a report data accessor.

Description

technical field [0001] The invention relates to a report generation method and device, in particular to a management system report generation method and device. Background technique [0002] The report system is used to create report templates, support the function realization of reports, and generate reports. Usually, the report system needs to provide a WYSIWYG report template creation function, so as to make the report template creation fast and efficient. The following is a brief introduction to the basic concepts involved in the reporting system: [0003] Template element: the basic element that constitutes a report template; when creating a report template, the value of the template element is usually represented by some variable expressions, and when generating the report, determine the specific value of the corresponding variable according to the collected data, and determine The value of the variable expression, and then fill the position of the template element w...

AI Technical Summary

Problems solved by technology

[0016] However, in actual use, the above method still has some defects, and it is complicated to use

In view of this, the inventors in this field have developed an Excel-based automatic report generation device and method, which are used to reduce the increase in the complexity of report maintenance due to changes in report format or content, and reduce the workload of report maintainers.

Images