Custom report dynamic query method and device and storage medium

Abstract

The invention provides a user-defined report dynamic query method and device and a storage medium, and relates to the technical field of terminal data processing. The method comprises the following steps: receiving a query condition defined by a user and sending the query condition to a report database; querying in the report database based on the query condition, reading a hit report template, and when the report template uses a dynamic value, rendering a query area on a user terminal based on a report display component according to the type of the dynamic value; and filling the read report template with the dynamic value, displaying the row and / or column corresponding to the dynamic value in the query region to generate a new query template, and sending a query data request to the report database based on the new query template, thereby avoiding the construction of a large number of templates, and improving the query efficiency. And the expandability and reusability of the template are improved.

Description

Technical Field

[0001] The present invention relates to the technical field of terminal data processing, and in particular to a method, device and storage medium for dynamic query of user-defined reports. Background Art

[0002] As the number of customers using the financial system continues to grow, their requirements for the use of financial statements are also gradually increasing. The original three major financial statements can no longer meet the needs of customers in daily production activities. Therefore, more flexible custom reports have been born in this context. However, the cumbersome configuration of custom reports and the need for multiple sets of templates to cope with different scenarios faced by customers in daily use, the management of a large number of report templates and cumbersome configuration have also brought difficulties to customers' use.

[0003] In the prior art, there are similar usage scenarios where report templates cannot be reused through dynamic parameters, resulting in template redundancy; the second is formula configuration assistance. For example, if you want to display auxiliary accounting details in each row, you need to configure the corresponding formula for each row, but after the configuration, it can only be used for this scenario. Once you want to change the auxiliary accounting, you need to make a new set of templates, which is very troublesome.

[0004] The main defects of the prior art are summarized as follows: The existing customized reports are actually semi-customized, not truly customized, that is, the product manager changes the report template according to the customer's business needs, and then presets it into the system through the report background management system. The front end then uses the latest report template to query the data in the back end and display the results to the user. At this stage, the front end does not need to develop new code as business needs change. However, it has not achieved true "customization", which is mainly reflected in the following aspects: a. Once the customer's business needs change, the template needs to be rewritten and preset to the backend database by the product manager; b. Once the template is preset, if the customer needs to change it, go back to step a; c. Customers cannot temporarily adjust reports as needed, such as merging rows and columns, setting report styles, etc.; d. It is not possible to perform more complex dimensional queries, such as beginning-of-period queries based on multi-dimensional auxiliary accounting such as suppliers and inventory, and expand the display to multiple rows and columns. Summary of the invention

[0005] The present invention proposes the following technical solutions to address one or more technical deficiencies in the above-mentioned prior art.

[0006] A custom report dynamic query method, the method comprising: A receiving step, receiving a user-defined query condition and sending the query condition to a report database; A rendering step, querying the report database based on the query condition and reading a hit report template, parsing the report template to determine whether a dynamic value is used in the report template, and if so, rendering a query area on the user terminal based on the type of the dynamic value and based on a report display component; A query step, filling the dynamic value in the read report template, and displaying the row and / or column corresponding to the dynamic value in the query area to generate a new query template, sending a query data request to the report database based on the new query template, the report database obtains the corresponding query result based on the query data request, and displays the data corresponding to the dynamic value in the query result in the query area and in the row and / or column corresponding to the dynamic value.

[0007] Furthermore, in the rendering step, if no dynamic value is used in the report template, a query data request is sent to the report database based on the read report template to obtain a corresponding query result.

[0008] Furthermore, the operation of filling the dynamic value in the read report template and displaying the rows and / or columns corresponding to the dynamic value in the query area to generate a new query template is as follows: all dynamic values ​​and extended rows and / or columns in the report template are read and the coordinates of the extended rows and / or columns are recorded, and all dynamic values ​​and extended rows and / or columns are rendered in the query area, the dynamic values ​​and extended rows and / or columns selected by the user are received, and based on the user's selection, the selected dynamic values ​​in the read report template are replaced with user target values, and the extended rows and / or columns selected by the user are made to correspond to the selected dynamic values ​​to generate a new query template.

[0009] Furthermore, after all dynamic values ​​and extended rows and / or columns are rendered in the query area, the number of dynamic values ​​and extended rows and / or columns selected by the user is set.

