Model setting method and system for free report, readable storage medium

Abstract

The application provides a model setting method and system of a free report, and a readable storage medium. The model setting method of the free report comprises the following steps: acquiring a cell list, the cell list comprising a plurality of design cells; converting the design cells to obtain business cells; structurally processing the business cells to obtain design blocks; and sequentially processing cell information in the design blocks, and collecting cells on the same link together according to the cell information to form a design path. Through the technical scheme, the server adds the design block layer and the design path layer in the running time, the execution is clear in hierarchy, supports a more fine-grained business scenario, and is convenient for subsequent code maintenance and expansion.

Description

Technical Field

[0001] This application relates to the field of computer technology, and more specifically, to a method and system for setting up a free report model, and a readable storage medium. Background Technology

[0002] A freeform report is a statistical table designed based on a template or table format. It displays a query-like cell table similar to Excel, allowing for flexible configuration of cells to create various complex Chinese-style reports. The common freeform report model hierarchy, from top to bottom, consists of the report object model, the object tab model, and the region cell model. This common model hierarchy cannot address tab-level business needs and cannot support more granular business scenarios. Summary of the Invention

[0003] This application aims to solve or improve the aforementioned technical problems.

[0004] Therefore, the primary objective of this application is to provide a method for setting up a free report model.

[0005] The second objective of this application is to provide a model setting system for free reports.

[0006] The third objective of this application is to provide a model setting system for free reports.

[0007] The fourth objective of this application is to provide a readable storage medium.

[0008] To achieve the primary objective of this application, the technical solution of the first aspect of this application provides a method for setting up a model for a free report, comprising: obtaining a cell list, the cell list including multiple design cells; converting the design cells to obtain business cells; performing structured processing on the business cells to obtain design blocks; sequentially processing the cell information in the design blocks, and grouping cells on the same link together according to the cell information to form a design path.

[0009] According to the model setting method of the free report provided in this application, a cell list is first obtained, which includes multiple design cells. Then, the design cells in the cell list are transformed to obtain business cells. During the transformation of design cells, the condition information of the design cells is obtained. Subsequently, the business cells are structured to form design blocks. After block recognition, the cell information in each design block is processed one by one, and cells with the same design path are identified together to form a design path. By adding a design block layer and a design path layer, it better conforms to the design concept of free reports, with clear hierarchical execution, facilitating subsequent code maintenance and expansion. It meets the customer's requirement that cell conditions apply to the entire block, and based on the extended layers, the functional characteristics of free reports can be enriched with finer granularity. Furthermore, it ensures controllable space usage and keeps the execution time of free reports within a certain range, avoiding server crashes due to prolonged business operations.

[0010] In this context, "Design Cell" refers to the cell model created by the user during report design. "Business Cell" refers to a new business object model constructed by the server based on the received cell model to ensure parameter consistency, integrity, and isolation. This business cell encapsulates all the information of the original design cell. "Link Dependency Cell Relationship" indicates cell information in the same design direction, commonly expressed as a row of designs. Cell relationships indicate the logical sequence of two cells in a link; the cell with the earlier logical relationship is called the parent cell, and the cell with the later logical relationship is called the child cell, commonly expressed as left parent and top parent. "Design Block" refers to the logical model representation formed by grouping and aggregating cells with inter-cell relationships together. "Design Path" refers to a more granular organization of inter-cell relationships within a design block, grouping and aggregating cells in a single link together to form a logical model representation.

[0011] In addition, the technical solution provided in this application may also have the following additional technical features:

[0012] In the above technical solution, the business cells are structured to obtain design blocks, which specifically includes: traversing the cell list; determining whether the current business cell has a parent cell with inter-cell relationship; if not, constructing a design block and recording the business cell in the design block; if so, obtaining the design block of the parent cell with inter-cell relationship.

[0013] In this technical solution, business cells are structured to obtain design blocks, specifically by traversing the cell list. If the current cell is the root cell (i.e., there is no parent cell in the inter-cell relationship), a design block is constructed for it, and this cell is recorded in the design block. Then, other cells are processed. If the current cell is not the root cell (i.e., there is a parent cell in the inter-cell relationship), the design block of the parent cell is obtained. After all cells have been processed, a list of design blocks is obtained.

