Variable report filling method, storage medium, device, program product and apparatus

Abstract

The application belongs to the technical field of variable report data processing, and provides a variable report filling method, a storage medium, an equipment, a program product and a device. The variable report filling method comprises the following steps: determining a variable area according to a predefined format of a variable report; matching and creating a data storage table with a corresponding format for each type of variable area according to a preset filling requirement, and matching and constructing a corresponding data extraction model for each cell in the variable area; performing a data extraction operation of each data extraction model, storing the extracted report data into the data storage table matched by the corresponding variable area, and then determining the total amount of variable row / column data; dynamically expanding the total row / column number of the corresponding variable report according to the total amount of variable row / column data, and then filling the report data in the data storage table into the row / column of the corresponding variable area to obtain a filled variable report. The application realizes cross multi-dimensional comparative analysis of data in different sub-reports.

Description

Technical Field

[0001] This invention belongs to the field of change report data processing technology, and particularly relates to a change report filling method, storage medium, device, program product and apparatus. Background Technology

[0002] The statements in this section are merely background information related to the present invention and do not necessarily constitute prior art.

[0003] Reports are not only used for data collection but also for summarizing and statistical analysis. Most current reporting systems, with their variable row and column dimensions, only display query and analysis results, lacking support for data entry and structured storage, thus rendering them unsuitable as data sources for other analyses. For example, consider a project evaluation system where each unit has multiple projects (row dimension) and each project has multiple implementation phases (column dimension). After obtaining project information, work content, and construction status from the business system, it needs not only to display the data in multiple dimensions but also to score and evaluate it. The structured storage of these scores and evaluations can then be used for performance evaluation.

[0004] To address the issue of report filling, existing technologies provide a method for summarizing change reports based on standard coding. This method uses standard coding to unify and standardize the data to be collected. However, the report data is still filled in manually, resulting in low filling efficiency. Furthermore, it does not support simultaneous changes in the number of rows and columns, thus failing to achieve the goal of cross-sectional and multi-dimensional comparative analysis of data from different sub-reports within a single report. Summary of the Invention

[0005] To address the aforementioned technical problems, this invention provides a method, storage medium, device, program product, and apparatus for filling in change reports. It achieves automatic filling of report data through a data retrieval model and also supports supplementary filling of collected data. That is, it supports reports with only row / column changes as well as reports with changes in both rows and columns, and can realize comparative analysis of data in different sub-reports from a cross-dimensional perspective.

[0006] To achieve the above objectives, the present invention adopts the following technical solution:

[0007] The first aspect of the present invention provides a method for filling in change reports.

[0008] In one or more embodiments, a method for filling in a change report is provided, including:

[0009] Based on the predefined format of the change report, the change area is determined; the change area includes three types: change row area, change column area, and intersection area.

[0010] According to the preset reporting requirements, a data storage table with a corresponding format is created for each category of changing areas, and a corresponding data retrieval model is constructed for each cell in the changing area.

[0011] Execute the data retrieval operations of each data retrieval model, store the retrieved report data into the data storage table matched with the corresponding change area, and then determine the total amount of change row / column data;

[0012] The total number of rows / columns in the corresponding change report is dynamically expanded based on the total amount of changed row / column data. Then, the report data in the data storage table is filled into the rows / columns of the corresponding change area to obtain the completed change report.

[0013] Once the data retrieval is complete, you can manually fill in the additional rows or columns. The variable row area, variable column area, and intersection area are automatically encoded, and the data from different areas are stored in the data table according to the automatically encoded structure.

[0014] As one implementation method, the data storage table created by the variable row region matching has the following format:

[0015] Format row codes, data row codes, and numeric columns;

[0016] The format of the data storage table created by matching or / and the variable column range is:

[0017] Format column encoding, data column encoding, and numeric column.

[0018] As one implementation method, the data storage table created by the cross-region matching has the following format:

[0019] Format row encoding, data row encoding, format column encoding, data column encoding, and numeric column encoding.

[0020] As one implementation, the data retrieval model constructed by matching each cell in the intersection area consists of data row encoding, data column encoding, and numerical column.

[0021] In one implementation, the data retrieval model constructed by matching each cell in the variable row area consists of data row codes and numerical columns;

[0022] The data retrieval model, constructed by matching each cell in the variable column area, consists of data column codes and numerical columns.

[0023] As one implementation method, report data from the data storage table corresponding to the variable row area is filled into the variable row area according to the row coordinates and data row code order;