[0010] Furthermore, after the user completes the query, a destruction instruction from the user is received, and the new query template is deleted from the memory based on the destruction instruction. The specific operation is: parsing the destruction instruction, obtaining the ID of the new query template in the destruction instruction, querying the corresponding new query template in the memory based on the ID, and providing feedback to the user on whether to save the new query template. If yes, receiving the name of the new query template input by the user for saving. If not, first deleting the dynamic values ​​and extended rows and / or columns in the new query template to restore to the originally read query template, and then deleting the originally read query template in the memory.

[0011] The present invention also proposes a self-defined report dynamic query device, which includes: A receiving unit receives a user-defined query condition and sends the query condition to a report database; A rendering unit, which searches the report database based on the query condition and reads a hit report template, parses the report template to determine whether a dynamic value is used in the report template, and if so, renders a query area on a user terminal based on the type of the dynamic value and a report display component; A query unit fills the dynamic value in the read report template, and displays the row and / or column corresponding to the dynamic value in the query area to generate a new query template, and sends a query data request to the report database based on the new query template, and the report database obtains the corresponding query result based on the query data request, and displays the data corresponding to the dynamic value in the query result in the query area and in the row and / or column corresponding to the dynamic value.

[0012] Furthermore, in the rendering unit, if no dynamic value is used in the report template, a query data request is sent to the report database based on the read report template to obtain a corresponding query result.

[0013] Furthermore, the operation of filling the dynamic value in the read report template and displaying the rows and / or columns corresponding to the dynamic value in the query area to generate a new query template is as follows: all dynamic values ​​and extended rows and / or columns in the report template are read and the coordinates of the extended rows and / or columns are recorded, and all dynamic values ​​and extended rows and / or columns are rendered in the query area, the dynamic values ​​and extended rows and / or columns selected by the user are received, and based on the user's selection, the selected dynamic values ​​in the read report template are replaced with user target values, and the extended rows and / or columns selected by the user are made to correspond to the selected dynamic values ​​to generate a new query template.

[0014] Furthermore, after all dynamic values ​​and extended rows and / or columns are rendered in the query area, the number of dynamic values ​​and extended rows and / or columns selected by the user is set.

[0015] Furthermore, after the user completes the query, a destruction instruction from the user is received, and the new query template is deleted from the memory based on the destruction instruction. The specific operation is: parsing the destruction instruction, obtaining the ID of the new query template in the destruction instruction, querying the corresponding new query template in the memory based on the ID, and providing feedback to the user on whether to save the new query template. If yes, receiving the name of the new query template input by the user for saving. If not, first deleting the dynamic values ​​and extended rows and / or columns in the new query template to restore to the originally read query template, and then deleting the originally read query template in the memory.

[0016] The present invention further provides a computer-readable storage medium, wherein the storage medium stores computer program code, and when the computer program code is executed by a computer, any of the above methods is executed.

[0017] The technical effect of the present invention is: a method, device and storage medium for dynamic query of a customized report of the present invention, the method comprising: a receiving step S101, receiving a query condition customized by a user and sending the query condition to a report database; a rendering step S102, querying the report database based on the query condition and reading a hit report template, parsing the report template to determine whether a dynamic value is used in the report template, if so, rendering a query area on a user terminal according to the type of the dynamic value and based on a report display component; a query step S103, filling the dynamic value in the read report template, and displaying the row and / or column corresponding to the dynamic value in the query area to generate a new query template, sending a query data request to the report database based on the new query template, the report database obtaining a corresponding query result based on the query data request, and displaying the data corresponding to the dynamic value in the query result in the query area and in the row and / or column corresponding to the dynamic value, the dynamic value is also called a dynamic variable. The present invention does not need to construct numerous query templates. By setting dynamic values ​​and expandable rows and / or columns, the dynamic values ​​and expandable rows and / or columns are then displayed on a rendered query area for user selection. A new query template is generated based on the user's selection, and a query data request is sent to the report database based on the new query template. The new query template is also called a temporary query target, which is temporarily constructed in a user's query task, thereby avoiding the construction of a large number of templates and improving the scalability and reusability of the template. In the present invention, all dynamic values ​​and expanded rows and / or columns in the report template are read and the coordinates of the expanded rows and / or columns are recorded, and all dynamic values ​​and expanded rows and / or columns are rendered in the query area, the coordinates of the dynamic values ​​and expanded rows and / or columns selected by the user are received, and the selected dynamic values ​​are replaced with user target values ​​in the read report template based on the user's selection, and based on the selected dynamic values ​​and expanded rows The coordinates of the extended rows and / or columns correspond to the selected dynamic values ​​to generate a new query template, so that the database can be queried in a customized and dynamically expanded manner, thereby solving the problems in the background technology that once the customer's business needs change, the template needs to be rewritten and the customer cannot temporarily adjust the report as needed, such as merging rows and columns, setting report styles, etc. In the present invention, one or more extended rows and / or columns can be selected, and one or more dynamic value operations can be corresponded in one row, which solves the problem that users cannot perform more reviewed dimensional queries. In the present invention, when deleting a temporary query target, the dynamic values ​​and extended rows and / or columns in the new query template are first deleted to restore to the originally read query template, and then the originally read query template is deleted in the memory, thereby preventing network attackers from obtaining user query data through memory hijacking, thereby improving the privacy and security of user query data. BRIEF DESCRIPTION OF THE DRAWINGS