[0014] In the above technical solution, if yes, then the design block of the parent cell of the inter-cell relationship is obtained, specifically including: determining whether the design block of the parent cell of the inter-cell relationship exists; if yes, then the business cell is recorded in the design block of the parent cell of the inter-cell relationship; if no, then the design block of the parent cell of the inter-cell relationship is constructed.

[0015] In this technical solution, obtaining the design block of the parent cell in the inter-cell relationship involves determining whether the design block of the parent cell exists. If the parent cell design block already exists, the cell is directly recorded in the parent cell design block; otherwise, a design block needs to be constructed for the parent cell, and the processing logic is the same as for this cell.

[0016] In the above technical solution, the cell information in the design block is processed sequentially, and cells on the same link are grouped together to form a design path based on the cell information. Specifically, this includes: determining whether the current design block is an unbound block; if not, obtaining the calculation optimization configuration, grouping the business cells in the design block according to their model source; sequentially traversing the cell list of each model source to obtain the cell list data; constructing the main design path based on the cell list data; and constructing the optimized design path based on the calculation optimization configuration. The construction method of the optimized design path includes the complex design block method and / or the simple design block method.

[0017] In this technical solution, cell information within the design block is processed sequentially. Cells on the same link are grouped together based on this information to form a design path. Specifically, it determines whether the current design block is an unbound block. If the current block is unbound, no processing is required. Otherwise, the system's computational optimization configuration is obtained in advance, and the cells in the design block are grouped according to their model source. Then, the cell list under each model source is traversed one by one to obtain the cell list data. Based on the cell list data, the main design path is constructed. Based on the computational optimization configuration, an optimized design path is constructed using either a complex design block method or a simple design block method. By performing computational optimization separately based on the design path, the accuracy of the calculation results can be guaranteed.

[0018] In the above technical solution, the optimized design path is constructed based on the computational optimization configuration, which specifically includes: extracting leaf nodes; constructing a path based on the leaf nodes; and performing optimization processing after construction to obtain the optimized design path.

[0019] In this technical solution, an optimized design path is constructed using a complex design block method. Specifically, leaf nodes are first extracted, then a path is constructed based on the leaf nodes, and finally optimized to obtain the optimized design path. The complex design block method constructs the design path from the last level to the root node according to the leaf nodes. Constructing the optimized design path using this method ensures the accuracy of the calculation results.

[0020] In the above technical solution, the optimized design path is constructed based on the computational optimization configuration, specifically including: extracting the root node; constructing the path based on the root node; and performing optimization processing after construction to obtain the optimized design path.

[0021] In this technical solution, an optimized design path is constructed using a simple design block method. Specifically, the root node is first extracted. Then, a path is constructed based on the root node. After construction, optimization processing is performed to obtain the optimized design path. The simple design block method constructs the design path from the root node to the child nodes, ensuring the accuracy of the calculation results.

[0022] The above technical solution involves structuring business cells to obtain design blocks, and also includes obtaining design block conditions.

[0023] In this technical solution, recording the design block conditions during the structured processing of business cells can prepare for subsequent design block-level business data filtering.

[0024] To achieve the second objective of this application, the technical solution of the second aspect of this application provides a model setting system for a free report, comprising: an acquisition module for acquiring a cell list, the cell list including multiple design cells; a conversion module for converting the design cells to obtain business cells; a design block forming module for performing structured processing on the business cells to obtain design blocks; and a design path forming module for sequentially processing the cell information in the design blocks and grouping cells on the same link together according to the cell information to form a design path.

[0025] The free report model setting system provided in this application includes an acquisition module, a transformation module, a design block formation module, and a design path formation module. The acquisition module retrieves a list of cells, which includes multiple design cells. The transformation module transforms the design cells to obtain business cells. The design block formation module performs structured processing on the business cells to obtain design blocks. The design path formation module processes the cell information within the design blocks sequentially, grouping cells along the same path together to form a design path. By adding design block and design path layers, the system better aligns with the design philosophy of free reports, providing clear hierarchical execution and facilitating subsequent code maintenance and expansion. It meets the client's requirement for cell conditions to apply to the entire block, and the expanded layers allow for more granular enrichment of free report functionality. Furthermore, it ensures controllable space usage and keeps execution time within a certain range, preventing server crashes due to prolonged business operations.

