Report template generation method and related equipment

Abstract

The embodiment of the invention discloses report template generation and related equipment, which are used for generating a report template under the condition of improving the generation efficiency of the report template. The method comprises the steps that a report template user-defined interface is displayed, the report template user-defined interface comprises a data area table, a row header table and a column header table, the row header table and the column header table are located in areas outside the data area table, a first target row header area is determined in the row header table according to a first target data area selected in the data area table, and the first target row header area is used for displaying the report template user-defined interface. Determining a first target column header area in the column header table, and obtaining a first target row-column dimension combination of the Mth row and the Nth column of data cells of the first target data area by combining the Mth row of target dimension information and the Nth column of target dimension information, and generating a first target report template based on the first target data area and the first target row and column dimension combination of each first data cell in the first target data area.

Description

Technical Field

[0001] The embodiments of the present application relate to the field of report template generation, and more specifically, to a report template generation method, a report template generation device, a computer device, a computer-readable storage medium, and a computer program product containing instructions. Background Art

[0002] As business complexity and data volume grow, traditional reporting requirements become more diverse and sophisticated, which leads to challenges in report template design because the old methods cannot meet the needs of quickly generating and managing complex dimensional data.

[0003] The existing report template generation method is to set each data cell in the actual data area in the two-dimensional plane space to store multi-dimensional information, and then generate a report template based on the multi-dimensional information of each data cell. For example, if the report involves three dimensions (time, place and category), each data cell in the actual data area needs to store the dimensional information of the time, place and category dimensions.

[0004] However, in the existing report template generation method, each data cell needs to store dimensional information of all dimensions. When setting the multi-dimensional information of each data cell, a lot of information needs to be stored, and the efficiency of setting the multi-dimensional information of each data cell is low. Therefore, the generation efficiency of the report template is low. Summary of the invention

[0005] The embodiments of the present application provide a report template generation method, a report template generation device, a computer device, a computer-readable storage medium, and a computer program product containing instructions, which can generate a report template while improving the generation efficiency of the report template.

[0006] In a first aspect, an embodiment of the present application provides a method for generating a report template, comprising:

[0007] Displaying a report template customization interface, the report template customization interface includes a data area table, a row header table and a column header table, the row header table and the column header table are areas located outside the data area table, the row number of the data area table corresponds to the row number of the row header table, and the column number of the data area table corresponds to the column number of the column header table;

[0008] According to the first target data region selected in the data region table, determining in the row header table a first target row header region corresponding to a first row number of the first target data region, and determining in the column header table a first target column header region corresponding to a first column number of the first target data region;

[0009] After determining the M-th row target dimension information of the M-th row dimension cell of the first target row header region and the N-th column target dimension information of the N-th column dimension cell of the first target column header region, combining the M-th row target dimension information and the N-th column target dimension information to obtain a first target row and column dimension combination of the M-th row and N-th column data cell of the first target data region;

[0010] A first target report template is generated based on the first target data region and a first target row and column dimension combination of each first data cell in the first target data region.

[0011] In a second aspect, an embodiment of the present application provides a report template generation device, including:

[0012] A display unit, used to display a report template customization interface, wherein the report template customization interface includes a data area table, a row header table, and a column header table, wherein the row header table and the column header table are located in an area outside the data area table, wherein the row number of the data area table corresponds to the row number of the row header table, and the column number of the data area table corresponds to the column number of the column header table;

[0013] a determining unit, configured to determine, in the row header table, a first target row header region corresponding to a first row number of the first target data region, and to determine in the column header table a first target column header region corresponding to a first column number of the first target data region, according to the first target data region selected in the data region table;

[0014] a combining unit, configured to determine the Mth row target dimension information of the Mth row dimension cell of the first target row header region and the Nth column target dimension information of the Nth column dimension cell of the first target column header region, and then combine the Mth row target dimension information and the Nth column target dimension information to obtain a first target row and column dimension combination of the Mth row and Nth column data cell of the first target data region;

[0015] A generating unit is used to generate a first target report template based on the first target data region and a first target row and column dimension combination of each first data cell in the first target data region.

[0016] In a third aspect, an embodiment of the present application provides a computer device, including:

[0017] CPU, memory, input and output interfaces, wired or wireless network interfaces, and power supply;

[0018] The memory is either transient storage memory or persistent storage memory;

[0019] The central processing unit is configured to communicate with the memory and execute the instruction operation in the memory to execute the aforementioned report template generation method.

[0020] In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, which includes instructions. When the instructions are executed on a computer, the computer executes the aforementioned report template generation method.

[0021] In a fifth aspect, an embodiment of the present application provides a computer program product comprising instructions, which, when the computer program product is run on a computer, enables the computer to execute the aforementioned method for generating a report template.

[0022] It can be seen from the above technical solutions that the embodiments of the present application have the following advantages: the row header table and the column header table can be independently designed in the area outside the data area table, the row dimension member information can be stored in the row header table, and the column dimension member information can be stored in the column header table. Only the row and column numbers and the corresponding dimension member information can be stored, and less information needs to be stored when setting the multi-dimensional information of each data cell. The efficiency of setting the multi-dimensional information of each data cell is high, so the generation efficiency of the report template is high. Furthermore, the row header table and the column header table are independent of the data area table, and the row header table, the column header table and the data area table are linked in layout design, so that the generation of the report template will not affect the table sample information of the original main table, avoiding the destruction of the original table sample information and the displacement of the data cell position, and there is no need to perform various offset calculations on each data cell. The efficiency of setting the multi-dimensional information of each data cell is high, so the effect of what you see is what you get can be achieved, and the generation efficiency of the report template is further improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] Figure 1 A schematic diagram of the architecture of a report template generation system disclosed in an embodiment of the present application;

[0024] Figure 2 A flowchart of a method for generating a report template disclosed in an embodiment of the present application;

[0025] Figure 2-1 A schematic diagram of a report template customization interface disclosed in an embodiment of the present application;

[0026] Figure 2-2 A schematic diagram of a report template customization interface disclosed in the prior art;

[0027] Figure 2-3 A schematic diagram of another report template customization interface disclosed in the prior art;

[0028] Figure 2-4 A schematic diagram of a report template disclosed in the prior art;

[0029] Figure 3 A schematic diagram of a flow chart of generating another report template disclosed in an embodiment of the present application;

[0030] Figure 3-1 A schematic diagram of synchronously selecting a display mode in a report template customization interface disclosed in an embodiment of the present application;

[0031] Figure 3-2 A schematic diagram of a report template disclosed in an embodiment of the present application;

[0032] Figure 3-3 A schematic diagram of a target report disclosed in an embodiment of the present application;

[0033] Figure 4 A schematic diagram of a flow chart of generating another report template disclosed in an embodiment of the present application;

[0034] Figure 5 A schematic diagram of a flow chart of generating another report template disclosed in an embodiment of the present application;

[0035] Figure 6 A schematic diagram of the structure of a report template generating device disclosed in an embodiment of the present application;

[0036] Figure 7 A schematic diagram of the structure of a computer device disclosed in an embodiment of the present application. DETAILED DESCRIPTION

[0037] The embodiments of the present application provide a report template generation method, a report template generation device, a computer device, a computer-readable storage medium, and a computer program product containing instructions, which can generate a report template while improving the generation efficiency of the report template.

