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

A report and table technology, applied in the field of report creation, can solve the problems of relying on individual personnel's ability, consuming a lot of resources, and inconsistent data, so as to achieve the effect of convenient viewing at any time and avoiding cumbersome operations

Inactive Publication Date: 2018-09-25
吉贝克信息技术(北京)有限公司
16 Cites 8 Cited by

AI-Extracted 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 ...
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 more

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.

Application Domain

Technology Topic

Image

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

Examples

  • Experimental program(1)

Example Embodiment

[0025] The following describes the implementation of the present invention through specific specific examples, and those skilled in the art can easily understand other advantages and effects of the present invention from the content disclosed in this specification. The present invention can also be implemented or applied through other different specific embodiments, and various details in this specification can also be modified or changed based on different viewpoints and applications without departing from the spirit of the present invention. It should be noted that the following embodiments and the features in the embodiments can be combined with each other if there is no conflict.
[0026] It should be noted that the illustrations provided in the following embodiments only illustrate the basic idea of ​​the present invention in a schematic way. The figures only show the components related to the present invention instead of the number, shape and actual implementation of the components. For size drawing, the type, quantity, and proportion of each component can be changed at will during actual implementation, and the component layout type may also be more complicated.
[0027] See figure 1 , The embodiment of the present invention provides a method for creating a report, which breaks the traditional heavy workload of creating a report that requires data entry one by one, greatly improves the efficiency and accuracy of report creation, and can be convenient for users after creation Personnel viewing, extraction and analysis. The method for creating a report in this embodiment mainly includes the following steps:
[0028] S11: Collect basic information of the report to be built.
[0029] reference figure 2 , Displayed as a human-computer interaction interface diagram for collecting the basic information of the report to be built. The basic information collected in the new report includes: report name, report abbreviation, version number, maximum statistical interval, report code, attribution department, report method, control data authority items, etc. In particular, the basic information collected in the new report needs to include SQL query statements, that is, the user needs to manually figure 2 Type the SQL query statement in the "Query SQL" text box shown. The typed SQL query statement usually defines the scope of the data query and the object of the data query. Optionally, in another embodiment, the basic information collected in the newly created report also includes script statements to limit the scope of the query, that is, the user is required to manually figure 2 Type the script statement in the "Script" text box shown. The typed script statement usually limits the query range of the SQL query statement in the pre-stored data set.
[0030] S12: Extract data of one or more table fields from the pre-stored data set according to the SQL query statement.
[0031] It should be noted that this embodiment integrates several data reports of multiple business platforms in advance to create a data set, and the name, field name, and data value of each data report are all recorded in the data set. The purpose of the SQL query statement is to extract the target data from the data set. For example: through figure 2 As shown in the SQL query statement, this step will find the "T_SYS_USER" report from the data set, and extract the five fields of "username", "usernum", "email", "c_agency_nme", and "c_branch_nme" from the report. related data. Another example: in figure 2 Under the limitation of the queryable range of the script statement shown, this step will find the "T_SYS_USER" report from the queryable range based on the SQL query statement, and extract "username", "usernum", "email", and "email" from the report. Data related to the five fields of "c_agency_nme" and "c_branch_nme".
[0032] Optionally, in another embodiment, the correctness of the SQL query statement is checked before performing this step. When the user enters the correct SQL query statement, this step is executed; otherwise, the user is prompted to retype the SQL query statement.
[0033] S13: Collect attribute information of the one or more form fields, and configure the attributes of the one or more form fields according to the attribute information to create a report.
[0034] reference image 3 , Displayed as a human-computer interaction interface diagram for collecting field attribute information, which shows figure 2 The five fields extracted from the SQL query, as well as their respective data types, display order, sorting method and other attribute information. This step will configure each field according to the configuration information entered by the user. For example, through the human-computer interaction interface, the user can add field Chinese names for each field, such as "user", "user code", "mailbox", "unit", and "department" as shown in the figure. In addition, through the human-computer interaction interface, the user can also determine the display order of each field. As shown in the figure, the display order of the five fields is: "User", "User Code", "Mailbox" , "Unit", "Department", etc. After the attribute information of each field is determined, the report can be generated. In the generated report, the data of different table fields but the same peers are correspondingly related according to the "display order". To image 3 As an example, the corresponding relationship of data in the same row is: user-user code-mailbox-unit-department.
[0035] Optionally, in another embodiment, the query parameters of the report can be defined before the report is created. The query parameters are used to specify query rules for the report to query data by keywords. Specifically, the query parameters include: equal, not equal, less than (or equal to), greater than (or equal to), between, in, containing, starting with, ending with, etc. . After defining the query parameters, if the user wants to query related data in the created report according to the entered keywords, this embodiment will query the data that meets the rules according to the operation rules of the defined query parameters. For example: the operation rule of the defined query parameter is "contains", the query field is "username", and the keyword entered is "horse", the query result will display all data rows that contain "horse" in the "username" , In addition to displaying the data containing "horse" in the user name field, each data row will also display the peer data of other fields associated with it in sequence, as shown in Table 1.
[0036] Table 1
[0037] user
[0038] Figure 4 Shown is a schematic diagram of the system for creating a report in an embodiment of the present invention. The system mainly includes: a basic information collection module 41, a field data extraction module 42, a field attribute configuration module 43, and further includes a query parameter definition module (not shown). Since the principles of the present system embodiment and the foregoing method embodiment correspond to the same, the same technical details will not be repeated here.
[0039] The basic information collection module 41 collects basic information of the report to be built; the basic information includes: SQL query statements, script statements used to limit the scope of the query, and the like.
[0040] The field data extraction module 42 extracts data of one or more table fields from the pre-stored data set according to the SQL query statement. Optionally, in another embodiment, the field data extraction module 42 limits the queryable range of the pre-stored data set according to the script statement, and extracts one or the data according to the SQL query statement within the limited query range. Data for multiple table fields. Optionally, in another embodiment, before extracting data according to the SQL query statement within the limited query range, the correctness of the SQL statement is checked.
[0041] The field attribute configuration module 43 collects the attribute information of the one or more form fields, and configures the attributes of the one or more form fields according to the attribute information to create a report.
[0042] The query parameter definition module is used to define query parameters of the report; the query parameters are used to specify query rules for the report to query data by keywords.
[0043] In addition, the present invention also includes a storage medium and an electronic device. Since the technical features in the foregoing embodiments can be applied to the storage medium embodiment and the electronic device embodiment, the details will not be repeated.
[0044] The storage medium includes: ROM, RAM, magnetic disk, or optical disc, and other media that can store program codes, in which are stored a computer program, which, when loaded and executed by a processor, implements the method for creating a report in the foregoing embodiment All or part of the steps.
[0045] The electronic device is a device including a processor (CPU/MCU/SOC), a memory (ROM/RAM), a communication module (wired/wireless network), and a display module, preferably a desktop computer. In particular, a computer program is stored in the memory, and the processor implements all or part of the steps of the method for creating a report in the foregoing embodiment when the computer program is loaded and executed.
[0046] In summary, the method, system, storage medium, and electronic equipment for creating reports of the present invention help to integrate data sources of multiple business platforms to quickly create reports required by users, avoiding the data-by-data creation of traditional reports. The cumbersome operation of input also facilitates users to view, extract and analyze report data at any time, which effectively overcomes various shortcomings in the existing technology and has a high industrial value.
[0047] The above-mentioned embodiments only exemplarily illustrate the principles and effects of the present invention, but are not used to limit the present invention. Anyone familiar with this technology can modify or change the above-mentioned embodiments without departing from the spirit and scope of the present invention. Therefore, all equivalent modifications or changes made by those with ordinary knowledge in the technical field without departing from the spirit and technical ideas disclosed in the present invention should still be covered by the claims of the present invention.
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