[0024] Fill the variable column area with report data from the data storage table corresponding to the variable column area according to column coordinates and data column code order;

[0025] Fill the report data from the data storage table corresponding to the intersection area into the intersection area in the order of row coordinates, data row code, column coordinates, and data column code.

[0026] A second aspect of the present invention provides a change report filling device.

[0027] In one or more embodiments, a change report filling device includes:

[0028] The region determination module is used to determine the change region based on the predefined format of the change report; the change region includes three types: change row region, change column region, and intersection region;

[0029] The region configuration module is used to create a data storage table in a corresponding format for each type of changing region according to preset filling requirements, and to build a corresponding data retrieval model for each cell in the changing region.

[0030] The data retrieval module is used to perform data retrieval operations for each data retrieval model, store the retrieved report data into the data storage table matched by the corresponding change area, and thus determine the total amount of change in rows / columns.

[0031] The data filling module is used to dynamically expand the total number of rows / columns of the corresponding change report based on the total amount of data in the changed rows / columns, and then fill the report data in the data storage table into the rows / columns of the corresponding change area to obtain the completed change report.

[0032] A third aspect of the present invention provides a computer-readable storage medium.

[0033] A computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps in the change report filling method described above.

[0034] A fourth aspect of the present invention provides a computer program product.

[0035] A computer program product includes a computer program / instructions that, when executed by a processor, implement the steps in the change report filling method described above.

[0036] A fifth aspect of the present invention provides an electronic device.

[0037] An electronic device includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the steps in the change report filling method described above.

[0038] Compared with the prior art, the beneficial effects of the present invention are:

[0039] (1) According to the preset filling requirements, the present invention creates a data storage table with a corresponding format for each category of change area and constructs a corresponding data retrieval model for each cell in the change area. Then, the report data retrieved by each data retrieval model is stored in the data storage table matched with the corresponding change area. The report data in the data storage table is filled into the row / column of the corresponding change area, and finally the filled change report is obtained. It realizes automatic filling of report data through the data retrieval model, realizes centralized storage of data, and lays the foundation for subsequent data analysis.

[0040] (2) The row and column change table obtained by the present invention based on the data acquisition model can be manually supplemented and filled in; the change area in the change report of the present invention includes three types: change row area, change column area and intersection area, so that the change report filling method of the present invention supports reports with only row / column changes as well as reports with both row and column changes, realizing the purpose of creating complex reports once and reusing them, and comparing and analyzing different sub-report data from a cross-dimensional perspective.

[0041] (3) This invention provides a method for data retrieval, filling, and summarizing of variable reports with non-fixed rows and columns. It adopts a method of uniformly coding cells to standardize the collected data, so that the data of each cell can be traced and located, thereby achieving the purpose of cross-multi-dimensional comparative analysis of business data in a report. Moreover, the analysis results support supplementary filling and can be used again for analysis of other dimensions. Attached Figure Description

[0042] The accompanying drawings, which form part of this invention, are used to provide a further understanding of the invention. The illustrative embodiments of the invention and their descriptions are used to explain the invention and do not constitute an improper limitation of the invention.

[0043] Figure 1 This is a flowchart illustrating the change report filling method according to an embodiment of the present invention;

[0044] Figure 2 This is a schematic diagram illustrating the modified report format and storage according to an embodiment of the present invention;

[0045] Figure 3 This is a schematic diagram of the structure of the change report filling device according to an embodiment of the present invention;

[0046] Figure 4 This is a schematic diagram of an electronic device according to an embodiment of the present invention. Detailed Implementation

[0047] The present invention will be further described below with reference to the accompanying drawings and embodiments.

[0048] It should be noted that the following detailed description is illustrative and intended to provide further explanation of the invention. Unless otherwise specified, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention pertains.

[0049] It should be noted that the terminology used herein is for the purpose of describing particular embodiments only and is not intended to limit the scope of exemplary embodiments according to the invention. As used herein, the singular form is intended to include the plural form as well, unless the context clearly indicates otherwise. Furthermore, it should be understood that when the terms "comprising" and / or "including" are used in this specification, they indicate the presence of features, steps, operations, devices, components, and / or combinations thereof.

[0050] Figure 1 This is a flowchart illustrating a change report filling method according to an embodiment of the present invention, as shown below. Figure 1 The change report filling method shown in this embodiment may include the following steps S101 to S104.

[0051] S101, determine the change area according to the predefined format of the change report; the change area includes three types: change row area, change column area and intersection area.

[0052] In practice, the change report consists of several rows and several columns of cells.