[0038] The present application can be applied to various information management systems, such as enterprise resource planning systems (ERP), tax systems, financial systems, human resources systems, supply chain systems, etc.

[0039] See also Figure 1 In the embodiment of the present application, a structure of a report template generation system 100 includes:

[0040] Computer device (device for generating report template) 101 and client (user) 102. When generating a report template, computer device 101 can be connected to client 102. Computer device 101 can obtain a report template generation request sent by client 102, can display a report template customization interface, determine a first target row header area in a row header table and a first target column header area in a column header table according to a first target data area selected in a data area table, and then obtain a first target row and column dimension combination of a data cell in the Mth row and the Nth column of the first target data area in combination with the target dimension information in the Mth row and the target dimension information in the Nth column, generate a first target report template based on the first target data area and the first target row and column dimension combination of each first data cell in the first target data area, and return the first target report template to client 102.

[0041] based on Figure 1 For the report template generation system shown in Figure 2 , Figure 2 The present invention is a flowchart of a method for generating a report template disclosed in an embodiment of the present invention, the method comprising:

[0042] 201. Display the report template customization interface. The report template customization interface includes a data area table, a row header table and a column header table. The row header table and the column header table are areas located outside the data area table. The row number of the data area table corresponds to the row number of the row header table, and the column number of the data area table corresponds to the column number of the column header table.

[0043] In this embodiment, when a report template is generated, a report template customization interface can be displayed. The report template customization interface includes a data area table, a row header table, and a column header table. The row header table and the column header table are located in an area outside the data area table. The row number of the data area table corresponds to the row number of the row header table, and the column number of the data area table corresponds to the column number of the column header table.

[0044] Specifically, "the row numbers of the data area table correspond to the row numbers of the row header table" may mean "the row numbers of the data area table are equal (the same) to the row numbers of the row header table", or it may mean "the row numbers of the data area table are not equal to the row numbers of the row header table, but there is a logical association and mapping relationship between the row numbers of the two". The understanding of "corresponding" in "the column numbers of the data area table correspond to the column numbers of the column header table" is similar to the understanding of "corresponding" in "the row numbers of the data area table correspond to the row numbers of the row header table", and will not be elaborated here.

[0045] For more details, please refer to Figure 2-1 , Figure 2-1 A schematic diagram of a report template customization interface disclosed in an embodiment of the present application, comprising Figure 2-1It can be seen that the row header table is the area located above the data area table, and the column header table is the area located to the left of the data area table. The data area table and the row header table involve the same row number, and for the same row number, the data in the data area table with the same row number corresponds one-to-one to the data in the row header table. The data area table and the column header table involve the same column number, and for the same column number, the data in the data area table with the same column number corresponds one-to-one to the data in the column header table.

[0046] It can be understood that the row header table can be located in the area below the data area table in addition to being located above the data area table, and the column header table can be located in the area to the right of the data area table in addition to being located to the left of the data area table. The row header table and the column header table can also be located in other reasonable areas outside the data area table, which are not specifically limited here.

[0047] 202. According to the first target data area selected in the data area table, determine in the row header table a first target row header area whose row number corresponds to the first row number of the first target data area, and determine in the column header table a first target column header area whose column number corresponds to the first column number of the first target data area.

[0048] After displaying the report template customization interface, you can determine the first target row header area whose row number corresponds to the first row number of the first target data area in the row header table, and determine the first target column header area whose column number corresponds to the first column number of the first target data area in the column header table, based on the first target data area selected in the data area table.

[0049] Specifically, the understanding of "corresponding" in "determining in the row header table the first target row header area corresponding to the first row number of the first target data area" and "determining in the column header table the first target column header area corresponding to the first column number of the first target data area" is similar to the understanding of "corresponding" in "the row number of the data area table corresponds to the row number of the row header table", and will not be elaborated here.

[0050] For more details, please continue to refer to Figure 2-1 ,Depend on Figure 2-1 It can be seen that after selecting the first target data area as (F7:L13) in the data area table, that is, the data cell range starting from the 7th row of the F column and ending at the 13th row of the L column, the first target row header area can be determined in the row header table as the row header cell range involved in the 7th row to the 13th row according to the selected first target data area (F7:L13), and the first target column header area can be determined in the column header table as the column header cell range involved in the F column to the L column.

[0051] 203. After determining the Mth row target dimension information of the Mth row dimension cell of the first target row header area and the Nth column target dimension information of the Nth column dimension cell of the first target column header area, the Mth row target dimension information and the Nth column target dimension information are combined to obtain the first target row and column dimension combination of the Mth row and Nth column data cell of the first target data area.

[0052] According to the first target data area, after the row header table determines the first target row header area, and the column header table determines the first target column header area, the M-th row target dimension information of the M-th row dimension cell of the first target row header area and the N-th column target dimension information of the N-th column dimension cell of the first target column header area can be determined, and then the M-th row target dimension information and the N-column target dimension information are combined to obtain the first target row and column dimension combination of the M-th row and N-th column data cell of the first target data area.

[0053] For details, please continue to refer to Figure 2-1 ,Depend on Figure 2-1 It can be seen that, for example, the target dimension information of the 7th row of the dimension cell in the 7th row of the first target row header area, "Subject A, budget number" (involving the "Subject" dimension member and the "Data Type" dimension member), and the target dimension information of the Fth column of the dimension cell in the Fth column of the first target column header area, "2024, January" (involving the "Fiscal Year" dimension member and the "Period" dimension member), can be determined. Then, the target dimension information of the 7th row "Subject A, budget number" and the target dimension information of the Fth column "2024, January" are combined to obtain the first target row and column dimension combination of "Subject A, budget number, 2024, January" of the data cell in the 7th row and the Fth column of the first target data area.

[0054] Specifically, the embodiment of the present application only needs to store the row number and the dimension member information corresponding to the row number, and does not need to store the dimension member information combination (row and column dimension combination) of each data cell. For example, the dimension members corresponding to row number 7 are "Account A" and "Budget information", which can be stored in code, such as: row7 = (AcctA, Budget), and the column storage information is similar to the row, such as column6 = (Y2024, M01). It can be understood that in addition to the storage structure of the dimension member settings in the row / column header table described above, other reasonable storage structures can also be used, which are not specifically limited here.

[0055] It should be understood that for an existing report template generation method (each data cell needs to store complete row and column dimension combination information), please refer to Figure 2-2 , Figure 2-2 A schematic diagram of a report template customization interface disclosed in the prior art, comprising Figure 2-2It can be seen that in the existing report template generation method, each data cell needs to store the dimensional information of all dimensions. For example, each data cell needs to contain 4 dimensional member information. Assuming that each dimensional member information storage space occupies 1 storage unit, the existing report template generation method stores 10*10=100 cells of table information. It requires 100*4=400 storage units, while the embodiment of the present application can only store the row and column numbers and the corresponding dimensional member information. The embodiment of the present application only needs to store information in the row / column header table, which only requires 10*2+10*2=40 storage units.

[0056] It is worth mentioning that the embodiment of the present application can store only the row and column numbers and the corresponding dimension member information. The row and column dimension combination information corresponding to the row and column intersection is the complete dimension combination information, so that the position information of the dimension members in the storage structure can be accurately mapped to the position information of the data cell. While ensuring the accuracy of the mapping, the information storage density is greatly improved, the information required to be stored is less, and the information storage space is saved, thereby improving the efficiency of report template generation.