[0018] Other features, objects and advantages of the present application will become more apparent from the detailed description of non-limiting embodiments made with reference to the following drawings.

[0019] Figure 1 The present invention is a flowchart of a method for dynamic query of a customized report according to an embodiment of the present invention.

[0020] Figure 2 It is a structural diagram of a custom report dynamic query device according to an embodiment of the present invention. DETAILED DESCRIPTION

[0021] The present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It is to be understood that the specific embodiments described herein are only used to explain the relevant invention, rather than to limit the invention. It should also be noted that, for ease of description, only the parts related to the relevant invention are shown in the accompanying drawings.

[0022] It should be noted that, in the absence of conflict, the embodiments and features in the embodiments of the present application can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and in combination with the embodiments.

[0023] Figure 1 A method for dynamic query of a custom report of the present invention is shown, the method comprising: Receiving step S101, receiving a user-defined query condition and sending the query condition to a report database; Rendering step S102, querying the report database based on the query condition and reading a hit report template, parsing the report template to determine whether a dynamic value is used in the report template, and if so, rendering a query area on the user terminal according to the type of the dynamic value and based on the report display component; Query step S103, fill the dynamic value in the read report template, and display the row and / or column corresponding to the dynamic value in the query area to generate a new query template, send a query data request to the report database based on the new query template, the report database obtains the corresponding query result based on the query data request, and displays the data corresponding to the dynamic value in the query result in the query area and in the row and / or column corresponding to the dynamic value. The dynamic value is also called a dynamic variable.

[0024] In the present invention, a query is performed in the report database based on the query condition and a hit report template is read, the report template is parsed to determine whether a dynamic value is used in the report template, if so, a query area is rendered on the user terminal according to the type of the dynamic value and based on a report display component, the dynamic value is filled in the read report template, and the row and / or column corresponding to the dynamic value is displayed in the query area to generate a new query template, a query data request is sent to the report database based on the new query template, the report database obtains the corresponding query result based on the query data request, and displays the data corresponding to the dynamic value in the query result in the query area and in the row and / or column corresponding to the dynamic value. That is, the present invention does not need to construct numerous query templates. By setting dynamic values ​​and expandable rows and / or columns, the dynamic values ​​and expandable rows and / or columns are displayed in the rendered query area for user selection. A new query template is generated based on the user's selection, and a query data request is sent to the report database based on the new query template. The new query template is also called a temporary query target, which is temporarily constructed in a user's query task, thereby avoiding the construction of a large number of templates and improving the scalability and reusability of the template. This is one of the important inventive concepts of the present invention.

[0025] In one embodiment, in the rendering step S102, if the report template does not use dynamic values, a query data request is sent to the report database based on the read report template to obtain corresponding query results. That is, the present invention is compatible with traditional query templates, that is, templates without dynamic values ​​use query templates to directly access the database system for query.

[0026] In one embodiment, the operation of filling the dynamic value in the read report template and displaying the rows and / or columns corresponding to the dynamic value in the query area to generate a new query template is as follows: all dynamic values ​​and extended rows and / or columns in the report template are read and the coordinates of the extended rows and / or columns are recorded, and all dynamic values ​​and extended rows and / or columns are rendered in the query area, dynamic values ​​and extended rows and / or columns selected by a user are received, and based on the user's selection, the selected dynamic value in the read report template is replaced with a user target value, and the extended rows and / or columns selected by the user are matched with the selected dynamic value to generate a new query template.

