Centralized broad spectrum report generation method based on expandable sign language

Abstract

This invention discloses a kind of centralized broad-spectrum report generating method that based on Extensible Markup Language. It aims to provide a kind of centralized and effectively report generating method. The method comprises the following steps: 1) reading the extensible mark language configuration file of report; 2) analyzing the required format information of report making; 3) calling database; 4) drawing the database information that will be connected; 5) connecting with database and getting the data result collection; 6) creating the EXCEL COM object sample by using the COM component object modeling technique; 7) writing the result collection to EXCEL according to the report format that appointed in extensible mark language and generating report; 8) releasing the COM object sample that created in step 6); 9) releasing the database connection created in step 5). If the executable file or dynamic linkage library are needed to generate report, they can be embedded seamlessly in the system as a plug-in together with extensible mark language file.

Description

technical field [0001] The invention relates to a report generation method, in particular to a centralized broad-spectrum report generation method based on XML-based extensible markup language. Background technique [0002] The report provides the data that the user cares about and some analysis results for the data in the form of a table. Compared with other forms of data provision, it has the characteristics of simplicity, intuition and specification, and is widely used in the field of telecommunications. Equipment manufacturers provide operators with various report formats, and report output points are scattered. In order to create a report, users need to operate in multiple places, especially when users are not familiar with the system they are using, they will feel at a loss. In addition, the current report generation types are limited to the scope provided by the equipment manufacturer. If the operator has new requirements, he can only wait for the equipment manufactur...

AI Technical Summary

Problems solved by technology

[0002] Reports provide the data that users care about and some analysis results for these data in the form of tables. Compared with other forms of data provided, they are concise, intuitive and standardized, and are widely used in the field of telecommunications. However, at present Equipment manufacturers provide operators with a variety of report formats, and the report output points are scattered. In order to make a report, users need to operate in multiple places, especially when users are not familiar with the system they are using, they will feel at a loss.

In addition, the current types of report production are limited to the scope provided by equipment manufacturers. If operators have new needs, they can only wait for equipment manufacturers to upgrade the version. There is no other way

Images