[0057] It is also worth mentioning that the embodiment of the present application introduces independent row header and column header tables for auxiliary settings in the process of setting the report template area. By using the additional space (row / column header table) to perform multi-dimensional space mapping within a data cell on the original table (data area table), it is possible to set the multiple dimensions of a data cell at one time in the same plane space, thereby avoiding the cumbersome process of invoking and setting the multi-dimensional members one by one in a data cell in the existing report template generation method (that is, each multi-dimensional element needs to be processed separately on the interface), thereby improving the efficiency of determining the target row and column dimension combination of each data cell in the target data area, thereby improving the efficiency of report template generation.

[0058] It is also worth mentioning that the embodiment of the present application sets up the column / row header table in such a way that the change of the setting interface will not affect the table sample information of the original main table, and can also avoid the destruction of the original table sample information and the displacement of the data cell position, thereby achieving a WYSIWYG effect. Figure 2-3 , Figure 2-3 A schematic diagram of another report template customization interface disclosed in the prior art (with a cell position offset problem) is shown. Figure 2-3 It can be seen that although the row / column header area can be expanded (green cells) in the original data area (area in the data area table) and the member information of the data dimension can be stored in the expanded cells, the report template finally generated is not the report template set for preview, and the data cell position is offset. For details, please refer to Figure 2-4 , Figure 2-4A schematic diagram of a report template (with a cell position offset problem) disclosed in the prior art, comprising Figure 2-4 It can be seen that the position of the data cell has shifted, and the original table sample will be destroyed, resulting in errors in the actual report data retrieval, such as errors in setting Excel formulas containing position information, such as the Excel formula set in the template to get the value of a certain cell, and because the position of the cell has shifted after the original table sample is inserted into rows and columns, it leads to errors in the actual report data retrieval. In order to avoid accuracy in the actual report data retrieval, the prior art may require additional calculations of various offset positions when determining the target row and column dimension combination of each data cell in the target data area, but this will result in low efficiency in determining the target row and column dimension combination of each data cell, resulting in low efficiency in generating the report template. In summary, the embodiment of the present application generates a report template by additionally setting the column / row header table, and the change of its setting interface will not affect the table sample information of the original main table, avoiding the destruction of the original table sample information and the shift of the data cell position, achieving a what-you-see-is-what-you-get effect, and improving the generation efficiency of the report template.

[0059] 204. Generate a first target report template based on the first target data region and the first target row and column dimension combination of each first data cell in the first target data region.

[0060] After obtaining the first target row and column dimension combination of the data cell in the Mth row and Nth column of the first target data area by combining the target dimension information of the Mth row and the target dimension information of the Nth column, a first target report template can be generated based on the first target data area and the first target row and column dimension combination of each first data cell in the first target data area.

[0061] Specifically, a first target report template can be generated based on the first target data area (F7: L13) and the first target row and column dimension combination of each first data cell in the first target data area, so that when a trigger signal for generating a first target report based on the first target report template is detected, the first target data corresponding to the first target row and column dimension combination of each first data cell is obtained and displayed in each first data cell. For example, the first target data corresponding to the first target row and column dimension combination of the data cell in the 7th row and the Fth column "Subject A, budget number, 2024, January" is 700 (yuan), etc., so that the first target report can be obtained.

[0062] Among them, after the first target report template is generated, when a trigger signal for generating the first target report based on the first target report template is detected, the first target data corresponding to the first target row and column dimension combination of each first data cell can be obtained and displayed in each first data cell to obtain the first target report.

[0063] Specifically, when a trigger signal for generating a first target report based on a first target report template is detected, the first target row and column dimension combination of each first data cell can be parsed, that is, the first target row and column dimension combination of each first data cell can be formatted to obtain the first target row and column dimension combination of the target format (the format used to obtain data from the data source) of each first data cell, and then based on the first target row and column dimension combination of the target format of each first data cell, the first target data corresponding to the first target row and column dimension combination of each first data cell is obtained and displayed in each first data cell to obtain the first target report.

[0064] It is worth mentioning that the embodiment of the present application can store only the row and column numbers and the corresponding dimensional member information. Less information needs to be stored when setting the multi-dimensional information of each data cell. Therefore, the computational loss required to parse the first target row and column dimensional combination of each first data cell is low, which can save resources.

[0065] In an embodiment of the present application, a row header table and a column header table can be independently designed in an area outside the data area table. The row dimension member information is stored in the row header table, and the column dimension member information is stored in the column header table. Only the row and column numbers and the corresponding dimension member information may be stored. Less information needs to be stored when setting the multi-dimensional information of each data cell, and the efficiency of setting the multi-dimensional information of each data cell is higher. Therefore, the report template generation efficiency is higher. Furthermore, the row header table and column header table are independent of the data area table, and the row header table, column header table and data area table are designed to be linked in layout (i.e., "the row number of the data area table corresponds to the row number of the row header table, the column number of the data area table corresponds to the column number of the column header table", and "according to the first target data area selected in the data area table, the first target row header area whose row number corresponds to the first row number of the first target data area is determined in the row header table, and the first target column header area whose column number corresponds to the first column number of the first target data area is determined in the column header table"), so that the generation of the report template will not affect the table sample information of the original main table, avoids the destruction of the original table sample information and the displacement of the data cell position, and does not need to perform various offset calculations on each data cell. The efficiency of setting the multi-dimensional information of each data cell is high. Therefore, the WYSIWYG effect can be achieved, and the generation efficiency of the report template is further improved. Secondly, only the row and column numbers and the corresponding dimensional member information can be stored, and less information needs to be stored when setting the multi-dimensional information of each data cell. Therefore, the computational loss required to parse the first target row and column dimensional combination of each first data cell is low, which can save resources.

[0066] based on Figure 2On the basis of the corresponding embodiment, in order to improve the efficiency of determining the target dimension information of the Mth row and the target dimension information of the Nth column, thereby further improving the efficiency of generating the report template, it can be determined through the row and column dimension configuration interface, or the user directly enters information in the Mth row dimension cell in the first target row header area and the Nth column dimension cell in the first target column header area. For specific implementation methods, please refer to the following descriptions respectively:

[0067] Among them, the method for determining the Mth row target dimension information of the Mth row dimension cell of the first target row header area, and the Nth column target dimension information of the Nth column dimension cell of the first target column header area may be, if a trigger signal for row dimension configuration of the first target row header area and column dimension configuration of the target column header area is detected, then the row and column dimension configuration interface is first displayed, the row and column dimension configuration interface includes at least one preset row dimension and at least one preset column dimension, and then at least one target row dimension and at least one target column dimension selected by the user from at least one preset row dimension and at least one preset column dimension are obtained, and the Mth row target dimension information and the Nth column target dimension information are determined based on the at least one target row dimension and the at least one target column dimension.

[0068] Specifically, the preset row dimensions and the preset column dimensions can be determined by the original table sample entered by the user in the data area table (including but limited to textual descriptions "such as table name, row / column header information, etc.", background color fill, corporate graphic logo, etc.). For example, if the original table sample entered by the user is "Subject A, Subject B, Subject C, January, February, March, 2024, 2024, 2024...", then dimension members of "Subject", "Period" and "Fiscal Year" can be generated; the preset row dimensions and the preset column dimensions can also be determined based on the required or commonly used row dimensions and column dimensions involved in the historical report template, or can be determined by other reasonable methods, which are not limited here.