[0053] When defining the format of a change report, mark the cells corresponding to the change row area, change column area, and intersection area, record the format row code (e.g., row coordinate) corresponding to the change row area, record the format column code (e.g., column coordinate) corresponding to the change column area, and record the format row code and format column code (e.g., row coordinate and column coordinate) corresponding to the intersection area.

[0054] When defining the report format, you can set only the changing rows or columns, or you can set both rows and columns to change. You should also number each cell in the data filling area, such as A3, D1, etc. For example, in Table 1, the third row of the report is set as the changing row, column D is set as the changing column, A3, B3, and C3 are the changing row area, D1 and D2 are the changing column area, and D3 is the intersection area.

[0055] Table 1 Predefined Change Report

[0056] 1 D1 2 D2 3 A3 B3 C3 D3 4 5

[0057] The change areas in the change report of this embodiment include three types: change row area, change column area, and intersection area. This allows the change report filling method of the present invention to support reports with only row / column changes as well as reports with both row and column changes. This achieves the purpose of creating complex reports once and reusing them, and comparing and analyzing data from different sub-reports from a cross-dimensional perspective.

[0058] S102, according to the preset filling requirements, create a data storage table with a corresponding format for each category of change area matching, and construct a corresponding data retrieval model for each cell in the change area matching.

[0059] Figure 2 The variable table format and storage principle are explained. Figure 2 In the process, the format of the change report includes a format row dictionary and a format column dictionary, which store the format row code and the format column code, respectively.

[0060] In this embodiment, the data storage table created by the variable row area matching has the following format: format row code, data row code, and numeric columns (the number of numeric columns is equal to the number of cells).

[0061] The data storage table created by matching the variable column range has the following format: format column code, data column code, and numeric column (the number of numeric columns is equal to the number of cells).

[0062] The data storage table created by the cross-region matching has the following format: format row code, data row code, format column code, data column code, and numeric column (the number of numeric columns is equal to the number of cells).

[0063] It should be noted here that the numerical columns can be set according to the actual situation.

[0064] In this embodiment, as Figure 2 As shown, the data retrieval model constructed by matching each cell in the intersection area consists of a data row code, a data column code, and a value column. The data retrieval model constructed by matching each cell in the variable row area consists of a data row code and a value column. The data retrieval model constructed by matching each cell in the variable column area consists of a data column code and a value column.

[0065] For example, cells A3, B3, and C3 in Table 1 only need to expand multiple rows vertically. The data retrieval model needs to define row dimensions (generating data row codes based on row dimensions; for example, if the row dimension is the supplier number, then the row code is the supplier's actual value) and data columns. Cells D1 and D2 only need to expand multiple columns horizontally. The data retrieval model needs to define column dimensions (generating data column codes based on column dimensions; for example, if the column dimension is the project number, then the column code is the project number's actual value) and data columns. However, the intersection area D3 needs to expand both vertically and horizontally, requiring the definition of row dimensions (corresponding to data row codes), column dimensions (corresponding to data column codes), and data columns. Based on actual implementation, the data retrieval model can add dimensions such as data retrieval conditions and grouping conditions, making data retrieval more flexible and enabling retrieval regardless of the number of rows.

[0066] Table 2 Data Retrieval Model Configuration for Change Reports

[0067] 1 Data Acquisition Model Two 2 Data Acquisition Model Two 3 Data Acquisition Model 1 Data Acquisition Model 1 Data Acquisition Model 1 Data Acquisition Model 3 4 5

[0068] Tables 3, 4, and 5 provide the specific formats for Data Acquisition Model 1, Data Acquisition Model 2, and Data Acquisition Model 3.

[0069] Table 3 Data Acquisition Model 1

[0070]

[0071] Table 4 Data Acquisition Model Two

[0072] Numerical column Project Name, Year

[0073] Table 5 Data Acquisition Model Three

[0074] Levi Project Number Numerical column Balance

[0075] In some optional embodiments, the data retrieval model can be implemented using data retrieval SQL, which consists of dimension regions, statistical regions, data retrieval conditions, grouping conditions, and sorting conditions; wherein, the dimension region is the field for grouping, which is divided into row dimensions and column dimensions; the statistical region is the result field to be displayed in the report; the data retrieval conditions are the filtering conditions; the grouping conditions are the further filtering of the grouped data; and the sorting conditions are the display effect.

[0076] S103 executes the data retrieval operations for each data retrieval model, storing the retrieved report data into the data storage table matching the corresponding changed area, thereby determining the total amount of changed row / column data. Tables 6, 7, and 8 provide the specific formats of the data storage tables for the changed row area, the changed column area, and the cross area.

