CN121301450A - Report generation methods, devices, equipment and storage media - Google Patents

Abstract

The application provides a report generation method, a report generation device, report generation equipment and a report generation storage medium, which can be applied to the technical field of data processing. The method comprises the steps of obtaining a field set of report data to be filled, extracting a hierarchical relation corresponding to each field in the field set to construct a tree structure, traversing all fields under each level of the tree structure, taking the lowest level without repeated fields as a target level, regarding each target filling area in a report template, taking the level fields corresponding to the target level and each level lower than the target level as level index fields of the target filling area, matching the fields corresponding to each data in the report data to be filled, associating the matched data with the target filling area, and filling the data associated with the target filling area into the target filling area to generate a report.

Description

Report generation method, device, equipment and storage medium

Technical Field

The present application relates to the field of data processing technologies, and in particular, to a report generating method, apparatus, device, medium, and program product.

Background

In the financial field, financial enterprises typically rely on reports to manage various types of data. The sources of the existing report data generally comprise data of an external system in online butt joint and offline data acquired offline, and because the sources of the data are various, different data levels exist in different data, the report template with various data levels can be customized. In the related art, in order to avoid filling errors in the process of filling data into a report template, names or codes of all data levels corresponding to the data are generally used as indexes, the data are associated with cells in the report template, however, when the data levels are more, the number of fields to be compared in the association process is more in the mode, and the report generation efficiency is low.

Disclosure of Invention

In view of the above, the present application provides a report generating method, apparatus, device, medium, and program product that improve report generating efficiency.

According to a first aspect of the application, a report generating method is provided, which comprises the steps of obtaining a field set of report data to be filled, wherein the field set comprises fields and hierarchical relations corresponding to all titles in the report data to be filled, extracting the hierarchical relations corresponding to all fields in the field set, constructing a tree structure, traversing all fields under all levels of the tree structure, taking the lowest level without repeated fields as a target level, taking the level fields corresponding to the target level and all levels lower than the target level as level index fields of the target filling area for each target filling area in a report template, matching the fields corresponding to all data in the report data to be filled, associating the matched data with the target filling area, constructing the report template based on the tree structure, and filling the data associated with the target filling area into the target filling area to generate a report.

According to the embodiment of the application, the target filling area is a row in the report template, fields corresponding to all data in report data to be filled are matched, the matched data are associated with the target filling area, the method comprises the steps of regarding each row in the report template as a first matching row, regarding a level field of a target level corresponding to the first matching row as a first level index field, looking up a row corresponding to the first level index field in the report data to be filled, constructing a candidate row set, regarding each level lower than the target level, regarding a level field of each level corresponding to the first matching row as a second level index field in sequence from high to low, looking up a row corresponding to the second level index field in the candidate row set, and updating the candidate row set by using the looked up row, and regarding the row as a second matching row and associating the second matching row with the first matching row under the condition that the candidate row set only comprises one row.

According to an embodiment of the application, associating the second matching row with the first matching row includes associating a row code for each data in the second matching row with a row code for each data in the first matching row.

According to the embodiment of the application, traversing all fields under each level of the tree structure takes the lowest level without repeated columns of fields as a target level, wherein the method comprises the steps of acquiring all fields under each level of the tree structure, taking any two fields of the level as candidate levels when the fields are different, and taking the lowest level in the candidate levels as the target level.

According to an embodiment of the application, the method further comprises removing data associated with the target fill area after filling the data associated with the target fill area into the target fill area.

According to the embodiment of the application, the method further comprises the steps of obtaining the residual filling area which is not associated with the report data to be filled in the report template, traversing all fields under each level corresponding to the residual filling area, and taking the lowest level without repeated fields as the updated target level.

According to an embodiment of the application, the tree structure comprises a header tree representing the hierarchical relation of row fields corresponding to each row header and a column report item tree representing the hierarchical relation of column fields corresponding to each column header, the target fill area comprises N cells, N is an integer greater than or equal to 1, the method further comprises the steps of taking a node code of a first final stage node in the header tree corresponding to the cells as a first code of the cells, and taking a node code of a second final stage node in the column report item tree corresponding to the cells as a second code of the cells, so that the coordinates of each cell can be determined through the first code and the second code.

According to an embodiment of the application, the method further comprises locating each cell according to the first code and the second code, setting a data rule for each cell to perform a corresponding processing operation on the data filled into the cell according to the data rule, wherein the data rule comprises at least one of a data format of the cell, a data processing rule of the cell and a data input rule of the cell.

The application provides a report generating device which comprises a field acquisition module, a tree generating module, a level determining module and a line association module, wherein the field acquisition module is used for acquiring a field set of report data to be filled, the field set comprises fields corresponding to all titles in the report data to be filled and level relations, the tree generating module is used for extracting the level relations corresponding to all fields in the field set to construct a tree structure, the level determining module is used for traversing all fields under all levels of the tree structure, the lowest level without repeated column fields is used as a target level, the line association module is used for regarding a level field corresponding to each level of a target level and a level field lower than the target level in a report template as a level index field of the target filling area, the fields corresponding to all data in the report data to be filled are matched, the matched data are associated with the target filling area, the report template is constructed based on the tree structure, and the report generating module is used for filling the data associated with the target filling area into the target filling area to generate a report.

A third aspect of the application provides an electronic device comprising one or more processors and a memory for storing one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method described above.

A fourth aspect of the application also provides a computer readable storage medium having stored thereon executable instructions which, when executed by a processor, cause the processor to perform the above method.

The fifth aspect of the application also provides a computer program product comprising a computer program which, when executed by a processor, implements the above method.