[0069] Among them, the method for determining the Mth row target dimension information of the Mth row dimension cell of the first target row header area, and the Nth column target dimension information of the Nth column dimension cell of the first target column header area can also be to obtain the Mth row target dimension information entered by the user in the Mth row dimension cell of the first target row header area, and the Nth column target dimension information entered by the user in the Nth column dimension cell of the first target column header area.

[0070] Specifically, the user can directly enter "Subject A" as the Mth row target dimension information in the Mth row dimension cell of the first target row header area, and directly enter "2024, January" as the Nth column target dimension information in the Nth column dimension cell of the first target column header area.

[0071] It can be understood that, in addition to the method for determining the target dimension information of the Mth row and the target dimension information of the Nth column described above, other reasonable methods may be used, which are not specifically limited here.

[0072] It is worth mentioning that the efficiency of determining the target dimension information of the Mth row and the Nth column can be improved by using the row and column dimension configuration interface, or by the user directly entering information in the Mth row dimension cell of the first target row header area and the Nth column dimension cell of the first target column header area. This can further improve the efficiency of generating report templates.

[0073] based on Figure 2 In the described embodiment, during the process of generating a report template, although less information needs to be stored when setting the multi-dimensional information of each data cell, and the row header table and column header table are independent of the data area table, and the design of the linked layout of the row header table, column header table and data area table can achieve a WYSIWYG effect, and further improve the efficiency of generating report templates, there is still often a problem of low efficiency in determining the target dimension information of the Mth row and the target dimension information of the Nth column, which leads to low efficiency in generating report templates. In order to solve the above problems, the following provides a detailed embodiment that can be optionally executed during the implementation of this solution, please refer to Figure 3 , Figure 3 This is a flow chart of another method for generating a report template disclosed in an embodiment of the present application. Another embodiment of the method for generating a report template of the present application includes:

[0074] 301. Display the report template customization interface. The report template customization interface includes a data area table, a row header table and a column header table. The row header table and the column header table are located in an area outside the data area table. The row number of the data area table corresponds to the row number of the row header table, and the column number of the data area table corresponds to the column number of the column header table. The row header table is located in the area to the left or right of the data area table, and the column header table is located in the area above or below the data area table.

[0075] Step 301 in this embodiment is similar to the aforementioned Figure 2 Step 201 in the illustrated embodiment is similar and will not be described again here.

[0076] For details, please refer to Figure 3-1 , Figure 3-1 A schematic diagram of synchronously selecting a display mode in a report template customization interface disclosed in an embodiment of the present application, comprising Figure 3-1 It can be seen that the row header table is located in the area to the left of the data area table, and the column header table is located in the area above the data area table.

[0077] 302. According to the first target data area selected in the data area table, determine in the row header table a first target row header area whose row number corresponds to the first row number of the first target data area, and determine in the column header table a first target column header area whose column number corresponds to the first column number of the first target data area.

[0078] Step 302 in this embodiment is similar to the aforementioned Figure 2 Step 202 in the illustrated embodiment is similar and will not be described in detail here.

[0079] 303. Based on the data cell of the Mth row and the Nth column selected in the first target data area, the dimension cell of the Mth row is synchronously selected and displayed in the first target row header area, and the dimension cell of the Nth column is synchronously selected and displayed in the first target column header area, and the dimension information of the Mth row and the Nth column determined by the user are obtained in the synchronously selected and displayed dimension cells of the Mth row and the Nth column.

[0080] For details, please continue to refer to Figure 3-1 ,Depend on Figure 3-1 It can be seen that when the data cell in the 7th row and the Fth column is selected, the dimension cell in the 7th row can be synchronously selected and displayed in the first target row header area, and the dimension cell in the Fth column can be synchronously selected and displayed in the first target column header area.

[0081] It is worth mentioning that the row header table and column header table can be set in a tiled manner. This tiled setting method can realize the dynamic linkage of synchronous selection and display of data cells, row dimension cells and column dimension cells. Storing dimension member information in a dynamic linkage manner can improve the efficiency of determining the target dimension information of the Mth row and the target dimension information of the Nth column, thereby further improving the efficiency of report template generation.

[0082] 304. Combine the target dimension information of the Mth row and the target dimension information of the Nth column to obtain a first target row and column dimension combination of the data cell of the Mth row and the Nth column of the first target data region.

[0083] 305. Generate a first target report template based on the first target data region and the first target row and column dimension combination of each first data cell in the first target data region.

[0084] Steps 304 to 305 in this embodiment are similar to those in the previous Figure 2 The related steps involved in steps 203 to 204 in the illustrated embodiment are similar and will not be described in detail here.

[0085] For details, please refer to Figure 3-2 , Figure 3-2 A schematic diagram of a report template disclosed in an embodiment of the present application, comprising Figure 3-2It can be seen that when the multi-dimensional information setting of the data cell is completed (such as triggered by clicking the Save and Return button), the auxiliary row header table and column header table can be collapsed, and the position mapping relationship of each data cell (multi-dimensional information, that is, multi-dimensional member combination) can be saved. For details, please refer to Figure 3-3 , Figure 3-3 A schematic diagram of a target report disclosed in an embodiment of the present application, comprising Figure 3-3 It can be seen that when presenting the target report, the data corresponding to the multidimensional member combination can be loaded from the data storage system (such as a database) and refreshed to the data cells corresponding to the row and column numbers according to the multidimensional member combination of each data cell in the report template. For example, the first target row and column dimension combination "Subject A, budget number, 2024, January" of the data cell in the 7th row and the Fth column corresponds to the first target data of 700 (yuan), etc., so that the first target report can be obtained.

[0086] In an embodiment of the present application, a row header table and a column header table can be independently designed in an area outside the data area table, and row dimension member information can be stored in the row header table, and column dimension member information can be stored in the column header table. Only row and column numbers and corresponding dimension member information can be stored, and less information needs to be stored when setting the multi-dimensional information of each data cell. The efficiency of setting the multi-dimensional information of each data cell is high, and therefore, the generation efficiency of the report template is high. Furthermore, the row header table and the column header table are independent of the data area table, and the row header table, the column header table and the data area table are linked in layout design, so that the generation of the report template will not affect the table sample information of the original main table, avoiding the destruction of the original table sample information and the displacement of the data cell position, and there is no need to perform various offset calculations on each data cell, and the efficiency of setting the multi-dimensional information of each data cell is high, so that a what-you-see-is-what-you-get effect can be achieved, and the generation efficiency of the report template is further improved. Secondly, only the row and column numbers and the corresponding dimension member information can be stored. Less information needs to be stored when setting the multi-dimensional information of each data cell. Therefore, the computational loss required to parse the first target row and column dimension combination of each first data cell is low, which can save resources. Next, the row header table and the column header table can be set in a tiled manner. This tiled setting method can realize the dynamic linkage of synchronous selection and display of data cells, row dimension cells, and column dimension cells. Storing dimension member information in a dynamic linkage manner can improve the efficiency of determining the target dimension information of the Mth row and the target dimension information of the Nth column, thereby further improving the efficiency of generating report templates.