[0027] In the present invention, all dynamic values ​​and extended rows and / or columns in the report template are read and the coordinates of the extended rows and / or columns are recorded, and all dynamic values ​​and extended rows and / or columns are rendered in the query area, and the dynamic values ​​and coordinates of the extended rows and / or columns selected by the user are received. Based on the user's selection, the selected dynamic values ​​in the read report template are replaced with user target values, and based on the selected dynamic values ​​and the coordinates of the extended rows and / or columns, the extended rows and / or columns are matched with the selected dynamic values ​​to generate a new query template, so that the database can be queried in a customized and dynamically expanded manner, thereby solving the defects in the background technology that once the customer's business needs change, the template needs to be rewritten and the customer cannot temporarily adjust the report according to needs, such as merging rows and columns, setting report style, etc. This is another important inventive point of the present invention.

[0028] In one implementation, in order to support dynamic queries in multiple dimensions, after all dynamic values ​​and extended rows and / or columns are rendered in the query area, the number of dynamic values ​​and extended rows and / or columns selected by the user is set. For example, the user can select one or more dynamic values, one or more extended rows and / or columns, and operations corresponding to one or more dynamic values ​​can be performed in one row, thereby solving the defect that users cannot perform more detailed dimensional queries. This is another important inventive point of the present invention.

[0029] In one implementation, after the user completes the query, the user's destruction instruction is received, and the new query template is deleted from the memory based on the destruction instruction. The specific operation may be to parse the destruction instruction, obtain the ID of the new query template in the destruction instruction, query the corresponding new query template in the memory based on the ID, and feedback to the user whether to save the new query template. If yes, the name of the new query template input by the user is received for saving. If not, the dynamic values ​​and extended rows and / or columns in the new query template are first deleted to restore to the original query template read, and then the original query template is deleted from the memory, thereby preventing network attackers from obtaining the user's query data by memory hijacking, improving the privacy and security of the user's query data, which is another important invention of the present invention.

[0030] To illustrate this application, let's first look at a typical report template, as shown in Table 1:

[0031] Table 1 As shown in the table above, the formula [=QC("@km","","Year","Month","","KZH(@kh)","")] in cell D4 in the template represents the beginning value of the account, where @km is the account code (@km.name is the account name), @kh is the customer name, KZH is the extended row (pinyin initials) function, and the extended column function is KZL. @km and @kh are called dynamic variables (also called dynamic values), and KZH / KZL means that the row / column is expandable, which means that the value of the dynamic variable in the KZH / KZL function can select multiple values, while other variables can only select one option at a time. The following are the option operations for the account and customer respectively: 1. Select "1001 Cash on Hand" as the subject 2. The customer selects "0001XX Company" and "0002XXX Company" After processing, the "@km.name" in the D3 cell of the original template will be replaced with "Cash on Hand", the "@km" in the D4 cell will be replaced with "1001", and the "@kh" in the fourth row is the customer, which will be replaced with the corresponding customer name, and the customer is the extended row KZH, then the fourth row will be copied and a new row will be inserted after it. Due to the insertion of a new row, the references to the original template D4 in the C1, C2, E5, and D6 cells will be changed to (D4+D5) accordingly, and the reference to the original template D5 in the D6 cell will be changed to D6, and similarly E4 will be changed to (E4+E5).

[0032] As shown in Table 2:

[0033] Table 2 Finally, fill in the rest of the dynamic variables.

[0034] As shown in Table 3:

[0035] Table 3 Figure 2 A self-defined report dynamic query device of the present invention is shown, and the device comprises: The receiving unit 201 receives the query conditions defined by the user and sends the query conditions to the report database; The rendering unit 202 queries the report database based on the query condition and reads a hit report template, parses the report template to determine whether a dynamic value is used in the report template, and if so, renders a query area on the user terminal according to the type of the dynamic value and based on the report display component; The query unit 203 fills the dynamic value in the read report template, and displays the row and / or column corresponding to the dynamic value in the query area to generate a new query template, and sends a query data request to the report database based on the new query template. The report database obtains the corresponding query result based on the query data request, and displays the data corresponding to the dynamic value in the query result in the query area and in the row and / or column corresponding to the dynamic value. The dynamic value is also called a dynamic variable.