[0026] To achieve the third objective of this application, the technical solution of the third aspect of this application provides a free report model setting system, including: a memory and a processor, wherein the memory stores a program or instructions that can be run on the processor, and when the processor executes the program or instructions, it implements the free report model setting method of any one of the technical solutions of the first aspect, thus having the technical effects of any one of the technical solutions of the first aspect, which will not be elaborated here.

[0027] To achieve the fourth objective of this application, the technical solution of the fourth aspect of this application provides a readable storage medium storing a program or instructions thereon. When the program or instructions are executed by a processor, they implement the steps of the free report model setting method of any one of the technical solutions of the first aspect, and thus have the technical effects of any one of the technical solutions of the first aspect, which will not be repeated here.

[0028] Additional aspects and advantages of this application will become apparent in the following description or may be learned by practice of this application. Attached Figure Description

[0029] The above and / or additional aspects and advantages of this application will become apparent and readily understood from the description of the embodiments taken in conjunction with the following drawings, in which:

[0030] Figure 1 A flowchart illustrating the steps of a free report model setting method according to an embodiment of this application;

[0031] Figure 2 A flowchart illustrating the steps of a free report model setting method according to an embodiment of this application;

[0032] Figure 3A flowchart illustrating the steps of a free report model setting method according to an embodiment of this application;

[0033] Figure 4 A flowchart illustrating the steps of a free report model setting method according to an embodiment of this application;

[0034] Figure 5 A flowchart illustrating the steps of a free report model setting method according to an embodiment of this application;

[0035] Figure 6 A flowchart illustrating the steps of a free report model setting method according to an embodiment of this application;

[0036] Figure 7 A flowchart illustrating the steps of a free report model setting method according to an embodiment of this application;

[0037] Figure 8 A schematic block diagram of the structure of a free report model setting system according to an embodiment of this application;

[0038] Figure 9 A schematic block diagram of the structure of a model setting system for a free report according to another embodiment of this application;

[0039] Figure 10 A flowchart illustrating the steps of a free report model setting method according to an embodiment of this application;

[0040] Figure 11 A flowchart illustrating the steps of a free report model setting method according to an embodiment of this application;

[0041] Figure 12 Experimental verification diagram of a free report model setting method according to an embodiment of this application;

[0042] Figure 13 Experimental verification diagram of a free report model setting method according to an embodiment of this application;

[0043] Figure 14 Experimental verification diagram of a free report model setting method according to an embodiment of this application;

[0044] Figure 15 This is an experimental verification diagram of a free report model setting method according to an embodiment of this application.

[0045] in, Figure 8 and Figure 9 The correspondence between the reference numerals and component names in the attached drawings is as follows:

[0046] 10: Model setting system for free reports; 110: Acquisition module; 120: Conversion module; 130: Design block formation module; 140: Design path formation module; 20: Model setting system for free reports; 300: Memory; 400: Processor. Detailed Implementation

[0047] To better understand the above-mentioned objectives, features, and advantages of this application, the application will be further described in detail below with reference to the accompanying drawings and specific embodiments. It should be noted that, unless otherwise specified, the embodiments and features described in these embodiments can be combined with each other.

[0048] Many specific details are set forth in the following description in order to provide a full understanding of this application. However, this application may also be implemented in other ways different from those described herein. Therefore, the scope of protection of this application is not limited to the specific embodiments disclosed below.

[0049] The following reference Figures 1 to 15 This application describes a free report modeling method and system, and a readable storage medium, based on some embodiments of this application.

[0050] like Figure 1 As shown, an embodiment of the first aspect of this application provides a method for setting up a model for a free report, including the following steps:

[0051] Step S102: Obtain the cell list, which includes multiple design cells;

[0052] Step S104: Convert the design cells to obtain the business cells;

[0053] Step S106: Perform structured processing on the business cells to obtain the design blocks;