According to the report generation method, the device, the equipment, the medium and the program product provided by the application, the hierarchical relation of each field in the title is intuitively reflected by adopting the tree structure, all fields under each hierarchy of the tree structure are traversed in the report filling process, the lowest hierarchy without repeated fields is taken as a target hierarchy, and the hierarchy fields of each hierarchy which is lower than the target hierarchy are taken as hierarchy index fields for data matching. Because the target level is the lowest level without repeated columns of fields, filling errors caused by name repetition cannot occur by taking the field corresponding to the target level as an index, and fields of other levels higher than the target level are not required to be matched, so that the fields needing to be compared are reduced, the problems that the fields needing to be compared are more and the report generating efficiency is low in the report filling process are at least partially solved, and the report generating efficiency is improved.

Drawings

The foregoing and other objects, features and advantages of the application will be apparent from the following description of embodiments of the application with reference to the accompanying drawings, in which:

FIG. 1 schematically illustrates an application scenario diagram of a report generation method, apparatus, device, medium and program product according to an embodiment of the application;

FIG. 2 schematically illustrates a flow chart of a report generation method according to an embodiment of the application;

FIG. 3 schematically illustrates an example diagram of report data to be filled in according to an embodiment of the application;

FIG. 4 schematically illustrates an example diagram of a header tree constructed in accordance with a report generation method provided by an embodiment of the present application;

FIG. 5 schematically illustrates an example diagram of a column report item tree constructed in accordance with a report generation method provided by an embodiment of the present application;

FIG. 6 is a block diagram schematically showing a structure of a report generating apparatus according to an embodiment of the present application, and

Fig. 7 schematically shows a block diagram of an electronic device adapted to implement a report generating method according to an embodiment of the application.

Detailed Description

Hereinafter, embodiments of the present application will be described with reference to the accompanying drawings. It should be understood that the description is only illustrative and is not intended to limit the scope of the application. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the application. It may be evident, however, that one or more embodiments may be practiced without these specific details. In addition, in the following description, descriptions of well-known structures and techniques are omitted so as not to unnecessarily obscure the present application.

The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. The terms "comprises," "comprising," and/or the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.

All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It should be noted that the terms used herein should be construed to have meanings consistent with the context of the present specification and should not be construed in an idealized or overly formal manner.

Where a convention analogous to "at least one of A, B and C, etc." is used, in general such a convention should be interpreted in accordance with the meaning of one of skill in the art having generally understood the convention (e.g., "a system having at least one of A, B and C" would include, but not be limited to, systems having a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.).

In the technical scheme of the application, the related processes of collecting, storing, using, processing, transmitting, providing, disclosing, applying and the like of the personal information of the user accord with the regulations of related laws and regulations, necessary processing measures are adopted, and the public order harmony is not violated.

In the technical scheme of the application, the processes of acquiring, collecting, storing, using, processing, transmitting, providing, disclosing, applying and the like of the data all conform to the regulations of related laws and regulations, necessary treatment measures are adopted, and the public order is not violated.

It should be noted that, in the embodiments of the present application, some existing solutions in the industry of software, components, models, etc. may be mentioned, and they should be regarded as exemplary, which is merely for illustrating the feasibility of implementing the technical solution of the present application, but does not mean that the applicant has or must not use the solution.

Fig. 1 schematically illustrates an application scenario diagram of a report generation method, apparatus, device and storage medium according to an embodiment of the present application.

As shown in fig. 1, an application scenario 100 according to this embodiment may include terminal devices 101, 102, 103, a network 104, and a server 105. The network 104 is used as a medium to provide communication links between the terminal devices 101, 102, 103 and the server 105. The network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.

The user may interact with the server 105 via the network 104 using the terminal devices 101, 102, 103 to receive or send messages or the like. Various communication client applications, such as shopping class applications, web browser applications, search class applications, instant messaging tools, mailbox clients, social platform software, etc. (by way of example only) may be installed on the terminal devices 101, 102, 103.

The terminal devices 101, 102, 103 may be a variety of electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablets, laptop and desktop computers, and the like.

The server 105 may be a server providing various services, such as a background management server (by way of example only) providing support for websites browsed by users using the terminal devices 101, 102, 103. The background management server may analyze and process the received data such as the user request, and feed back the processing result (e.g., the web page, information, or data obtained or generated according to the user request) to the terminal device.

The user may upload the offline form data to the server 105 using the terminal devices 101, 102, 103, so that the server 105 generates a corresponding report from the uploaded data and stores the report in the database. The user may also perform data processing on the online generated data transmitted via the network 104 by using the terminal devices 101, 102, 103, and upload the processed data to the server 105, so that the server 105 generates a corresponding report according to the uploaded data and stores the report in the database

It should be noted that, the report generating method provided by the embodiment of the present application may be generally executed by the server 105. Accordingly, the report generating device provided by the embodiment of the present application may be generally disposed in the server 105. The report generating method provided by the embodiment of the present application may also be performed by a server or a server cluster that is different from the server 105 and is capable of communicating with the terminal devices 101, 102, 103 and/or the server 105. Accordingly, the report generating apparatus provided by the embodiment of the present application may also be provided in a server or a server cluster that is different from the server 105 and is capable of communicating with the terminal devices 101, 102, 103 and/or the server 105.

It should be understood that the number of terminal devices, networks and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.

The report generation method according to the embodiment of the present application will be described in detail below with reference to fig. 2 to 5 based on the scenario described in fig. 1.

Fig. 2 schematically shows a flowchart of a report generating method according to an embodiment of the application.