[0087] based on Figure 2In the described embodiment, during the process of generating a report template, although less information needs to be stored when setting the multi-dimensional information of each data cell, and the row header table and column header table are independent of the data area table, and the design of the linked layout of the row header table, column header table and data area table can achieve a what-you-see-is-what-you-get effect, and further improve the efficiency of generating report templates, when it is necessary to generate multiple report templates, there are still problems due to various limiting factors, resulting in low generation accuracy of multiple report templates (for example, there is overlap between the generated multiple report templates) and / or low generation efficiency of multiple report templates. In order to solve the above problems, the following provides a detailed embodiment that can be optionally executed during the implementation of this solution, please refer to Figure 4 , Figure 4 This is a flow chart of another method for generating a report template disclosed in an embodiment of the present application. A method of another embodiment of a method for generating a report template of the present application includes:

[0088] 401. Display the report template customization interface. The report template customization interface includes a data area table, a row header table and a column header table. The row header table and the column header table are located in an area outside the data area table. The row number of the data area table corresponds to the row number of the row header table, and the column number of the data area table corresponds to the column number of the column header table.

[0089] 402. According to the first target data area selected in the data area table, determine in the row header table a first target row header area whose row number corresponds to the first row number of the first target data area, and determine in the column header table a first target column header area whose column number corresponds to the first column number of the first target data area.

[0090] 403. After determining the Mth row target dimension information of the Mth row dimension cell of the first target row header area and the Nth column target dimension information of the Nth column dimension cell of the first target column header area, the Mth row target dimension information and the Nth column target dimension information are combined to obtain the first target row and column dimension combination of the Mth row and Nth column data cell of the first target data area.

[0091] 404. Generate a first target report template based on the first target data region and the first target row and column dimension combination of each first data cell in the first target data region.

[0092] Steps 401 to 404 in this embodiment are similar to those in the previous Figure 2 Steps 201 to 204 in the illustrated embodiment are similar and will not be described in detail herein.

[0093] 405. According to the second target data area selected in the data area table, a second target row header area whose row number corresponds to the second row number of the second target data area is determined in the row header table, and a second target column header area whose column number corresponds to the second column number of the second target data area is determined in the column header table, wherein the second row number is different from the first row number, and the second column number is different from the first column number.

[0094] After displaying the report template customization interface, you can determine the second target row header area whose row number corresponds to the second row number of the second target data area in the row header table, and determine the second target column header area whose column number corresponds to the second column number of the second target data area in the column header table, based on the second target data area selected in the data area table. The second row number is different from the first row number, and the second column number is different from the first column number.

[0095] Specifically, for example, assuming that the first target data area is (F7:L13), the first row numbers involved are the 7th to the 13th row, and the first column numbers involved are the Fth to the Lth column; the second target data area is (M15:P20), the second row numbers involved are the 15th to the 20th row, and the second column numbers involved are the Mth to the Pth column.

[0096] It is worth mentioning that in the data area table, the second target data area can be selected in addition to the first target data area, and the multi-dimensional member combination of each data cell in the second target data area can be set, which can avoid inaccuracies such as overlap of multiple generated report templates, and can achieve the effect of generating multiple report templates in one interface (report template customization interface) The multi-dimensional member combination of data cells can be set, and the generation efficiency of multiple report templates can be improved.

[0097] 406. After determining the P-th row target dimension information of the P-th row dimension cell of the second target row header area and the Q-th column target dimension information of the Q-th column dimension cell of the second target column header area, the P-th row target dimension information and the Q-th column target dimension information are combined to obtain the second target row and column dimension combination of the P-th row and Q-th column data cells of the second target data area.

[0098] According to the selected second target data area, after the second target row header area is determined in the row header table and the second target column header area is determined in the column header table, the P-th row target dimension information of the P-th row dimension cell of the second target row header area and the Q-th column target dimension information of the Q-th column dimension cell of the second target column header area can be determined, and then the P-th row target dimension information and the Q-th column target dimension information are combined to obtain the second target row and column dimension combination of the P-th row and Q-th column data cells of the second target data area.

[0099] 407. Generate a second target report template based on the second target data area and the second target row and column dimension combination of each second data cell in the second target data area.

[0100] After obtaining the second target row and column dimension combination of the data cells in the Pth row and Qth column of the second target data area by combining the target dimension information of the Pth row and the Qth column, a second target report template can be generated based on the second target data area and the second target row and column dimension combination of each second data cell in the second target data area.

[0101] Among them, after the second target report template is generated, when a trigger signal for generating a second target report based on the second target report template is detected, the second target data corresponding to the second target row and column dimension combination of each second data cell can be obtained and displayed in each second data cell to obtain the second target report.

[0102] Specifically, the logic for generating the second target report template and the second target report is similar to the logic for generating the first target report template and the first target report. For specific examples of generating the second target report template and the second target report, please refer to the examples of generating the first target report template and the first target report, which will not be repeated here.

[0103] In an embodiment of the present application, a row header table and a column header table can be independently designed in an area outside the data area table, and row dimension member information can be stored in the row header table, and column dimension member information can be stored in the column header table. Only row and column numbers and corresponding dimension member information can be stored, and less information needs to be stored when setting the multi-dimensional information of each data cell. The efficiency of setting the multi-dimensional information of each data cell is high, and therefore, the generation efficiency of the report template is high. Furthermore, the row header table and the column header table are independent of the data area table, and the row header table, the column header table and the data area table are linked in layout design, so that the generation of the report template will not affect the table sample information of the original main table, avoiding the destruction of the original table sample information and the displacement of the data cell position, and there is no need to perform various offset calculations on each data cell, and the efficiency of setting the multi-dimensional information of each data cell is high, so that a what-you-see-is-what-you-get effect can be achieved, and the generation efficiency of the report template is further improved. Secondly, only the row and column numbers and the corresponding dimension member information can be stored, and less information needs to be stored when setting the multi-dimensional information of each data cell. Therefore, the calculation loss required for parsing the first target row and column dimension combination of each first data cell and the second target row and column dimension combination of each second data cell is low, which can save resources. Then, in the data area table, the area of ​​the first target data area can be removed, and the second target data area can be selected and the multi-dimensional member combination of each data cell in the second target data area can be set. This can avoid the overlap of multiple generated report templates and other inaccuracies, and can achieve the effect of generating multiple report templates simultaneously in one interface, thereby improving the generation efficiency of multiple report templates.

[0104] based on Figure 2 In the described embodiment, during the process of generating a report template, although less information needs to be stored when setting the multi-dimensional information of each data cell, and the row header table and the column header table are independent of the data area table, and the design of the linked layout of the row header table, the column header table and the data area table can achieve a what-you-see-is-what-you-get effect, and further improve the efficiency of generating the report template, but in actual application, there are often scenarios where the report template needs to be modified midway, and there is often a situation where the modification efficiency of the report template is low, resulting in the problem of low efficiency in generating the report template. In order to solve the above problem, the following provides a detailed embodiment that can be optionally executed during the implementation of this solution, please refer to Figure 5 , Figure 5 This is a flow chart of another method for generating a report template disclosed in an embodiment of the present application. A method of another embodiment of a method for generating a report template of the present application includes:

[0105] 501. Display the report template customization interface. The report template customization interface includes a data area table, a row header table and a column header table. The row header table and the column header table are located in an area outside the data area table. The row number of the data area table corresponds to the row number of the row header table, and the column number of the data area table corresponds to the column number of the column header table.

[0106] 502. According to the first target data area selected in the data area table, determine in the row header table a first target row header area whose row number corresponds to the first row number of the first target data area, and determine in the column header table a first target column header area whose column number corresponds to the first column number of the first target data area.