[0054] Step S108: Process the cell information in the design block in sequence, and group the cells on the same link together to form a design path based on the cell information.

[0055] According to the model setting method for freeform reports provided in this embodiment, a cell list is first obtained, which includes multiple design cells. Then, the design cells in the cell list are transformed to obtain business cells. During the transformation of design cells, condition information of the design cells is obtained. Subsequently, the business cells are structured to form design blocks. After block identification, the cell information in each design block is processed one by one, and cells with the same design path are identified together to form a design path. By adding a design block layer and a design path layer, it better conforms to the design concept of freeform reports, with clear hierarchical execution, facilitating subsequent code maintenance and expansion. It meets the customer's requirement that cell conditions apply to the entire block, and based on the extended layers, the functional characteristics of freeform reports can be enriched with finer granularity. Furthermore, it ensures controllable space usage and keeps the execution time of freeform reports within a certain range, avoiding server crashes due to prolonged business operations.

[0056] In this context, "Design Cell" refers to the cell model created by the user during report design. "Business Cell" refers to a new business object model constructed by the server based on the received cell model to ensure parameter consistency, integrity, and isolation. This business cell encapsulates all the information of the original design cell. "Link Dependency Cell Relationship" indicates cell information in the same design direction, commonly expressed as a row of designs. Cell relationships indicate the logical sequence of two cells in a link; the cell with the earlier logical relationship is called the parent cell, and the cell with the later logical relationship is called the child cell, commonly expressed as left parent and top parent. "Design Block" refers to the logical model representation formed by grouping and aggregating cells with inter-cell relationships together. "Design Path" refers to a more granular organization of inter-cell relationships within a design block, grouping and aggregating cells in a single link together to form a logical model representation.

[0057] like Figure 2 As shown, according to an embodiment of the free report model setting method proposed in this application, the business cells are structured to obtain design blocks, specifically including the following steps:

[0058] Step S202: Traverse the list of cells;

[0059] Step S204: Determine if the current business cell has a parent cell relationship;

[0060] Step S206: If not, construct the design block and record the business cell into the design block;

[0061] Step S208: If yes, then obtain the design block of the parent cell for the inter-cell relationship.

[0062] In this embodiment, the business cells are structured to obtain design blocks, specifically by traversing the cell list. If the current cell is the root (i.e., there is no parent cell in the inter-cell relationship), a design block is constructed for it, and this cell is recorded in the design block. Then, other cells are processed. If the current cell is not the root (i.e., there is a parent cell in the inter-cell relationship), the design block of the parent cell is obtained. After all cells have been processed, a list of design blocks is obtained.

[0063] like Figure 3 As shown, according to an embodiment of the free report model setting method proposed in this application, if so, the design block of the parent cell for inter-cell relationship is obtained, specifically including the following steps:

[0064] Step S302: Determine if the design block of the parent cell exists in the inter-cell relationship;

[0065] Step S304: If yes, record the business cell in the design block of the parent cell of the inter-cell relationship;

[0066] Step S306: If not, construct the design block of the parent cell for inter-cell relationships.

[0067] In this embodiment, obtaining the design block of the parent cell in the inter-cell relationship specifically involves determining whether the design block of the parent cell in the inter-cell relationship exists. If the parent cell design block already exists, the cell is directly recorded in the parent cell design block; otherwise, a design block needs to be constructed for the parent cell, and the processing logic is the same as for this cell.

[0068] like Figure 4 As shown, according to an embodiment of the free report model setting method proposed in this application, the cell information in the design block is processed sequentially, and cells on the same link are grouped together according to the cell information to form a design path. Specifically, the method includes the following steps:

[0069] Step S402: Determine whether the current design block is an unbound block;

[0070] Step S404: If not, obtain the calculation optimization configuration and group the business cells in the design block according to the model source;

[0071] Step S406: Iterate through the cell list of each model source to obtain the cell list data;

[0072] Step S408: Construct the main design path based on the cell list data;

[0073] Step S410: Based on the calculated optimization configuration, construct the optimized design path. The construction method of the optimized design path includes the complex design block method and / or the simple design block method.