As shown in FIG. 2, the report generating method of this embodiment includes operations S210 to S250.

In operation S210, a field set of report data to be filled is obtained, where the field set includes fields and hierarchical relationships corresponding to each title in the report data to be filled.

In operation S220, a hierarchical relationship corresponding to each field in the field set is extracted, and a tree structure is constructed.

In operation S230, all the fields under each level of the tree structure are traversed, and the lowest level where no duplicate fields exist is taken as a target level.

In operation S240, for each target filling area in the report template, the level fields corresponding to the levels of the target level and the levels lower than the target level are used as level index fields of the target filling area, the fields corresponding to the data in the report data to be filled are matched, the matched data are associated with the target filling area, and the report template is constructed based on the tree structure.

In operation S250, data associated with the target filling area is filled into the target filling area, and a report is generated.

In the embodiment of the application, the hierarchical relation between the row fields and the column fields is intuitively reflected by a tree structure through generating a header tree and a column report item tree, and in the report filling process, the column fields under each level of the column report tree are traversed, the lowest level without repeated column fields is used as a first level, and the column fields of each level lower than the first level are used as the level index fields of the row for data matching. Because the first hierarchy is the lowest hierarchy without repeated column fields, filling errors caused by repeated names can not occur by taking the name of the first hierarchy as an index, column fields of other hierarchies higher than the first hierarchy are not required to be matched, fields needing to be compared are reduced, and report generation efficiency is improved.

For data having multiple data levels, it is common today to associate the data with cells in the reporting model with the names or encodings of all data levels to which the data corresponds as an index. For example, in a set of data reflecting the business status of the company, the business index a, the business index b and the business index c of A, B companies of the Y groups in each month of m years are included at the same time, wherein the business indexes a, b and c can be the indexes reflecting the business status of the company, such as business income, cost and net profit of the company. The data in each row of the table storing the data may have three data levels, the highest level being "group", the middle level being "company", the lowest level being "business index", the data in each column may have two data levels, the highest level being "year", and the lowest level being "month". Fig. 3 schematically shows an example diagram of report data to be filled in according to an embodiment of the present application. Referring to fig. 3, for data x, it is specific data of the business index a of company a of group Y at 1 month of m years. When the data x is required to be filled into the report template, the corresponding company a and company B have three identical operation indexes in the data level of the operation index, so that the line of the data x cannot be directly searched by the operation index a. Therefore, in order to accurately fill the data x into the corresponding position of the report, in the related art, the names of all data levels, such as "Y group, a company, and operation index a" are used as the index of the line where the data x is located, and are matched with the corresponding field in the report template, when all three data levels are correctly matched, the data is associated with the cells in the report template and is filled into the corresponding cells. However, this approach requires matching of all data level fields, especially when there are more data levels, which reduces the efficiency of data processing and report generation.

Based on this, in the embodiment of the present application, the fields corresponding to the headers of the data are converted into the tree structure, mainly, the line fields corresponding to the line headers are converted into the header tree, the column fields corresponding to the column headers are converted into the column report item tree, so as to clearly represent the data hierarchy, and facilitate the subsequent data processing, and then the hierarchy analysis processing is performed on the fields. It should be noted that, in the embodiment of the present application, the report template is constructed based on the report data to be filled, and the report template is identical to the data level of the report data to be filled, so that in order to facilitate accurate database falling of data, the whole or part of the report data to be filled may be imported into the report template to obtain a filled report, so that a line or a column of fields may be directly matched, after the matching is completed, the whole line or the whole column of data may be integrally imported, or the line fields and the column fields of one or several data may be simultaneously and separately matched, so that accurate positioning and importing of single data or multiple associated data may be realized. In the process of carrying out hierarchical analysis processing, fields in each data hierarchy are called as hierarchical fields of the hierarchy, whether repeated fields exist in all hierarchical fields under the hierarchy is judged for the hierarchical fields corresponding to each data hierarchy, the lowest hierarchy among the data hierarchies without repeated fields is selected as a target hierarchy, index matching is carried out by adopting the target hierarchy and fields lower than the target hierarchy, and matching is not needed for fields higher than the target hierarchy, so that the number of fields needing to be matched is reduced, and the data processing efficiency is improved.

For convenience of description, the scheme of the embodiment of the present application is described below by taking the whole importing of a row of data as an example, and the whole importing of a row of data can be implemented based on the same principle. Referring again to FIG. 3, a column report item tree having a three-level hierarchy may be constructed based on the data of FIG. 3, wherein the highest level corresponds to "cliques", the middle level corresponds to "companies", and the lowest level corresponds to "business indexes". For the lowest hierarchy, the column field contains two "business index a", "business index b" and "business index c", i.e. there is a repeated column field name under the hierarchy. For the middle level, "company a" and "company B" appear only once, and there is no repeated column field name, the middle level "company" can be used as the first level, and the column field "Y group" in the highest level "group" higher than the first level is not needed in matching. Based on the above, when the data x is required to be filled into the report template, the "A company, the operation index a" is only required to be used as the index of the line where the data x is located, and the data x is matched with the corresponding field in the report template, so that the matching process of the "Y group" field is omitted, the calculation resource is saved, and the data processing amount is reduced.

In operation S210, a set of row fields and a set of column fields of report data to be filled may be acquired. In the embodiment of the application, the report data to be filled can be online data generated online or offline data generated offline.

For online data, the online data is usually generated and stored in a form of a table, and can be directly imported through a data interface, the table is split, and row fields and column fields representing a data hierarchy in rows and columns are split to form a row field set and a column field set.

