A method and system for dynamically generating data reports
A data report and dynamic generation technology, applied in the field of data management, can solve the problem of high secondary development and maintenance costs, and achieve the effect of reducing the work of report failure and reconfiguration, and reducing development difficulty and maintenance costs.
Active Publication Date: 2019-02-01
新长城科技有限公司
View PDF5 Cites 1 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] The technical problem to be solved by the present invention is to provide a pre-installed information management system in order to overcome the secondary development and maintenance costs caused by the newly added customized data report function in the existing information management system. In the source code, the retrieval statistics of data reports and the dynamic generation method of the structured query language SQL realize the development and maintenance of the existing information management system without secondary upgrades, and can also add new data report functions
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0036] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.
[0037] Such as figure 1 As shown, it is a schematic flowchart of a method for dynamically generating a data report provided by an embodiment of the present invention, and the method includes the following steps:
[0038] S101. Obtain the configuration conditions required for generating data reports. The configuration conditions include: the source of the data to be retrieved, the limited conditions for data retrieval, the statistical method of the retrieved data, etc. The configuration conditions can be provided by the dynamic generation system on the front-end graphical Web operation interface. choose;
[0039] S102, serialize the configuration conditions according to the ECMA-404 standard specification, and conve...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention relates to a data report dynamic generation method and system. The method comprises the following steps of obtaining a configuration condition required for generating a data report; serializing the configuration condition and converting the configuration condition to be in a JSON format; obtaining and analyzing the serialized configuration condition to obtain multiple sets of configuration data; processing the multiple sets of configuration data; storing the multiple sets of processed configuration data in a database; obtaining a serial number of each group of configuration data, calling a storage process program pre-stored in the database through the serial numbers, and reading the processed configuration data according to the serial numbers through the storage process program; and dynamically generating a retrieval statistics structured query language (SQL) according to the processed configuration data. According to the data report dynamic generation method and system provided by the invention, the personalized data report can be conveniently customized, so that the development difficulty and maintenance cost of the data report are lowered.
Description
technical field [0001] The invention relates to the field of data management, in particular to a method and system for dynamically generating data reports. Background technique [0002] At present, in the development of information management systems, it is often encountered that various customized data reports are generated. The existing processing methods are usually: pre-coded and embedded in the program source file, and the technician manually configures the database Or configuration files to obtain personalized data reports; or, through secondary upgrades, development and maintenance of existing information systems, new data report functions are added. [0003] In the current information management system, since the database table field structure of the relational database is relatively fixed, it cannot be changed arbitrarily during the system operation stage. As a result, if a new statistical report is added, in order to change the database table structure, it may be n...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/24G06F16/22
CPCG06F16/2282G06F40/18
Inventor 魏亚红徐建堂徐怡田静蔡报丰李伟
Owner 新长城科技有限公司