no PUM

Description & Claims & Application Information

We can also present the details of the Description, Claims and Application information to help users get a comprehensive understanding of the technical details of the patent, such as background art, summary of invention, brief description of drawings, description of embodiments, and other original content. On the other hand, users can also determine the specific scope of protection of the technology through the list of claims; as well as understand the changes in the life cycle of the technology with the presentation of the patent timeline. Login to view more.
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

Similar technology patents

Classification and recommendation of technical efficacy words

  • Easy to check anytime
  • Avoid cumbersome operations

GIS-based three-dimensional dynamic information physical system

PendingCN111125236AEasy to check anytimeGuarantee orderlyVisual data miningStructured data browsingOrder processingReal-time computing
Owner:中国东方电气集团有限公司

Endoscope center department management system

InactiveCN108010572AImprove securityEasy to check anytimeDigital data protectionHealthcare resources and facilitiesPatient informationDepartment management
Owner:GUANGZHOU GAOTONG PACS TECH

Commodity processing method and device, computer equipment and storage medium

PendingCN111507677AEasy to check anytimeAvoid wasting manpower and material resourcesOffice automationManufacturing computing systemsProcess engineeringComputer equipment
Owner:浙江坤盈科技有限公司

File transfer method, client and proxy server

ActiveCN104980399AAvoid cumbersome operationsSimplify the transfer processTransmissionClient-sideFile transfer
Owner:TENCENT TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products