[0107] 503. Determine the Mth row initial dimension information of the Mth row dimension cell in the first target row header region, and the Nth column initial dimension information of the Nth column dimension cell in the first target column header region.

[0108] Steps 501 to 502 in this embodiment are similar to those in the previous Figure 2 The related steps involved in steps 201 to 203 in the illustrated embodiment are similar and will not be described in detail here.

[0109] 504. Modify the initial dimension information of the Mth row and the initial dimension information of the Nth column to obtain modified initial dimension information of the Mth row and modified initial dimension information of the Nth column. The modified initial dimension information of the Mth row is the target dimension information of the Mth row, and the modified initial dimension information of the Nth column is the target dimension information of the Nth column.

[0110] The method of modifying the initial dimension information of the Mth row and the initial dimension information of the Nth column to obtain the modified initial dimension information of the Mth row and the modified initial dimension information of the Nth column may include but is not limited to the following two methods:

[0111] (1) Delete or add the target M-th row sub-dimension and the initial sub-dimension information of the target M-th row sub-dimension, as well as the target N-th column sub-dimension and the initial sub-dimension information of the target N-th column sub-dimension.

[0112] Among them, the method for deleting or adding the target M-th row sub-dimension, the initial sub-dimension information of the target M-th row sub-dimension, and the target N-th column sub-dimension, the initial sub-dimension information of the target N-th column sub-dimension can be, first, deleting or adding the target M-th row sub-dimension and the initial sub-dimension information of the target M-th row sub-dimension to the M-th row initial dimension information, to obtain the deleted or added M-th row initial dimension information, the deleted or added M-th row initial dimension information is the modified M-th row initial dimension information, and then deleting or adding the target N-th column sub-dimension and the initial sub-dimension information of the target N-th column sub-dimension to the N-th column target dimension information, to obtain the deleted or added N-th column target dimension information, the deleted or added N-th column initial dimension information is the modified N-th column target dimension information, the M-th row dimension cell includes multiple M-th row sub-dimensions, the M-th row initial dimension information includes multiple M-th row sub-dimension initial sub-dimension information, the N-th column initial dimension information includes multiple N-th column sub-dimensions, and the N-th column initial dimension information includes multiple N-th column sub-dimension initial sub-dimension information.

[0113] Specifically, for example, if the initial dimension information of the row includes two dimension members, "Subject" and "Data Type", you can delete the dimension member "Data Type", and the modified column target dimension information will only include the dimension member "Subject". You can also add dimension members to the initial dimension information of the row, which will not be repeated here, and you can also delete or add dimension members to the initial dimension information of the column, which will not be repeated here.

[0114] (2) Modify the field value of the initial dimension field in the Mth row and / or the initial dimension field in the Mth row, and the field value of the initial dimension field in the Nth column and the initial dimension field in the Nth column.

[0115] Among them, the method for modifying the field value of the initial dimension field of the Mth row and / or the initial dimension field of the Mth row, and the field value of the initial dimension field of the Nth column and the initial dimension field of the Nth column can be, first modify the field value of the initial dimension field of the Mth row and / or the initial dimension field of the Mth row to obtain the modified field value of the initial dimension field of the Mth row and / or the initial dimension field of the Mth row, the field value of the modified initial dimension field of the Mth row and / or the initial dimension field of the Mth row is the modified initial dimension information of the Mth row, and then modify the field value of the initial dimension field of the Nth column and the initial dimension field of the Nth column to obtain the modified field value of the initial dimension field of the Nth column and the initial dimension field of the Nth column, the field value of the modified initial dimension field of the Nth column and the initial dimension field of the Nth column is the modified initial dimension information of the Nth column, the initial dimension information of the Mth row includes the field value of the initial dimension field of the Mth row and the initial dimension field of the Mth row, and the initial dimension information of the Nth column includes the field value of the initial dimension field of the Nth column and the initial dimension field of the Nth column.

[0116] Specifically, for example, the row initial dimension field "Period" can be modified to "Period / Month / Day", and the field values ​​of the row initial dimension fields "January", "February", "March", etc. can be modified to "January 1st", "February 1st", "March 1st", etc. respectively. The column initial dimension fields and / or the field values ​​of the column initial dimension fields can also be modified, which will not be repeated here.

[0117] It is worth mentioning that the initial dimension information of the Mth row and the initial dimension information of the Nth column can be modified to cover various modification scenario requirements by deleting or adding the target Mth row / column sub-dimension, the initial sub-dimension information of the target Mth row / column sub-dimension, and modifying the Mth row / column initial dimension field and / or the field value of the Mth row / column initial dimension field. This can provide a more comprehensive modification and directly modify a small amount of dimension information in the row / column header table, thereby improving the modification efficiency of the report template and, therefore, further improving the generation efficiency of the report template.

[0118] 505. Combine the target dimension information of the Mth row and the target dimension information of the Nth column to obtain a first target row and column dimension combination of the data cell of the Mth row and the Nth column of the first target data region.

[0119] 506. Generate a first target report template based on the first target data area and the first target row and column dimension combination of each first data cell in the first target data area, so that when a trigger signal for generating a first target report based on the first target report template is detected, first target data corresponding to the first target row and column dimension combination of each first data cell is obtained and displayed in each first data cell to obtain the first target report.

[0120] Steps 505 to 506 in this embodiment are similar to those in the previous Figure 2 The related steps involved in steps 203 to 204 in the illustrated embodiment are similar and will not be described in detail here.

[0121] In an embodiment of the present application, a row header table and a column header table can be independently designed in an area outside the data area table, and row dimension member information can be stored in the row header table, and column dimension member information can be stored in the column header table. Only row and column numbers and corresponding dimension member information can be stored, and less information needs to be stored when setting the multi-dimensional information of each data cell. The efficiency of setting the multi-dimensional information of each data cell is high, and therefore, the generation efficiency of the report template is high. Furthermore, the row header table and the column header table are independent of the data area table, and the row header table, the column header table and the data area table are linked in layout design, so that the generation of the report template will not affect the table sample information of the original main table, avoiding the destruction of the original table sample information and the displacement of the data cell position, and there is no need to perform various offset calculations on each data cell, and the efficiency of setting the multi-dimensional information of each data cell is high, so that a what-you-see-is-what-you-get effect can be achieved, and the generation efficiency of the report template is further improved. Secondly, only the row and column numbers and the corresponding dimension member information can be stored, and less information needs to be stored when setting the multi-dimensional information of each data cell. Therefore, the computational loss required to parse the first target row and column dimension combination of each first data cell is low, which can save resources. Then, the initial dimension information of the Mth row and the initial dimension information of the Nth column can be modified to cover various modification scenario requirements, which can provide a more comprehensive modification and can directly modify a small amount of dimension information in the row / column header table, thereby improving the modification efficiency of the report template, thereby further improving the generation efficiency of the report template.

[0122] The above describes the method for generating a report template in the embodiment of the present application. The following describes the device for generating a report template in the embodiment of the present application. Figure 6 , an embodiment of a report template generation device in an embodiment of the present application includes:

[0123] A display unit, used to display a report template customization interface, wherein the report template customization interface includes a data area table, a row header table, and a column header table, wherein the row header table and the column header table are areas located outside the data area table, wherein the row number of the data area table corresponds to the row number of the row header table, and the column number of the data area table corresponds to the column number of the column header table;