For offline data, typically manually recorded data, a table file can be created for the data according to the data structure, the data can be entered into the table file, and the subsequent operations are the same as the online data. In some embodiments, the line field and the column field of the data can be directly input into the computer according to the data level of the offline data to form a line field set and a column field set for processing by the system, and the offline data is imported into the report template after the report template is generated according to the header tree and the column report item tree.

For convenience in describing the scheme of the embodiment of the present application, the following description uses the data in fig. 3 as report data to be filled.

In operation S220, a hierarchical relationship corresponding to each field in the field set is extracted, including a hierarchical relationship of a row field corresponding to each row field and a hierarchical relationship of a column field corresponding to a column field, to generate a header tree and a column report item tree, respectively. The table head tree is a tree structure for representing the hierarchical relationship of each row field in the row field set, the column report item tree is a tree structure for representing the hierarchical relationship of each column field in the column field set, each row field is a node in the table head tree, and each column field is a node in the column report item tree.

Taking the data in fig. 3 as an example, a header tree as shown in fig. 4 may be constructed, and fig. 4 schematically shows an example diagram of a header tree constructed by using the report generating method according to the embodiment of the present application. Referring to fig. 4, each node in the header tree, i.e., each row field, each column in the header tree corresponds to one data level, e.g., a first column corresponds to the "year" of the highest level, having one node "m years", a second column corresponds to the "month" of the lowest level, and may have multiple nodes, e.g., "1 month", "2 months", "3 months", etc. The constructed header tree can intuitively reflect the data hierarchy relation among the row fields, can facilitate the generation of subsequent report templates, improves the generation efficiency, and can also facilitate the modification of the report templates by modifying the header tree.

Each node corresponds to one piece of data when storing, and the data comprises a main key ID (Identifier), a node code, a node name, a report type, a father node code, a father node name and a node level so as to record key information of the node.

Taking the data in fig. 3 as an example, a column report item tree as shown in fig. 5 may be constructed, and fig. 5 schematically shows an example diagram of a column report item tree constructed according to the report generation method provided by the embodiment of the present application. Referring to fig. 5, each node in the column report item tree corresponds to each column field, and each column in the column report item tree corresponds to one data level, for example, a first column corresponds to a "group" of a highest level, having one node "Y group", a second column corresponds to a "company" of an intermediate level, having two nodes "a company" and "B company", a third column corresponds to a "business index" of a lowest level, having six nodes, wherein three nodes "business index a", "business index B", "business index c" are sub-nodes of "a company", and the other three nodes "business index a", "business index B", and business index c "are sub-nodes of" B company ". The constructed column report item tree can intuitively reflect the data hierarchy relation among column fields, can facilitate the generation of subsequent report templates, improve the generation efficiency, and facilitate the subsequent field comparison, so that corresponding data is matched when a report is filled, and meanwhile, the report template can be conveniently modified by modifying the column report item tree.

In some embodiments, a report template for report data to be filled may be further generated according to the header tree and the list report item tree. Different report types can be preset, an initial report template is defined for each report type, the corresponding report type is matched according to the type of report data to be filled in the report filling process, and the report template is generated according to the header tree and the list report item tree.

In the embodiment of the application, in order to realize accurate filling of data, when the report template is generated, each final node in the header tree and the column report item tree corresponds to one column or one row of data, and the final node of one header tree and the final node of one column report item tree can uniquely position one data point, namely one cell in the report template. Based on this, the report generating method according to the embodiment of the present application further includes, after operation S220, for a cell in the target filling area in the report template, encoding a node of a first final node in the header tree corresponding to the cell as a first encoding of the cell, and encoding a node of a second final node in the column report item tree corresponding to the cell as a second encoding of the cell, so as to determine coordinates of each cell through the first encoding and the second encoding. The target filling area comprises N unit cells, wherein N is an integer greater than or equal to 1.

In the embodiment of the application, when the report is generated, the report data to be filled is generally the same as the data arrangement in the report to be generated, for example, when the report data to be filled is offline data, the table file used in the data input process is usually compiled according to the format of the report to be generated, so that the data can be directly imported according to rows or columns. Meanwhile, according to a general data storage habit, a line of data can generally represent a plurality of values corresponding to an attribute under different conditions, for example, the data in fig. 3, and a line of data represents a specific value of a certain operation index in each month, so that a line of data with an association relationship can be integrally imported into a report template from report data to be filled in a line importing manner. In other embodiments, data may be imported in columns or data by data.

The final nodes of each header tree and the final nodes of the column report item tree are uniquely corresponding to one cell, so that the node codes of the final nodes in the header tree and the node codes of the final nodes in the column report item tree can be adopted as indexes of the unique corresponding cell, the cell can be accurately positioned based on the indexes so as to facilitate editing and other operations on the cell, data correction can be carried out based on the indexes, for example, after report generation is completed, one or more data in report data to be filled can be selected randomly, the final nodes of the corresponding header tree and the final nodes of the column report item tree are determined according to the data positions, and then the corresponding cell in the report is searched according to the node codes of the two final nodes, so that whether the data are filled or not can be determined.

In the embodiment of the application, considering that data processing requirements or data format requirements may exist during report generation, after operation S220, the report generation method provided by the embodiment of the application further includes positioning each cell according to the first code and the second code, setting a data rule for each cell to execute corresponding processing operation on data filled into the cell according to the data rule, wherein the data rule includes at least one of a data format of the cell, a data processing rule of the cell and a data input rule of the cell.