[0036] In the present invention, a query is performed in the report database based on the query condition and a hit report template is read, the report template is parsed to determine whether a dynamic value is used in the report template, if so, a query area is rendered on the user terminal according to the type of the dynamic value and based on a report display component, the dynamic value is filled in the read report template, and the row and / or column corresponding to the dynamic value is displayed in the query area to generate a new query template, a query data request is sent to the report database based on the new query template, the report database obtains the corresponding query result based on the query data request, and displays the data corresponding to the dynamic value in the query result in the query area and in the row and / or column corresponding to the dynamic value. That is, the present invention does not need to construct numerous query templates. By setting dynamic values ​​and expandable rows and / or columns, the dynamic values ​​and expandable rows and / or columns are displayed in the rendered query area for user selection. A new query template is generated based on the user's selection, and a query data request is sent to the report database based on the new query template. The new query template is also called a temporary query target, which is temporarily constructed in a user's query task, thereby avoiding the construction of a large number of templates and improving the scalability and reusability of the template. This is one of the important inventive concepts of the present invention.

[0037] In one embodiment, in the rendering unit 202, if the report template does not use dynamic values, a query data request is sent to the report database based on the read report template to obtain corresponding query results. That is, the present invention is compatible with traditional query templates, that is, templates without dynamic values ​​use query templates to directly access the database system for query.

[0038] In one embodiment, the operation of filling the dynamic value in the read report template and displaying the rows and / or columns corresponding to the dynamic value in the query area to generate a new query template is as follows: all dynamic values ​​and extended rows and / or columns in the report template are read and the coordinates of the extended rows and / or columns are recorded, and all dynamic values ​​and extended rows and / or columns are rendered in the query area, dynamic values ​​and extended rows and / or columns selected by a user are received, and based on the user's selection, the selected dynamic value in the read report template is replaced with a user target value, and the extended rows and / or columns selected by the user are matched with the selected dynamic value to generate a new query template.

[0039] In the present invention, all dynamic values ​​and extended rows and / or columns in the report template are read and the coordinates of the extended rows and / or columns are recorded, and all dynamic values ​​and extended rows and / or columns are rendered in the query area, and the dynamic values ​​and coordinates of the extended rows and / or columns selected by the user are received. Based on the user's selection, the selected dynamic values ​​in the read report template are replaced with user target values, and based on the selected dynamic values ​​and the coordinates of the extended rows and / or columns, the extended rows and / or columns are matched with the selected dynamic values ​​to generate a new query template, so that the database can be queried in a customized and dynamically expanded manner, thereby solving the defects in the background technology that once the customer's business needs change, the template needs to be rewritten and the customer cannot temporarily adjust the report according to needs, such as merging rows and columns, setting report style, etc. This is another important inventive point of the present invention.

[0040] In one implementation, in order to support dynamic queries in multiple dimensions, after all dynamic values ​​and extended rows and / or columns are rendered in the query area, the number of dynamic values ​​and extended rows and / or columns selected by the user is set. For example, the user can select one or more dynamic values, one or more extended rows and / or columns, and operations corresponding to one or more dynamic values ​​can be performed in one row, thereby solving the defect that users cannot perform more detailed dimensional queries. This is another important inventive point of the present invention.

[0041] In one implementation, after the user completes the query, the user's destruction instruction is received, and the new query template is deleted from the memory based on the destruction instruction. The specific operation may be to parse the destruction instruction, obtain the ID of the new query template in the destruction instruction, query the corresponding new query template in the memory based on the ID, and feedback to the user whether to save the new query template. If yes, the name of the new query template input by the user is received for saving. If not, the dynamic values ​​and extended rows and / or columns in the new query template are first deleted to restore to the original query template read, and then the original query template is deleted from the memory, thereby preventing network attackers from obtaining the user's query data by memory hijacking, improving the privacy and security of the user's query data, which is another important invention of the present invention.

[0042] In one embodiment of the present invention, a computer storage medium is provided, on which a computer program is stored. When the computer program on the computer storage medium is executed by a processor, the above method is implemented. The computer storage medium can be a hard disk, DVD, CD, flash memory or other memory.

[0043] For the convenience of description, the above device is described in various units according to their functions. Of course, when implementing the present application, the functions of each unit can be implemented in the same or multiple software and / or hardware.