[0074] In this embodiment, cell information within the design block is processed sequentially. Cells on the same link are grouped together based on the cell information to form a design path. Specifically, it is determined whether the current design block is an unbound block. If the current block is unbound, no processing is required. Otherwise, the system's computational optimization configuration is obtained in advance, and the cells in the design block are grouped according to their model source. Then, the cell list under each model source is traversed one by one to obtain the cell list data. Based on the cell list data, the main design path is constructed. Based on the computational optimization configuration, an optimized design path is constructed using either a complex design block method or a simple design block method. By performing computational optimization based solely on the design path, the accuracy of the calculation results can be guaranteed.

[0075] like Figure 5 As shown, the free report model setting method according to an embodiment of this application constructs an optimized design path based on the calculated optimized configuration, specifically including the following steps:

[0076] Step S502: Extract leaf nodes;

[0077] Step S504: Construct a path based on the leaf nodes;

[0078] Step S506: After construction, optimization processing is performed to obtain the optimized design path.

[0079] In this embodiment, an optimized design path is constructed using a complex design block method. Specifically, leaf nodes are first extracted, then a path is constructed based on the leaf nodes, and finally optimized to obtain the optimized design path. The complex design block method constructs the design path from the last level to the root node according to the leaf nodes. Constructing the optimized design path using this method ensures the accuracy of the calculation results.

[0080] like Figure 6 As shown, the free report model setting method according to another embodiment of this application constructs an optimized design path based on the calculated optimized configuration, specifically including the following steps:

[0081] Step S602: Extract the root node;

[0082] Step S604: Construct the path based on the root node;

[0083] Step S606: After construction, optimization processing is performed to obtain the optimized design path.

[0084] In this embodiment, an optimized design path is constructed using a simple design block method. Specifically, the root node is first extracted. Then, a path is constructed based on the root node. After construction, optimization processing is performed to obtain the optimized design path. The simple design block method constructs the design path from the root node to the child nodes, ensuring the accuracy of the calculation results.

[0085] like Figure 7 As shown, the method for setting up a free report model according to an embodiment of this application, which performs structured processing on business cells to obtain design blocks, further includes the following steps:

[0086] Step S702: Obtain the design block conditions.

[0087] In this embodiment, recording the design block conditions during the structuring process of the business cells can prepare for subsequent design block-level business data filtering.

[0088] like Figure 8 As shown, an embodiment of the second aspect of this application provides a model setting system 10 for a free report, including: an acquisition module 110 for acquiring a cell list, the cell list including multiple design cells; a conversion module 120 for converting the design cells to obtain business cells; a design block forming module 130 for performing structured processing on the business cells to obtain design blocks; and a design path forming module 140 for sequentially processing the cell information in the design blocks, and grouping cells on the same link together according to the cell information to form a design path.

[0089] The model setting system 10 for free reports provided in this embodiment includes an acquisition module 110, a conversion module 120, a design block formation module 130, and a design path formation module 140. The acquisition module 110 acquires a list of cells, which includes multiple design cells. The conversion module 120 converts the design cells to obtain business cells. The design block formation module 130 performs structured processing on the business cells to obtain design blocks. The design path formation module 140 processes the cell information in the design blocks sequentially, grouping cells on the same path together to form a design path. By adding design block and design path layers, the system better aligns with the design philosophy of free reports, providing clear hierarchical execution and facilitating subsequent code maintenance and expansion. It meets the customer's requirement that cell conditions apply to the entire block, and the expanded layers allow for more granular enrichment of the free report's functionalities. Furthermore, it ensures controllable space usage and keeps the execution time within a certain range, preventing server crashes due to prolonged business operations.

[0090] like Figure 9 As shown, an embodiment of the third aspect of this application provides a free report model setting system 20, including: a memory 300 and a processor 400, wherein the memory 300 stores a program or instructions that can be run on the processor 400, and when the processor 400 executes the program or instructions, it implements the steps of the free report model setting method of any one of the embodiments of the first aspect, and thus has the technical effects of any embodiment of the first aspect, which will not be repeated here.

