Method for creating report, system, storage medium and electronic equipment

Abstract

The invention provides a method for creating reports, a system, a storage medium and electronic equipment. The method for creating the report comprises the following steps: acquiring basic informationof a report to be created, wherein the basic information comprises SQL (Structured Query Language) querying sentences; according to the SQL querying sentences, extracting data of one or more table fields from a pre-stored data set; acquiring attribute information of one or more table fields, and configuring the attribute of one or more table fields according to the attribute information, therebycreating the report. By adopting the method, data sources of multiple business platforms can be integrated to rapidly create reports expected by users, tedious operation that data need to be input oneby one in a conventional report creating method can be avoided, in addition, the users can conveniently check, extract and analyze report data at any time.

Description

technical field [0001] The invention relates to the field of computer software, in particular to a method, system, storage medium and electronic equipment for creating reports. Background technique [0002] There are a large number of data requirements such as list extraction, data verification, temporary reports, and manual statistics in the enterprise. Enterprise IT resources consume a lot of resources in this area and rely too much on the individual capabilities of personnel. In the case of using outsourced personnel, the partial relief This kind of data demand, but it cannot fundamentally solve this problem, has brought a lot of burden to the enterprise. [0003] At present, most of the enterprise data comes from different business systems, and it is difficult to integrate the various business systems. In order to obtain relevant reports in real time, business personnel need to frequently log in to different business systems, which inevitably leads to data inconsistency ...

AI Technical Summary

Problems solved by technology

[0002] There are a large number of data requirements such as list extraction, data verification, temporary reports, and manual statistics in the enterprise. Enterprise IT resources consume a lot of resources in this area and rely too much on the individual capabilities of personnel. In the case of using outsourced personnel, the partial relief This kind of data demand, but it cannot fundamentally solve this problem, has brought a great burden to the enterprise

[0003] At present, most of the enterprise data comes from different business systems, and it is difficult to integrate the various business systems. In order to obtain relevant reports in real time, business personnel need to frequently log in to different business systems, which inevitably leads to problems such as data inconsistency.

Images