In the embodiment of the application, the coordinate of a cell can be uniquely positioned according to the first code and the second code, and then the corresponding data rule is set for the cell according to the data of the cell, so that after the data is filled into the cell, the automatic processing of the data is realized, and the data processing efficiency is improved. The data format of the cells can be various formats such as text format, digital format, date format and the like, and the data formats of different cells have different data display effects. The data processing rules of the cells indicate processing operations accepted by the data in the cells, and may include operations of custom formula processing, character conversion, unit conversion and the like on the data. The data input rules of the unit cell may include a data input range limit, a format limit, etc., the data input range limit may include a positive and negative value range, a numerical value range, etc., and the format limit may be whether the data meets a specific format requirement, for example, has brackets, has a specific number of parameters, etc. Based on the set data rules, the data can be automatically processed, the report generation efficiency is improved, and on the other hand, the data can be automatically checked, and the data which does not meet the related rules can be timely found and positioned.

In operation S230, all the fields under each level of the tree structure are traversed, and the lowest level where no duplicate fields exist is taken as a target level. After the report template is generated, the report data to be filled needs to be matched with the report template and written into the report template so as to generate a required report. In an embodiment of the present application, operation S230 may specifically include the operations of acquiring all fields under each level of the tree structure, regarding each level as a candidate level if any two fields of the level are different, and regarding the lowest level of the candidate levels as a target level.

Taking a tree structure as an example of a column report item tree, in the embodiment of the application, column fields under each level of the column report tree can be traversed, and comparison operation is respectively performed on the column fields under each level to determine whether the same column field exists under the level. For the hierarchy without the same column field, the hierarchy and other hierarchies lower than the hierarchy are judged to be used as indexes, the problem that the hierarchy cannot be accurately matched due to field repetition does not occur, and the hierarchy is marked as a candidate hierarchy. After the comparison of all the levels is completed, the lowest level in the candidate levels is selected as the first level, so that the number of fields to be compared is reduced as much as possible, and the data processing efficiency is improved.

In some embodiments, the column fields under each level may be extracted in turn from low to high according to the data level in the column report item tree for comparison, and when there is no repeated column field in a certain level, the level is taken as the first level. In comparison with the above method, this method does not need to compare all column fields, but the column field level size needs to be determined once before extracting the column field under each level. In practical application, a method with higher processing efficiency can be selected according to the parameters such as the number of layers, the number of column fields and the like.

The same operation can be performed on the header tree, the row field under each level in the header tree is traversed, and the target level is determined, so that the whole column of data is imported based on the subsequent operation.

In operation S240, the entire data in the report data to be filled may be imported into the report template, and at this time, the target filling area is a row in the report template. For each row in the report template, the column field of the first level corresponding to the row and the column field of each level lower than the first level are used as the level index field of the row, the corresponding column field in the report data to be filled is matched, and the row is associated with the row corresponding to the column field in the matched report data to be filled. After the first hierarchy is determined, column fields in the first hierarchy and other hierarchies lower than the first hierarchy are used as fields for matching, and for the data hierarchy higher than the first hierarchy, the fields do not need to be matched, so that the data processing amount is reduced. And the report template can be integrally imported into the whole column of data in the report data to be filled in the same way.

Taking the target filling area as a behavior example in the report template, in the embodiment of the present application, the operation S240 may specifically include operations S241 to S243.

In operation S241, for each line in the report template, the line is used as a first matching line, a level field of a target level corresponding to the first matching line is used as a first level index field, and a line corresponding to the first level index field in report data to be filled is searched for to construct a candidate line set.

With the example of the behavior of the data x in fig. 3, it can be known from the foregoing description that, for the report data to be filled, the first hierarchy is the hierarchy corresponding to the company, and when the line of the data x is written into the report template, the three lines corresponding to the company a are searched in the table in fig. 3 according to the column field of the first hierarchy, namely the company a, as the index field of the first hierarchy, so as to construct the candidate line set.

In operation S242, for each level lower than the target level, the level fields of each level corresponding to the first matching line are sequentially used as the second level index fields according to the level from high to low, the line corresponding to the second level index field in the candidate line set is searched, and the candidate line set is updated using the searched line.

On the basis of constructing a candidate line set, further taking a column field 'operation index a' in an 'operation index' lower than a hierarchy of a 'company' as a second hierarchy index field, searching a line corresponding to the 'operation index a' in three lines corresponding to the candidate line set, namely a 'company', updating the candidate line set by using the searched line, wherein the updated candidate line set only comprises the line where the data x is located in the embodiment. If the data hierarchy is more, operation S242 may be repeated, and the column field lower than two hierarchies of "company" is used as the new index field of the second hierarchy to search until the obtained candidate row is unique.

In operation S243, in the case where the candidate line set includes only one line, the line is regarded as a second matching line, and the second matching line is associated with the first matching line. In this embodiment, the second matching line is the line where the data x is located, the line is matched and associated with the corresponding line in the report template, and the first matching line and the second matching line may be associated in a manner of adding the same tag, so that in the process of filling data into the first matching line, the second matching line is uniquely found based on the tag, and the data in the line is filled into the first matching line. In other embodiments, the data may be directly filled without adding a tag, that is, after the second matching line is found, the data in the second matching line is directly filled into the first matching line.

In the embodiment of the application, the range of the candidate rows is gradually narrowed by adopting a hierarchical index mode, and only one column field with the highest hierarchy is used for searching each time, so that the searching times and the number of fields used in each searching are reduced to the greatest extent compared with the mode of directly using all column fields for searching, the required rows can be quickly and accurately searched in report data to be filled, and the data processing efficiency is improved.

In some embodiments, associating the second matching row with the first matching row may also be in a code-association manner, including the operation of associating a row code for each data in the second matching row with a row code for each data in the first matching row.