[0091] An embodiment of the fourth aspect of this application provides a readable storage medium having a program or instructions stored thereon. When the program or instructions are executed by a processor, they implement the steps of the model setting method for a free report of any one of the embodiments of the first aspect, and thus have the technical effects of any of the embodiments of the first aspect described above, which will not be repeated here.

[0092] like Figures 10 to 15 As shown, according to a specific embodiment of the free report model setting method provided in this application, after receiving the cell list, the server performs business cell conversion, collecting condition information on the cells in advance during the conversion process. Subsequently, the business cells are structured to form design blocks, and the conditions of the design blocks are recorded during the structuring process to prepare for subsequent design block-level business data filtering. After block identification is completed, the cell information in the design blocks is processed one by one, and cells with the same design path are identified together to form a design path.

[0093] like Figure 10 As shown, the process for constructing a design block is as follows: Traverse the cell list. If the current cell is the root (no parent cell exists), construct a design block for it and record this cell in the design block, then continue processing other cells. Otherwise, if this cell is not the root (a parent cell exists), obtain the design block of the parent cell. If the parent cell's design block already exists, directly record this cell in the parent cell's design block; otherwise, construct a design block for the parent cell, with the same processing logic as for this cell. After all cells are processed, a list of design blocks is obtained, and then other business processes are performed.

[0094] like Figure 11As shown, the process for constructing design blocks is as follows: If the current processing block is an unbound block, no processing is required. Otherwise, the system's calculation optimization configuration is obtained in advance, and then the cells in the design block are grouped according to their model source. The cell list under each model source is traversed one by one. First, the main design path is constructed, and then, based on the calculation optimization configuration value, if true, an optimized design path is constructed; otherwise, no optimized design path is constructed. The construction of the optimized path is divided into two different processing methods: complex design blocks and simple design blocks. Complex design paths are constructed from the leaf nodes to the root node, while simple design blocks are constructed from the root node to the child nodes. After construction, optimization processing is performed, and each path is finely split, such as attempting to split avg and discount. After processing, the design paths are attempted to be merged. If a branch path differs from the main path, it is marked as requiring optimization calculation.

[0095] like Figure 12 , Figure 13 , Figure 14 and Figure 15 As shown, the header filtering is verified to be effective for the entire block based on the free report test cases. The browsing state effect is as follows. Figure 13 As shown, the effect after performing header filtering is as follows: Figure 14 As shown, the effect after filtering the old logic table header is as follows: Figure 15 As shown.

[0096] In summary, the beneficial effects of the embodiments of this application are as follows:

[0097] 1. The model has a clear and distinct hierarchy. Based on the original model hierarchy, the server adds a design block layer and a design path layer at runtime, which is more in line with the design concept of free reports. The hierarchy is clear during execution, which facilitates subsequent code maintenance and expansion.

[0098] 2. It meets the customer's need for cell conditions to apply to the entire block, and based on the extended hierarchy, it can enrich the functional features of the free report with more granularity.

[0099] 3. It can perform calculation optimizations independently based on the design path, ensuring the accuracy of the calculation results.

[0100] 4. Ensure that the space usage of free reports is controllable, including controlling the maximum business data of each cell and the total business data of a block.

[0101] 5. Ensure that the execution time of free reports is controlled within a certain range to avoid server crashes due to prolonged business operations.

[0102] In this application, the terms "first," "second," and "third" are used for descriptive purposes only and should not be construed as indicating or implying relative importance; the term "multiple" refers to two or more unless otherwise expressly defined. The terms "install," "connect," "link," and "fix" should be interpreted broadly. For example, "connect" can mean a fixed connection, a detachable connection, or an integral connection; "link" can mean a direct connection or an indirect connection through an intermediate medium. Those skilled in the art can understand the specific meaning of the above terms in this application based on the specific circumstances.

[0103] In the description of this application, it should be understood that the terms "upper", "lower", "front", "rear", etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings. They are only for the convenience of describing this application and simplifying the description, and do not indicate or imply that the device or module referred to must have a specific orientation or be constructed and operated in a specific orientation. Therefore, they should not be construed as limitations on this application.

[0104] In the description of this specification, the terms "one embodiment," "some embodiments," "specific embodiment," etc., refer to a specific feature, structure, material, or characteristic described in connection with that embodiment or example, which is included in at least one embodiment or example of this application. In this specification, the illustrative expressions of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples.