[0077] Table 6 Data storage table for the changed row area

[0078]

[0079] Table 7 Data storage table for the variable column area

[0080] L000004 000000001 Project A 2024 L000004 000000002 Project B 2023 L000004 000000003 Project C 2022

[0081] Table 8 Data storage table for cross-regions

[0082]

[0083]

[0084] S104: Dynamically expand the total number of rows / columns of the corresponding change report based on the total amount of changed row / column data, and then fill the report data in the data storage table into the rows / columns of the corresponding change area to obtain the completed change report.

[0085] After the data retrieval model performs calculations, the report data is stored in the data table created when the report format is defined. The report data loading process determines which cell each data point belongs to based on the format row and column coordinates and the data row and column coordinates. For areas where only rows and intersections change, the data is filled horizontally and vertically starting from the top-left cell, based on the obtained two-dimensional data set. For areas where only columns change, the retrieved data rows need to be converted to columns before filling.

[0086] Specifically, the report data from the data storage table corresponding to the changed row area is filled into the changed row area according to row coordinates and data row code order; the report data from the data storage table corresponding to the changed column area is filled into the changed column area according to column coordinates and data column code order; and the report data from the data storage table corresponding to the intersection area is filled into the intersection area according to row coordinates, data row code, column coordinates, and data column code order. The completed change report is shown in Table 9.

[0087] Table 9 Completed Change Report

[0088]

[0089]

[0090] Once the data retrieval report is complete, additional rows or columns can be manually entered. The variable row area, variable column area, and intersection area are automatically encoded, and the data from different areas are stored in the data table according to the automatically encoded structure.

[0091] This embodiment achieves the ability to create complex reports once and reuse them repeatedly, without needing to retrieve data again, through structured storage of the row and column cross-change table and flexible configuration of the data retrieval model. It supports both data filling via the data retrieval model and manual entry. For example, financial multi-auxiliary accounting reports and statistical multi-dimensional statistical tables can be created, and each unit can fill in data based on a single table, achieving centralized data storage and laying the foundation for subsequent data analysis.

[0092] Figure 3 This is a schematic diagram of a change report filling device according to an embodiment of the present invention. This embodiment is similar to... Figure 1 The reporting method for changes corresponds to that, such as... Figure 3 As shown, the change report filling device in this embodiment may include:

[0093] The region determination module 301 is used to determine the change region according to the predefined format of the change report; the change region includes three types: change row region, change column region and intersection region;

[0094] The region configuration module 302 is used to create a data storage table in a corresponding format for each type of variable region according to the preset filling requirements, and to construct a corresponding data retrieval model for each cell in the variable region.

[0095] The data retrieval module 303 is used to perform data retrieval operations for each data retrieval model, store the retrieved report data into the data storage table matched by the corresponding change area, and thus determine the total amount of change row / column data.

[0096] The data filling module 304 is used to dynamically expand the total number of rows / columns of the corresponding change report based on the total amount of data in the changed rows / columns, and then fill the report data in the data storage table into the rows / columns of the corresponding change area to obtain the completed change report.

[0097] It should be noted here that, Figure 3 The various modules in the change report filling device, and Figure 1 Each step in the change report filling method corresponds to the previous one, and the specific implementation process is the same, so it will not be repeated here.

[0098] Reference Figure 4 A schematic diagram of an electronic device is provided. It should be noted that... Figure 4 The electronic device 400 shown is merely an example and should not be construed as limiting the functionality and scope of use of the embodiments of the present invention.

[0099] like Figure 4As shown, the electronic device 400 includes a central processing unit (CPU) 401, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 402 or a program loaded from a storage section 408 into a random access memory (RAM) 403. The RAM 403 also stores various programs and data required for system operation. The CPU 401, ROM 402, and RAM 403 are interconnected via a bus 404. An input / output (I / O) interface 405 is also connected to the bus 404.

[0100] The following components are connected to I / O interface 405: an input section 406 including a keyboard, mouse, etc.; an output section 407 including a cathode ray tube (CRT), liquid crystal display (LCD), etc., and speakers, etc.; a storage section 408 including a hard disk, etc.; and a communication section 409 including a network interface card such as a local area network (LAN) card, modem, etc. The communication section 409 performs communication processing via a network such as the Internet. A drive 410 is also connected to I / O interface 405 as needed. A removable medium 411, such as a disk, optical disk, magneto-optical disk, semiconductor memory, etc., is installed on drive 410 as needed so that computer programs read from it can be installed into storage section 408 as needed.