In this embodiment, the line code of each data in the second matching line is associated with the line code of each data in the first matching line, which may be changed to be consistent with the line code of each data in the first matching line, or may be added to the set position of the existing line code of each data in the second matching line.

By adopting a line coding association mode, no additional operation is required to be executed or additional tag generation rules are defined, and the data processing efficiency is improved.

In some embodiments, the method further comprises associating a column code for each column of data in the second matched row with a column code for each corresponding column of data in the first matched row.

The column code of each column data in the second matching line is associated with the column code of each column data corresponding to the first matching line, and the column code of each column data in the second matching line may be changed to be identical to the column code of each column data corresponding to the first matching line, or the column code of each column data corresponding to the first matching line may be added to the set position of the existing column code of each data in the second matching line.

Because the row codes and the column codes can be used as two-dimensional coordinates of cells or data, and meanwhile, the mode of associating the row codes and the column codes is adopted, the positions of the cells or the data can be uniquely indicated, each data in the report data to be filled can be ensured to uniquely correspond to each cell in the report template, the accuracy of report generation is ensured, and the data can be filled one by one.

In operation S250, data associated with the target filling area is filled into the target filling area, and a report is generated.

In the embodiment of the present application, in order to further improve the report generation efficiency, after each association of a target filling area is completed in operation S240, a filling operation may be performed, and the data of the associated target filling area may be filled into the report template. At this time, after the completion of the population, the report generating method further includes removing the data associated with the target population region after the data associated with the target population region is populated into the target population region.

After the associated data is filled into the report template, the corresponding data in the report data to be filled is removed, so that the associated data is not required to be processed when being associated next time, the data processing amount is reduced, and the data processing efficiency is improved.

In some embodiments, after removing the associated row, the report generating method further comprises the steps of obtaining a remaining filling area which is not associated with report data to be filled in a report template, traversing all fields under each level corresponding to the remaining filling area, and taking the lowest level without repeated column fields as an updated target level.

In the above embodiment, after the associated data in the report data to be filled is removed, the data level corresponding to the field in the row and column of the report data to be filled may change, so as to further improve the data processing efficiency, the above operation S230 may be executed again, and a new first level may be determined again according to the remaining data. For example, if all three rows of data corresponding to "company a" in fig. 3 are removed, there is no repeated column field under the "business index" level, at this time, the first level may be changed to the level corresponding to "business index", and in the subsequent row association, there is no need to match the "company" in the report data to be filled, only the "business index" needs to be matched, so that the number of matched fields is further reduced, and the data processing efficiency is improved.

In some embodiments, the operation of re-determining the first hierarchy may be performed after removing a certain amount of data, for example, after removing more than 30% of the rows in the report data to be filled, operation S230 is performed again to re-determine the first hierarchy.

Based on the report generating method, the application also provides a report generating device. The device will be described in detail below in connection with fig. 6.

Fig. 6 schematically shows a block diagram of a report generating apparatus according to an embodiment of the application.

As shown in fig. 6, the report generating apparatus 600 of this embodiment includes a field acquiring module 610, a tree generating module 620, a hierarchy determining module 630, a row associating module 640, and a report generating module 650.

The field acquisition module 610 is configured to acquire a field set of the report data to be filled, where the field set includes fields and hierarchical relationships corresponding to each title in the report data to be filled. In an embodiment, the field obtaining module 610 may be configured to perform the operation S210 described above, which is not described herein.

The tree generating module 620 is configured to extract a hierarchical relationship corresponding to each field in the field set, and construct a tree structure. In an embodiment, the tree generating module 620 may be configured to perform the operation S220 described above, which is not described herein.

The hierarchy determining module 630 is configured to traverse all the fields under each hierarchy of the tree structure, and takes the lowest hierarchy where no repeated column field exists as a target hierarchy. In an embodiment, the hierarchy determining module 630 may be configured to perform the operation S230 described above, which is not described herein.

The row association module 640 is configured to, for each target filling area in the report template, match fields corresponding to each data in the report data to be filled with the target filling area by using the target level and level fields corresponding to each level lower than the target level as level index fields of the target filling area, and associate the matched data with the target filling area, where the report template is constructed based on a tree structure. In an embodiment, the row association module 640 may be used to perform the operation S240 described above, which is not described herein.

The report generation module 650 is configured to populate data associated with the target fill area into the target fill area to generate a report. In an embodiment, the report generating module 650 may be configured to perform the operation S250 described above, which is not described herein.

According to the embodiment of the application, the target filling area is a row in the report template, fields corresponding to all data in report data to be filled are matched, the matched data are associated with the target filling area, the row association module 640 is further used for regarding each row in the report template as a first matching row, regarding a level field of a target level corresponding to the first matching row as a first level index field, searching for a row corresponding to the first level index field in the report data to be filled, constructing a candidate row set, regarding each level lower than the target level, regarding a level field of each level corresponding to the first matching row as a second level index field in sequence from high to low, searching for a row corresponding to the second level index field in the candidate row set, and updating the candidate row set by using the searched row, and regarding the row as a second matching row when the candidate row set only comprises one row, associating the second matching row with the first matching row.

The row association module 640 is further configured to associate a row code of each data in the second matching row with a row code of each data in the first matching row, according to an embodiment of the present application.

According to an embodiment of the present application, the hierarchy determining module 630 is further configured to obtain all fields under each hierarchy of the tree structure, regarding each hierarchy as a candidate hierarchy if any two fields of the hierarchy are different, and regarding a lowest hierarchy of the candidate hierarchies as a target hierarchy.