[0105] The above are merely preferred embodiments of this application and are not intended to limit this application. Various modifications and variations can be made to this application by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of this application should be included within the protection scope of this application.

Claims

1. A method for setting up a model for a free report, characterized in that, include: Get a list of cells, which includes multiple design cells; The design cells are transformed to obtain business cells; The business cells are structured to obtain design blocks; The cell information in the design block is processed sequentially, and cells on the same link are grouped together based on the cell information to form a design path; The step of structuring the business cells to obtain design blocks specifically includes: Iterate through the list of cells; Determine if the current business cell has a parent cell relationship; If not, construct a design block and record the business cell into the design block; If so, then obtain the design block of the parent cell of the inter-cell relationship; If so, then the design block of the parent cell in the inter-cell relationship is obtained, specifically including: Determine whether the design block of the parent cell in the inter-cell relationship exists; If so, the business cell is recorded in the design block of the parent cell of the inter-cell relationship; If not, then construct the design block for the parent cell of the inter-cell relationship; The step of sequentially processing the cell information in the design block, and grouping cells on the same link together based on the cell information to form a design path, specifically includes: Determine whether the current design block is an unbound block; If not, obtain the computational optimization configuration and group the business cells in the design block according to the model source; Iterate through the cell list from each of the models to obtain the cell list data; Construct the main design path based on the cell list data; Based on the computationally optimized configuration, an optimized design path is constructed. The method for constructing the optimized design path includes a complex design block method and / or a simple design block method.

2. The method for setting up a free report model according to claim 1, characterized in that, The step of constructing an optimized design path based on the calculated optimized configuration specifically includes: Extract the leaf nodes; Construct a path based on the leaf nodes; After construction, optimization is performed to obtain the optimized design path.

3. The method for setting up a free report model according to claim 1, characterized in that, The step of constructing an optimized design path based on the calculated optimized configuration specifically includes: Extract the root node; Construct a path based on the root node; After construction, optimization is performed to obtain the optimized design path.

4. The method for setting up a model for a free report according to any one of claims 1 to 3, characterized in that, The step of structuring the business cells to obtain design blocks also includes: Obtain the design block conditions.

5. A model setting system for free reports, characterized in that, include: The acquisition module (110) is used to acquire a list of cells, which includes multiple design cells; The conversion module (120) is used to convert the design cells to obtain business cells; The design block forming module (130) is used to perform structured processing on the business cells to obtain design blocks; The design path forming module (140) is used to process the cell information in the design block in sequence, and to gather the cells on the same link together according to the cell information to form a design path; The step of structuring the business cells to obtain design blocks specifically includes: Iterate through the list of cells; Determine if the current business cell has a parent cell relationship; If not, construct a design block and record the business cell into the design block; If so, then obtain the design block of the parent cell of the inter-cell relationship; If so, then the design block of the parent cell in the inter-cell relationship is obtained, specifically including: Determine whether the design block of the parent cell in the inter-cell relationship exists; If so, the business cell is recorded in the design block of the parent cell of the inter-cell relationship; If not, then construct the design block for the parent cell of the inter-cell relationship; The step of sequentially processing the cell information in the design block, and grouping cells on the same link together based on the cell information to form a design path, specifically includes: Determine whether the current design block is an unbound block; If not, obtain the computational optimization configuration and group the business cells in the design block according to the model source; Iterate through the cell list from each of the models to obtain the cell list data; Construct the main design path based on the cell list data; Based on the computationally optimized configuration, an optimized design path is constructed. The method for constructing the optimized design path includes a complex design block method and / or a simple design block method.

6. A model setting system for free reports, characterized in that, include: A memory (300) and a processor (400), wherein the memory (300) stores a program or instructions executable on the processor (400), and the processor (400) executes the program or instructions to implement the steps of the model setting method for a free report as described in any one of claims 1 to 4.

7. A readable storage medium having a program or instructions stored thereon, characterized in that, When the program or the instructions are executed by the processor, they implement the steps of the model setting method for the free report as described in any one of claims 1 to 4.

Images