[0101] When the central processing unit 401 in the electronic device of this embodiment executes the program, it achieves the following: Figure 1 The steps in the change report filling method are shown.

[0102] Specifically, according to embodiments of this application, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments of this application include a computer program product comprising a computer program carried on a computer-readable medium, the computer program including functions for executing... Figure 1 The program code for the method shown. In such an embodiment, the computer program can be downloaded and installed from a network via communication section 409, and / or installed from removable medium 411. When the computer program is executed by central processing unit 401, it performs the various functions defined in the apparatus of this application.

[0103] in, Figure 1 The computer program instructions corresponding to the method shown may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to operate in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in the process. Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0104] Those skilled in the art will understand that all or part of the processes in the above embodiments can be implemented by a computer program instructing related hardware. The program can be stored in a computer-readable storage medium, and when executed, it can include the processes of the embodiments of the above methods. The storage medium can be a magnetic disk, optical disk, read-only memory (ROM), or random access memory (RAM), etc.

[0105] The above description is merely a preferred embodiment of the present invention and is not intended to limit the invention. Various modifications and variations can be made to the present invention by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.

Claims

1. A method for filling out a change report, characterized in that, include: Based on the predefined format of the change report, the change area is determined; the change area includes three types: change row area, change column area, and intersection area. According to the preset data entry requirements, a corresponding data storage table is created for each category of changing areas, and a corresponding data retrieval model is constructed for each cell in the changing area. Specifically: The data storage table created by the variable row area matching has the following format: format row code, data row code, and numeric column; The data storage table created by the variable column range matching has the following format: format column code, data column code, and numeric column; The data storage table created by the cross-region matching has the following format: format row code, data row code, format column code, data column code, and numeric column; The data retrieval model constructed by matching each cell in the variable row area consists of a data row code and a numerical column; The data retrieval model constructed by matching each cell in the variable column area consists of a data column code and a numerical column; The data retrieval model constructed by matching each cell in the intersection area consists of data row code, data column code, and value column; Execute the data retrieval operations of each data retrieval model, store the retrieved report data into the data storage table matched with the corresponding change area, and then determine the total amount of change row / column data; The total number of rows / columns in the corresponding change report is dynamically expanded based on the total amount of changed row / column data. Then, the report data in the data storage table is filled into the rows / columns of the corresponding change area to obtain the completed change report.

2. The method for filling out change reports as described in claim 1, characterized in that, Fill the report data in the data storage table corresponding to the variable row area into the variable row area according to the row coordinates and data row code order; Fill the variable column area with report data from the data storage table corresponding to the variable column area according to column coordinates and data column code order; Fill the report data from the data storage table corresponding to the intersection area into the intersection area in the order of row coordinates, data row code, column coordinates, and data column code.

3. A change report filling device, characterized in that, include: The region determination module is used to determine the change region based on the predefined format of the change report; the change region includes three types: change row region, change column region, and intersection region; The region configuration module is used to create a data storage table in a corresponding format for each category of changing regions according to preset filling requirements, and to construct a corresponding data retrieval model for each cell in the changing region. Specifically: The data storage table created by the variable row area matching has the following format: format row code, data row code, and numeric column; The data storage table created by the variable column range matching has the following format: format column code, data column code, and numeric column; The data storage table created by the cross-region matching has the following format: format row code, data row code, format column code, data column code, and numeric column; The data retrieval model constructed by matching each cell in the variable row area consists of a data row code and a numerical column; The data retrieval model constructed by matching each cell in the variable column area consists of a data column code and a numerical column; The data retrieval model constructed by matching each cell in the intersection area consists of data row code, data column code, and value column; The data retrieval module is used to perform data retrieval operations for each data retrieval model, store the retrieved report data into the data storage table matched by the corresponding change area, and thus determine the total amount of change in rows / columns. The data filling module is used to dynamically expand the total number of rows / columns of the corresponding change report based on the total amount of data in the changed rows / columns, and then fill the report data in the data storage table into the rows / columns of the corresponding change area to obtain the completed change report.

4. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the program is executed by the processor, it implements the steps in the change report filling method as described in any one of claims 1-2.

5. A computer program product, comprising a computer program / instructions, characterized in that, When the computer program / instruction is executed by the processor, it implements the steps in the change report filling method as described in any one of claims 1-2.

6. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the program, it implements the steps in the change report filling method as described in any one of claims 1-2.

Images