The row association module 640 is further configured to remove rows associated with the report templates in the report data to be filled in, so as to reduce the matching times according to the embodiment of the present application.

According to the embodiment of the application, the row association module 640 is further configured to obtain the remaining rows in the report template that are not associated with the report data to be filled, traverse the column fields under each level corresponding to the remaining rows, and take the lowest level where no repeated column fields exist as the updated first level.

According to the embodiment of the application, the device further comprises a template generating module, wherein the tree structure comprises a header tree representing the hierarchical relation of the row fields corresponding to each row title and a column report item tree representing the hierarchical relation of the column fields corresponding to each column title, the target filling area comprises N cells, N is an integer greater than or equal to 1, the template generating module is used for taking the node code of the first final stage node in the header tree corresponding to the cells as the first code of the cells and taking the node code of the second final stage node in the column report item tree corresponding to the cells as the second code of the cells, so that the coordinates of each cell can be determined through the first code and the second code.

According to the embodiment of the application, the template generation module is further used for positioning each cell according to the first code and the second code, setting a data rule for each cell to execute corresponding processing operation on the data filled in the cell according to the data rule, wherein the data rule comprises at least one of a data format of the cell, a data processing rule of the cell and a data input rule of the cell.

Any of the field acquisition module 610, the tree generation module 620, the hierarchy determination module 630, the row association module 640, the report generation module 650, and the template generation module may be combined in one module to be implemented, or any of the modules may be split into a plurality of modules, according to an embodiment of the present application. Or at least some of the functionality of one or more of the modules may be combined with, and implemented in, at least some of the functionality of other modules. According to embodiments of the application, at least one of the field acquisition module 610, the tree generation module 620, the hierarchy determination module 630, the row association module 640, the report generation module 650, and the template generation module may be implemented at least in part as hardware circuitry, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system-on-chip, a system-on-substrate, a system-on-package, an Application Specific Integrated Circuit (ASIC), or as hardware or firmware in any other reasonable manner of integrating or packaging the circuitry, or as any one of or a suitable combination of three of software, hardware, and firmware. Or at least one of the field acquisition module 610, the tree generation module 620, the hierarchy determination module 630, the row association module 640, the report generation module 650, and the template generation module may be at least partially implemented as a computer program module which, when executed, may perform the corresponding functions.

Fig. 7 schematically shows a block diagram of an electronic device adapted to implement a report generating method according to an embodiment of the application.

As shown in fig. 7, an electronic device 700 according to an embodiment of the present application includes a processor 701 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 702 or a program loaded from a storage section 708 into a Random Access Memory (RAM) 703. The processor 701 may include, for example, a general purpose microprocessor (e.g., a CPU), an instruction set processor and/or an associated chipset and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), or the like. The processor 701 may also include on-board memory for caching purposes. The processor 701 may comprise a single processing unit or a plurality of processing units for performing different actions of the method flow according to an embodiment of the application.

In the RAM 703, various programs and data necessary for the operation of the electronic apparatus 700 are stored. The processor 701, the ROM 702, and the RAM 703 are connected to each other through a bus 704. The processor 701 performs various operations of the method flow according to an embodiment of the present application by executing programs in the ROM 702 and/or the RAM 703. Note that the program may be stored in one or more memories other than the ROM 702 and the RAM 703. The processor 701 may also perform various operations of the method flow according to embodiments of the present application by executing programs stored in the one or more memories.

According to an embodiment of the application, the electronic device 700 may further comprise an input/output (I/O) interface 705, the input/output (I/O) interface 705 also being connected to the bus 704. The electronic device 700 may also include one or more of an input portion 706 including a keyboard, mouse, etc., an output portion 707 including a Cathode Ray Tube (CRT), liquid Crystal Display (LCD), etc., and speaker, etc., a storage portion 708 including a hard disk, etc., and a communication portion 709 including a network interface card such as a LAN card, modem, etc., connected to the I/O interface 705. The communication section 709 performs communication processing via a network such as the internet. The drive 710 is also connected to the I/O interface 705 as needed. A removable medium 711 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 710 as necessary, so that a computer program read therefrom is mounted into the storage section 708 as necessary.

The present application also provides a computer-readable storage medium that may be included in the apparatus/device/system described in the above embodiments, or may exist alone without being assembled into the apparatus/device/system. The computer-readable storage medium carries one or more programs which, when executed, implement methods in accordance with embodiments of the present application.

According to embodiments of the application, the computer-readable storage medium may be a non-volatile computer-readable storage medium, which may include, for example, but is not limited to, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. For example, according to an embodiment of the application, the computer-readable storage medium may include ROM 702 and/or RAM 703 and/or one or more memories other than ROM 702 and RAM 703 described above.

Embodiments of the present application also include a computer program product comprising a computer program containing program code for performing the method shown in the flowcharts. The program code means for causing a computer system to carry out the method for recommending items provided by the embodiment of the application when the computer program product is run in the computer system.

The above-described functions defined in the system/apparatus of the embodiment of the present application are performed when the computer program is executed by the processor 701. The systems, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the application.

In one embodiment, the computer program may be based on a tangible storage medium such as an optical storage device, a magnetic storage device, or the like. In another embodiment, the computer program may also be transmitted, distributed over a network medium in the form of signals, downloaded and installed via the communication section 709, and/or installed from the removable medium 711. The computer program may comprise program code that is transmitted using any appropriate network medium, including but not limited to wireless, wireline, etc., or any suitable combination of the preceding.

In such an embodiment, the computer program may be downloaded and installed from a network via the communication portion 709, and/or installed from the removable medium 711. The above-described functions defined in the system of the embodiment of the present application are performed when the computer program is executed by the processor 701. The systems, devices, apparatus, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the application.