[0124] a determining unit, configured to determine, in the row header table, a first target row header region corresponding to a first row number of the first target data region, and to determine in the column header table a first target column header region corresponding to a first column number of the first target data region, according to the first target data region selected in the data region table;

[0125] a combining unit, configured to determine the Mth row target dimension information of the Mth row dimension cell of the first target row header region and the Nth column target dimension information of the Nth column dimension cell of the first target column header region, and then combine the Mth row target dimension information and the Nth column target dimension information to obtain a first target row and column dimension combination of the Mth row and Nth column data cell of the first target data region;

[0126] A generating unit is used to generate a first target report template based on the first target data region and a first target row and column dimension combination of each first data cell in the first target data region.

[0127] The report template generating device also includes:

[0128] a synchronous selection and display unit, for synchronously selecting and displaying the Mth row of dimension cells in the first target row header area and the Nth column of dimension cells in the first target column header area according to the data cell of the Mth row and the Nth column selected in the first target data area; the row header table is located in the area to the left or right of the data area table, and the column header table is located in the area above or below the data area table;

[0129] The combining unit is specifically used to obtain the Mth row dimension information and the Nth column dimension information determined by the user in the Mth row dimension cell and the Nth column dimension cell that are synchronously selected and displayed.

[0130] The combining unit is specifically used to display a row and column dimension configuration interface if a trigger signal for configuring the row dimension of the first target row header area and the column dimension of the target column header area is detected, and the row and column dimension configuration interface includes at least one preset row dimension and at least one preset column dimension, obtain at least one target row dimension and at least one target column dimension selected by the user from the at least one preset row dimension and the at least one preset column dimension, and determine the Mth row target dimension information and the Nth column target dimension information based on the at least one target row dimension and the at least one target column dimension; and / or obtain the Mth row target dimension information entered by the user in the Mth row dimension cell of the first target row header area, and the Nth column target dimension information entered in the Nth column dimension cell of the first target column header area.

[0131] The determining unit is further configured to determine, in the row header table, a second target row header region corresponding to a second row number of the second target data region, and determine, in the column header table, a second target column header region corresponding to a second column number of the second target data region, according to the second target data region selected in the data region table, wherein the second row number is different from the first row number, and the second column number is different from the first column number;

[0132] The combining unit is further configured to determine the P-th row target dimension information of the P-th row dimension cell of the second target row header region and the Q-th column target dimension information of the Q-th column dimension cell of the second target column header region, and then combine the P-th row target dimension information and the Q-th column target dimension information to obtain a second target row and column dimension combination of the P-th row and Q-th column data cell of the second target data region;

[0133] The generating unit is further configured to generate a second target report template based on the second target data region and a second target row and column dimension combination of each second data cell in the second target data region.

[0134] The determining unit is further used to determine the initial dimension information of the Mth row of the Mth row dimension cell of the first target row header region, and the initial dimension information of the Nth column of the Nth column dimension cell of the first target column header region;

[0135] The determination unit is specifically used to modify the M-th row initial dimensional information and the N-th column initial dimensional information to obtain modified M-th row initial dimensional information and modified N-th column initial dimensional information, wherein the modified M-th row initial dimensional information is the M-th row target dimensional information, and the modified N-th column initial dimensional information is the N-th column target dimensional information.

[0136] The determining unit is specifically configured to delete or add a target M-row sub-dimension and initial sub-dimension information of the target M-row sub-dimension to the M-th row initial dimension information to obtain the deleted or added M-row initial dimension information, wherein the deleted or added M-row initial dimension information is the modified M-row initial dimension information, delete or add a target N-column sub-dimension and initial sub-dimension information of the target N-column sub-dimension to the N-column target dimension information to obtain the deleted or added N-column target dimension information, wherein the deleted or added N-column initial dimension information is the modified N-column target dimension information, the M-row dimension cell includes multiple M-row sub-dimensions, the M-row initial dimension information includes multiple initial sub-dimension information of the M-row sub-dimensions, the N-column initial dimension information includes multiple N-column sub-dimensions, and the N-column initial dimension information includes multiple initial sub-dimension information of the N-column sub-dimensions.

[0137] The determining unit is specifically used to modify the M-th row initial dimension field and / or the field value of the M-th row initial dimension field to obtain the modified M-th row initial dimension field and / or the field value of the M-th row initial dimension field, the field value of the modified M-th row initial dimension field and / or the M-th row initial dimension field is the modified M-th row initial dimension information, modify the N-th column initial dimension field and the N-th column initial dimension field field value to obtain the modified N-th column initial dimension field and the N-th column initial dimension field field value, the field value of the modified N-th column initial dimension field and the N-th column initial dimension field is the modified N-th column initial dimension information, the M-th row initial dimension information includes the M-th row initial dimension field and the field value of the M-th row initial dimension field, and the N-th column initial dimension information includes the N-th column initial dimension field and the field value of the N-th column initial dimension field.

[0138] In an embodiment of the present application, the row header table and the column header table can be independently designed in an area outside the data area table, and the row dimension member information is stored in the row header table, and the column dimension member information is stored in the column header table. Only the row and column numbers and the corresponding dimension member information can be stored, and less information needs to be stored when setting the multi-dimensional information of each data cell. The efficiency of setting the multi-dimensional information of each data cell is high, and therefore, the generation efficiency of the report template is high. Furthermore, the row header table and the column header table are independent of the data area table, and the row header table, the column header table and the data area table are designed to be linked in layout, so that the generation of the report template will not affect the table sample information of the original main table, avoiding the destruction of the original table sample information and the displacement of the data cell position, and there is no need to perform various offset calculations on each data cell, and the efficiency of setting the multi-dimensional information of each data cell is high, so that the effect of what you see is what you get can be achieved, and the generation efficiency of the report template is further improved.

[0139] See below Figure 7 In the embodiment of the present application, an embodiment of the computer device 700 includes:

[0140] CPU 701, memory 705, input / output interface 704, wired or wireless network interface 703 and power supply 702;

[0141] The memory 705 is a temporary storage memory or a permanent storage memory;

[0142] The CPU 701 is configured to communicate with the memory 705 and execute the instructions in the memory 705 to perform the aforementioned Figure 2 , Figure 3 , Figure 4 and Figure 5The method in the illustrated embodiment.

[0143] The embodiment of the present application also provides a computer-readable storage medium, the computer-readable storage medium includes instructions, when the instructions are executed on a computer, the computer executes the aforementioned Figure 2 , Figure 3 , Figure 4 and Figure 5 The method in the illustrated embodiment.

[0144] The present application also provides a computer program product including instructions, which, when executed on a computer, enables the computer to execute the aforementioned Figure 2 , Figure 3 , Figure 4 and Figure 5 The method in the illustrated embodiment.

[0145] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0146] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0147] In the several embodiments provided in the present application, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or units, which can be electrical, mechanical or other forms.

[0148] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0149] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0150] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, read-only memory), random access memory (RAM, random access memory), disk or optical disk and other media that can store program code.

Claims