[0044] It can be known from the description of the above implementation methods that those skilled in the art can clearly understand that the present application can be implemented by means of software plus a necessary general hardware platform. Based on such an understanding, the technical solution of the present application, or the part that contributes to the prior art, can be embodied in the form of a software product, which can be stored in a storage medium, such as ROM / RAM, a disk, an optical disk, etc., and includes a number of instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the devices described in each embodiment of the present application or some parts of the embodiments.

[0045] Finally, it should be noted that the above embodiments are only intended to illustrate rather than limit the technical solutions of the present invention. Although the present invention has been described in detail with reference to the above embodiments, those skilled in the art should understand that the present invention can still be modified or replaced by equivalents. Any modification or partial replacement that does not depart from the spirit and scope of the present invention should be included in the scope of the claims of the present invention.

Claims

1. A custom report dynamic query method, characterized in that: The method includes: A receiving step, receiving a user-defined query condition and sending the query condition to a report database; A rendering step, querying the report database based on the query condition and reading a hit report template, parsing the report template to determine whether a dynamic value is used in the report template, and if so, rendering a query area on the user terminal based on the type of the dynamic value and based on a report display component; A query step, filling the dynamic value in the read report template, and displaying the row and / or column corresponding to the dynamic value in the query area to generate a new query template, sending a query data request to the report database based on the new query template, the report database obtains the corresponding query result based on the query data request, and displays the data corresponding to the dynamic value in the query result in the query area and in the row and / or column corresponding to the dynamic value.

2. The method according to claim 1, characterized in that In the rendering step, if no dynamic value is used in the report template, a query data request is sent to the report database based on the read report template to obtain a corresponding query result.

3. The method according to claim 2, characterized in that The operations of filling the dynamic value in the read report template and displaying the rows and / or columns corresponding to the dynamic value in the query area to generate a new query template are as follows: all dynamic values ​​and extended rows and / or columns in the report template are read and the coordinates of the extended rows and / or columns are recorded, and all dynamic values ​​and extended rows and / or columns are rendered in the query area, dynamic values ​​and extended rows and / or columns selected by a user are received, and based on the user's selection, the selected dynamic value in the read report template is replaced with a user target value, and the extended rows and / or columns selected by the user are matched with the selected dynamic value to generate a new query template.

4. The method according to claim 3, characterized in that After all dynamic values ​​and extended rows and / or columns are rendered in the query area, the number of dynamic values ​​and extended rows and / or columns selected by the user is set.

5. The method according to claim 4, characterized in that After the user completes the query, a destruction instruction from the user is received, and the new query template is deleted from the memory based on the destruction instruction.

6. A custom report dynamic query device, characterized in that: The device includes: A receiving unit receives a user-defined query condition and sends the query condition to a report database; A rendering unit, which searches the report database based on the query condition and reads a hit report template, parses the report template to determine whether a dynamic value is used in the report template, and if so, renders a query area on a user terminal based on the type of the dynamic value and a report display component; The query unit fills the dynamic value in the read report template, and displays the row and / or column corresponding to the dynamic value in the query area to generate a new query template, and sends a query data request to the report database based on the new query template. The report database obtains the corresponding query result based on the query data request, and displays the data corresponding to the dynamic value in the query result in the query area and in the row and / or column corresponding to the dynamic value.

7. The device according to claim 6, characterized in that In the rendering unit, if no dynamic value is used in the report template, a query data request is sent to the report database based on the read report template to obtain a corresponding query result.

8. The device according to claim 7, characterized in that The operations of filling the dynamic value in the read report template and displaying the rows and / or columns corresponding to the dynamic value in the query area to generate a new query template are as follows: all dynamic values ​​and extended rows and / or columns in the report template are read and the coordinates of the extended rows and / or columns are recorded, and all dynamic values ​​and extended rows and / or columns are rendered in the query area, dynamic values ​​and extended rows and / or columns selected by a user are received, and based on the user's selection, the selected dynamic value in the read report template is replaced with a user target value, and the extended rows and / or columns selected by the user are matched with the selected dynamic value to generate a new query template.

9. The device according to claim 8, characterized in that After all dynamic values ​​and extended rows and / or columns are rendered in the query area, the number of dynamic values ​​and extended rows and / or columns selected by the user is set.

10. A computer storage medium, characterized in that: The computer storage medium stores a computer program, and when the computer program on the computer storage medium is executed by a processor, the method according to any one of claims 1 to 5 is implemented.

Images