According to embodiments of the present application, program code for carrying out computer programs provided by embodiments of the present application may be written in any combination of one or more programming languages, and in particular, such computer programs may be implemented in high-level procedural and/or object-oriented programming languages, and/or in assembly/machine languages. Programming languages include, but are not limited to, such as Java, c++, python, "C" or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of remote computing devices, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., connected via the Internet using an Internet service provider).

The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

Those skilled in the art will appreciate that the features recited in the various embodiments of the application and/or in the claims may be combined in various combinations and/or combinations, even if such combinations or combinations are not explicitly recited in the application. In particular, the features recited in the various embodiments of the application and/or in the claims can be combined in various combinations and/or combinations without departing from the spirit and teachings of the application. All such combinations and/or combinations fall within the scope of the application.

The embodiments of the present application are described above. These examples are for illustrative purposes only and are not intended to limit the scope of the present application. Although the embodiments are described above separately, this does not mean that the measures in the embodiments cannot be used advantageously in combination. The scope of the application is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be made by those skilled in the art without departing from the scope of the application, and such alternatives and modifications are intended to fall within the scope of the application.

Claims (12)

1. A report generation method, comprising:

acquiring a field set of report data to be filled, wherein the field set comprises fields corresponding to all titles in the report data to be filled and hierarchical relations;

Extracting the hierarchical relation corresponding to each field in the field set, and constructing a tree structure;

traversing all fields under each level of the tree structure, and taking the lowest level without repeated fields as a target level;

For each target filling area in the report template, taking the target level and level fields corresponding to levels lower than the target level as level index fields of the target filling area, matching fields corresponding to data in the report data to be filled, and associating the matched data with the target filling area;

And filling the data associated with the target filling area into the target filling area to generate a report.

2. The method of claim 1, wherein the target filling area is a row in the report template, the matching the fields corresponding to each data in the report data to be filled, and associating the matched data with the target filling area, comprises:

For each line in the report template, taking the line as a first matching line, taking a level field of the target level corresponding to the first matching line as a first level index field, searching for a line corresponding to the first level index field in the report data to be filled, and constructing a candidate line set;

For each level lower than the target level, sequentially taking the level field of each level corresponding to the first matching line as a second level index field according to the level from high to low, searching the line corresponding to the second level index field in the candidate line set, and updating the candidate line set by using the searched line;

In the case that the candidate row set contains only one row, the row is taken as a second matching row, and the second matching row is associated with the first matching row.

3. The method of claim 2, wherein the associating the second matching row with the first matching row comprises:

and associating the row code of each data in the second matching row with the row code of each data in the first matching row.

4. The method of claim 1, wherein traversing all fields under each level of the tree structure, taking the lowest level where there are no duplicate column fields as the target level, comprises:

acquiring all fields under each level of the tree structure;

For each hierarchy, taking the hierarchy as a candidate hierarchy in the case that any two fields of the hierarchy are different;

and taking the lowest level in the candidate levels as the target level.

5. The method according to claim 1, wherein the method further comprises:

after the data associated with the target fill area is filled into the target fill area, the data associated with the target fill area is removed.

6. The method of claim 5, wherein the method further comprises:

Acquiring a residual filling area which is not associated with the report data to be filled in the report template;

And traversing all the fields under each level corresponding to the residual filling area, and taking the lowest level without repeated fields as an updated target level.

7. The method of claim 1, wherein the tree structure includes a header tree characterizing a hierarchical relationship of row fields corresponding to each row header and a column report item tree characterizing a hierarchical relationship of column fields corresponding to each column header, the target fill area includes N cells, N being an integer greater than or equal to 1, the method further comprising:

The node code of the first final node in the header tree corresponding to the cell is used as the first code of the cell, and the node code of the second final node in the column report item tree corresponding to the cell is used as the second code of the cell, so that the coordinates of each cell are determined through the first code and the second code.

8. The method of claim 7, wherein the method further comprises:

locating each of the cells according to the first code and the second code;

And setting a data rule for each cell so as to execute corresponding processing operation on the data filled in the cell according to the data rule, wherein the data rule comprises at least one of a data format of the cell, a data processing rule of the cell and a data input rule of the cell.

9. A report generating apparatus, comprising:

The system comprises a field acquisition module, a field analysis module and a report processing module, wherein the field acquisition module is used for acquiring a field set of report data to be filled, and the field set comprises fields and hierarchical relations corresponding to all titles in the report data to be filled;

the tree generation module is used for extracting the hierarchical relation corresponding to each field in the field set and constructing a tree structure;

The hierarchy determining module is used for traversing all the fields under each hierarchy of the tree structure, and taking the lowest hierarchy without repeated column fields as a target hierarchy;

a row association module for, for each target filling area in a report template, using the target level and level fields corresponding to levels lower than the target level as level index fields of the target filling area, matching fields corresponding to data in the report data to be filled and associating the matched data with the target filling area, wherein the report template is constructed based on the tree structure, and

And the report generation module is used for filling the data associated with the target filling area into the target filling area and generating a report.

10. An electronic device, comprising:

one or more processors;

Storage means for storing one or more programs,

Characterized by one or more programs, which when executed by the one or more processors, cause the one or more processors to perform the method of any of claims 1-8.

11. A computer readable storage medium having stored thereon executable instructions, which when executed by a processor cause the processor to perform the method according to any of claims 1-8.

12. A computer program product comprising a computer program, characterized in that the computer program, when executed by a processor, implements the method according to any of claims 1-8.