1. A method for generating a report template, characterized in that: include: Displaying a report template customization interface, the report template customization interface includes a data area table, a row header table and a column header table, the row header table and the column header table are areas located outside the data area table, the row number of the data area table corresponds to the row number of the row header table, and the column number of the data area table corresponds to the column number of the column header table; According to the first target data region selected in the data region table, determining in the row header table a first target row header region corresponding to a first row number of the first target data region, and determining in the column header table a first target column header region corresponding to a first column number of the first target data region; After determining the M-th row target dimension information of the M-th row dimension cell of the first target row header region and the N-th column target dimension information of the N-th column dimension cell of the first target column header region, combining the M-th row target dimension information and the N-th column target dimension information to obtain a first target row and column dimension combination of the M-th row and N-th column data cell of the first target data region; A first target report template is generated based on the first target data region and a first target row and column dimension combination of each first data cell in the first target data region.

2. The method according to claim 1, characterized in that The row header table is located in the area to the left or right of the data area table, and the column header table is located in the area above or below the data area table; Before determining the M-th row target dimension information of the M-th row dimension cell of the first target row header region and the N-th column target dimension information of the N-th column dimension cell of the first target column header region, the method further includes: According to the data cell of the Mth row and the Nth column selected in the first target data area, the dimension cell of the Mth row is synchronously selected and displayed in the first target row header area, and the dimension cell of the Nth column is synchronously selected and displayed in the first target column header area; The determining the target dimension information of the Mth row of the Mth row dimension cell of the first target row header region and the target dimension information of the Nth column of the Nth column dimension cell of the first target column header region includes: In the Mth row dimension cell and the Nth column dimension cell that are synchronously selected and displayed, the Mth row dimension information and the Nth column dimension information determined by the user are obtained.

3. The method according to claim 1, characterized in that The determining the target dimension information of the Mth row of the Mth row dimension cell of the first target row header region and the target dimension information of the Nth column of the Nth column dimension cell of the first target column header region includes: If a trigger signal for configuring the first target row header area in row dimension and the target column header area in column dimension is detected, a row and column dimension configuration interface is displayed, wherein the row and column dimension configuration interface includes at least one preset row dimension and at least one preset column dimension; Acquire at least one target row dimension and at least one target column dimension selected by a user from among the at least one preset row dimension and the at least one preset column dimension, and determine the Mth row target dimension information and the Nth column target dimension information based on the at least one target row dimension and the at least one target column dimension; and / or The target dimension information of the Mth row entered by the user in the dimension cell of the Mth row in the first target row header region and the target dimension information of the Nth column entered by the user in the dimension cell of the Nth column in the first target column header region are obtained.

4. The method according to claim 1, characterized in that: After displaying the report template customization interface, the method further includes: According to the second target data region selected in the data region table, determining in the row header table a second target row header region corresponding to a second row number of the second target data region, and determining in the column header table a second target column header region corresponding to a second column number of the second target data region, wherein the second row number is different from the first row number, and the second column number is different from the first column number; After determining the P-th row target dimension information of the P-th row dimension cell of the second target row header region and the Q-th column target dimension information of the Q-th column dimension cell of the second target column header region, combining the P-th row target dimension information and the Q-th column target dimension information to obtain a second target row and column dimension combination of the P-th row and Q-th column data cell of the second target data region; A second target report template is generated based on the second target data region and the second target row and column dimension combination of each second data cell in the second target data region.

5. The method according to any one of claims 1 to 4, characterized in that: Before determining the M-th row target dimension information of the M-th row dimension cell of the first target row header region and the N-th column target dimension information of the N-th column dimension cell of the first target column header region, the method further includes: Determine the initial dimension information of the Mth row of the Mth row dimension cell of the first target row header region, and the initial dimension information of the Nth column of the Nth column dimension cell of the first target column header region; The determining the target dimension information of the Mth row of the Mth row dimension cell of the first target row header region and the target dimension information of the Nth column of the Nth column dimension cell of the first target column header region includes: The M-th row initial dimensional information and the N-th column initial dimensional information are modified to obtain modified M-th row initial dimensional information and modified N-th column initial dimensional information, wherein the modified M-th row initial dimensional information is the M-th row target dimensional information, and the modified N-th column initial dimensional information is the N-th column target dimensional information.

6. The method according to claim 5, characterized in that The M-th row of dimension cells includes a plurality of M-th row sub-dimensions, the M-th row of initial dimension information includes a plurality of initial sub-dimension information of the M-th row sub-dimensions, the N-th column of initial dimension information includes a plurality of N-th column sub-dimensions, and the N-th column of initial dimension information includes a plurality of initial sub-dimension information of the N-th column sub-dimensions; The modifying the M-th row initial dimension information and the N-th column initial dimension information to obtain modified M-th row initial dimension information and modified N-th column initial dimension information includes: The target M-th row sub-dimension and the initial sub-dimension information of the target M-th row sub-dimension are deleted or added to the M-th row initial dimensional information to obtain the M-th row initial dimensional information after deletion or addition, and the M-th row initial dimensional information after deletion or addition is the modified M-th row initial dimensional information; The target Nth column sub-dimension and the initial sub-dimension information of the target Nth column sub-dimension are deleted or added to the Nth column target dimensional information to obtain the Nth column target dimensional information after deletion or addition, and the Nth column initial dimensional information after deletion or addition is the modified Nth column target dimensional information.

7. The method according to claim 5, characterized in that The M-th row of initial dimension information includes the M-th row of initial dimension fields and the field value of the M-th row of initial dimension fields, and the N-th column of initial dimension information includes the N-th column of initial dimension fields and the field value of the N-th column of initial dimension fields; The modifying the M-th row initial dimension information and the N-th column initial dimension information to obtain modified M-th row initial dimension information and modified N-th column initial dimension information includes: Modify the M-th row initial dimension field and / or the field value of the M-th row initial dimension field to obtain a modified M-th row initial dimension field and / or the field value of the M-th row initial dimension field, wherein the modified M-th row initial dimension field and / or the field value of the M-th row initial dimension field is the modified M-th row initial dimension information; The Nth column initial dimension field and the field value of the Nth column initial dimension field are modified to obtain the modified Nth column initial dimension field and the field value of the Nth column initial dimension field, and the modified Nth column initial dimension field and the field value of the Nth column initial dimension field are the modified Nth column initial dimension information.

8. A report template generating device, characterized in that: include: A display unit, used to display a report template customization interface, wherein the report template customization interface includes a data area table, a row header table, and a column header table, wherein the row header table and the column header table are located in an area outside the data area table, wherein the row number of the data area table corresponds to the row number of the row header table, and the column number of the data area table corresponds to the column number of the column header table; a determining unit, configured to determine, in the row header table, a first target row header region corresponding to a first row number of the first target data region, and to determine in the column header table a first target column header region corresponding to a first column number of the first target data region, according to the first target data region selected in the data region table; a combining unit, configured to determine the Mth row target dimension information of the Mth row dimension cell of the first target row header region and the Nth column target dimension information of the Nth column dimension cell of the first target column header region, and then combine the Mth row target dimension information and the Nth column target dimension information to obtain a first target row and column dimension combination of the Mth row and Nth column data cell of the first target data region; A generating unit is used to generate a first target report template based on the first target data region and a first target row and column dimension combination of each first data cell in the first target data region.

9. A computer device, characterized in that: include: CPU and memory; The memory is a short-term storage memory or a persistent storage memory; The central processing unit is configured to communicate with the memory and execute instructions in the memory to perform the method according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium comprises instructions, and when the instructions are executed on a computer, the computer is caused to perform the method according to any one of claims 1 to 7.

11. A computer program product comprising instructions, characterized in that When the computer program product is run on a computer, the computer is caused to execute the method according to any one of claims 1 to 7.

Images