Report development method and system capable of realizing code-free configuration

By decomposing the report creation process into multiple creation steps and abstracting the coding corresponding to these steps into a rule model, a visual user operation interface is provided, and the existing report development system requires professional programming, achieving an efficient, flexible and low-cost solution for users to develop reports without coding.

CN120144112AInactive Publication Date: 2025-06-13ANHUI PROVINCE HIGHWAY & PORT ENG CO LTD
View PDF 3 Cites 0 Cited by

Patent Information

Application Number
CN202510341498.6
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-03-21
Publication Date
2025-06-13
Estimated Expiration
Not applicable · inactive patent

AI Technical Summary

Technical Problem

The existing report development system requires professional programming, resulting in a long development cycle, high labor costs, and changes in report demands require reprogramming, which is high maintenance costs.

Method used

By decomposing the report creation process into multiple creation steps and abstracting the encoding corresponding to these steps into a rule model, providing a visual user operation interface, users can carry out report development without encoding.

Benefits of technology

It enables users to develop reports without directly facing encoding, improves report development efficiency, reduces maintenance costs, and improves flexibility.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN120144112A_ABST
    Figure CN120144112A_ABST
Patent Text Reader

Abstract

The invention provides a method and a system for developing a report without code configuration. The method comprises the following steps of: decomposing a report creation process into small steps; codes corresponding to all the small steps are abstracted into corresponding rule models in advance to be packaged, and corresponding visual user operation interfaces are provided; when a user defines a table template, a report area, a data source, an access number and a statistical number through the visual user operation interface, calling and storing the corresponding rule models one by one; when the report template is analyzed, the stored rule model is analyzed into corresponding codes for execution, and a report is generated. Specific development of the report is directly oriented to a user instead of a programmer, the whole process of configuring the report is operated in a visual user operation interface, and the user does not need to directly face codes, so that non-coding of the report developed by the user is realized, the development efficiency is high, and the maintenance cost of a program is extremely low.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of report development. More precisely, it relates to a report development method and system that can be configured without coding. Background Art

[0002] A report (forms for reporting to the higher organizations) refers to a form for reporting situations to higher-level authorities. Simply put, a report is a form or chart that dynamically displays data, which can be expressed by the formula: "Report = diverse formats + dynamic data". Therefore, a report mainly consists of tables, data, and data analysis and processing rules.

[0003] Many existing report development systems on the market use OLAP technology for report data analysis. However, these systems all require professional database technicians to perform report data analysis and processing through professional programming, and then business personnel define report templates to form business reports required by customers. This system and method involve programmers directly writing executable code for the computer to execute, thereby generating reports. Report requirements such as data sources, dimensions, and metrics of statistical data need to be solidified in the executable code. After the code is executed by the computer, reports are directly generated. Since each requirement needs to be coded, it results in a long development cycle, requires collaborative development between technical personnel and business personnel, high labor costs, and once report requirements change, reprogramming and development are needed, directly modifying the code, which is not flexible and has extremely high maintenance costs. Summary of the Invention

[0004] The technical problem to be solved by the present invention is to provide a report development method and system without coding. Users use a visual interface to extract and statistically process data in the way of creating tables, dimensions, and metrics to complete report development. Users developing reports do not need to directly face coding, and the entire process of configuring reports is operated in the visual user operation interface, thereby realizing non-coding report development for users.

[0005] The method of the present invention is implemented as follows: A report development method that can be configured without coding includes the following steps: Decompose the creation process of the report into several creation steps; Pre-abstract the codes corresponding to the creation steps into corresponding rule models for encapsulation, and provide a corresponding visual user operation interface; among them, the "rule model" can be understood as a set of logically summarized rules. When the user operates the creation steps through the visual user operation interface, the rule models corresponding to the creation steps are called and saved one by one; When parsing the report template, the saved rule model will be parsed into corresponding codes for execution to generate a report.

[0006] Furthermore, the several creation steps include a step of defining a table template, a step of defining a data source, a step of defining a report area, a step of fetching data, and a step of counting data.

[0007] Furthermore, the operation of the user performing the creation steps through the visual user operation interface specifically includes: Step S1: Draw a table using the table template; Step S2: Define the data source, that is, define the data source of the report; Step S3: Define the report area; the defining of the report area is to select corresponding areas in the drawn table template and define them as different areas respectively. The different areas include a header area, a footer area, and a data area. The area behavior or layout behavior of each area corresponds to a pre-abstracted and encapsulated rule model for the user to select and configure in the visual user operation interface; the different areas also include a dimension area, an index area, a template area, or a grouping area; Step S4: Reference the original table, multi-dimensional table, view table, synthetic table, or result set of the data source. If the multi-dimensional table, view table, synthetic table, or result set to be referenced does not exist, create it and then reference it; bind fields to the cells of the report template; Step S6: Parse the report template to generate a report.

[0008] Furthermore, between step S4 and step S6, there is also Step 5: Perform data slicing according to the created dimensions and indexes.

[0009] Furthermore, the creation process of the multi-dimensional table: Step S11: Define the data source, that is, define the data source of the multi-dimensional table; Step S12: Select the original table, existing multi-dimensional table, existing view table, existing result set, or existing synthetic table to be referenced; Step S13: Create dimensions and indexes on the selected tables; Step S14: Perform data slicing according to the created dimensions and indexes, thereby completing the creation of a new multi-dimensional table.

[0010] Furthermore, the creation process of the view table: Step S21: Define the data source, that is, define the data source of the view table; Step S22: Fill in the name of the view table; Step S23: Select the original table, existing view table, multi-dimensional table, or existing synthetic table to be referenced; Step S24: Configure the basic information; Step S25: Configure the association conditions and filtering conditions between the selected tables; Step S26: Generate a new view table.

[0011] Furthermore, the creation process of the result set: Step S31: Define the data source, that is, define the data source of the result set; Step S32: Fill in the name of the result set; Step S33: Select the original tables, existing view tables, multi-dimensional tables or existing synthetic tables to be referenced; Step S34: Configure the basic information; Step S35: Define parameters; Step S36: Configure the association conditions and filtering conditions between the selected tables; Step S37: Save the association conditions and filtering conditions between the selected tables, including the query field information and the name of the SQL rule, and generate a new result set.

[0012] Furthermore, the creation process of the synthetic table: Step S41: Define the data source, that is, define the data source of the synthetic table; Step S42: Fill in the name of the synthetic table; Step S43: Select the original tables, existing view tables, multi-dimensional tables or existing synthetic tables to be referenced; Step S44: Configure the basic information; Step S45: Configure the association conditions and filtering conditions between the selected tables; Step S46: Generate a new synthetic table, which copies the data of the selected tables and synchronizes with the data of the selected tables.

[0013] Furthermore, the definition of the data source is to fill in the address of the data source in the visual user operation interface, and also includes filling in the database name, username, and password.

[0014] The system of the present invention is implemented as follows: A report development system that can be configured without coding, including a plurality of creation step modules, a report parsing module, and a visual user operation interface; Each of the creation step modules corresponds to a creation step in the report creation process, and the encoding corresponding to each creation step is pre-abstracted into a corresponding rule model for encapsulation. When the user operates the creation step through the visual user operation interface, the rule models corresponding to the creation steps are called and saved one by one; The report parsing module is used to parse and generate a report. When parsing, the saved rule models will be parsed into corresponding encodings for execution; The visual user operation interface is for the user to perform operations in the creation step through the visual user operation interface.

[0015] The present invention has the following advantages: The report development of the present invention is directly oriented to users rather than programmers. For users, the development of reports is completed through configuration. The codes corresponding to the configuration rules are pre-encapsulated by programmers into rule models. During the configuration process, the background will correspondingly call the encapsulated rule models for saving for subsequent conversion into codes for computer execution to generate reports. The users developing reports do not need to directly face the codes. The whole process of configuring reports is operated in the visual user operation interface, thus realizing the non-coding of user report development. Therefore, the development platform only needs to pre-encapsulate enough rule models by programmers. Of course, if new configuration rules are to be added, only a small piece of code needs to be added by programmers and encapsulated into a rule model and added, without changing the large framework of the original development platform, with extremely small workload and extremely small error rate. Obviously, the present invention can greatly improve the report development efficiency and can greatly save the program maintenance cost. Description of the Drawings

[0016] Figure 1 It is a flowchart of the method execution of the present invention; Figure 2 It is a state legend when the user defines the table data source in the present invention; Figure 3 It is a state legend when the user defines the report area in the present invention; Figure 4 It is a state legend when the user binds fields on the report template cells in the present invention; Figure 5 It is a block diagram of the architecture of the system of the present invention. Detailed Embodiments

[0017] Embodiment 1: A preferred embodiment of the report development method with non-coding configuration of the present invention includes the following steps: Decompose the creation process of the report into steps including defining the table template, defining the report area, defining the data source, fetching data, and counting data; The encodings corresponding to the steps of defining a table template, the encodings corresponding to the steps of defining a report area, the encodings corresponding to the steps of defining a data source, the encodings corresponding to the data fetching steps, and the encodings corresponding to the statistical number steps are pre-abstracted into corresponding rule models for encapsulation, and a corresponding visual user operation interface is provided; the rule model can be understood as a set of logically pre-summarized rules. In the present invention, defining a table template is defining a set of style rules for a report; defining a report area is defining rules for filling cell data, cell merging, etc. from top to bottom or from left to right; defining a data source is defining an address rule for the data source; data fetching is defining a set of rules for fetching data from the data source (fetching data according to the selected table and the associated conditions and filtering conditions of the table); statistical number is defining a set of rules for statistically analyzing the data source data (statistically analyzing the data according to dimensions and metrics).

[0018] When the user defines a table template, defines a report area, defines a data source, fetches data, and statistically analyzes the data through the visual user operation interface, the corresponding rule models are called and saved one by one; When parsing the report template, the saved rule models will be parsed into corresponding encodings for execution to generate a report.

[0019] As Figure 1 shown, the specific steps for the user to define a table template, define a report area, define a data source, fetch data, and statistically analyze the data through the visual user operation interface include: Step S1: Use the table template to draw a table, for example, a table can be drawn through the CELL table plugin; Step S2: Define the table data source through the configuration form, as Figure 2 shown, that is, fill in the address of the data source in the visual user operation interface, or fill in the database name, username, and password; Step S3: Define the report area through the configuration form, as Figure 3 shown, the corresponding area can be selected in the drawn table template by the mouse and defined as the header area, the footer area, and the data area respectively. According to needs, the dimension area, the index area, the template area, or the grouping area can also be defined. The area behavior or layout behavior of each area corresponds to a pre-abstracted and encapsulated rule model for the user to select and configure in the visual user operation interface; among them, the dimension area and the index area can implement reports with row merging, column merging, or both row and column merging; the grouping area can implement a grouped report with a fixed hierarchical style; the template area can implement a report with irregular cell merging, and the cell merging rules should be enumerable; and the area behavior, for example, whether the cells in the area are filled from top to bottom or from left to right; the area layout behavior, for example, whether the area is row cell merging, irregular cell merging, or hierarchical display.

[0020] Step S4: Refer to the original table, multi-dimensional table, view table, synthetic table or result set of the table data source. If the multi-dimensional table, view table, synthetic table or result set to be referred does not exist, create it and then refer to it; among them, the original table, multi-dimensional table, view table, synthetic table or result set is the data source of the report, and it exists independently of the report; for another example Figure 4 As shown, bind fields to the cells of the report template to complete data extraction; Step S5: If statistical data is required, configuration operations for statistical data can be further performed, that is, data slicing is performed according to the created dimensions and metrics; Step S6: Finally, parse the report template to generate a report. Among them, the parsing process is performed in the background, and the user only needs to click the save button for the operation.

[0021] Among them, the multi-dimensional table is an intermediate calculation table, and its function is for data statistics. The creation process of the multi-dimensional table is as follows: Step S11: Define the data source of the multi-dimensional table. This step is the same as the operation in Step 1 above; Step S12: Select the original table, existing multi-dimensional table, existing view table, existing result set or existing synthetic table to be referred in the defined data source. One or more identical or different tables can be selected according to needs. For example, one original table and one existing view table can be selected, or more than two existing synthetic tables or existing multi-dimensional tables can be selected; Step S13: Create dimensions and metrics on each selected table. The dimension refers to the statistical object of the report. For example, the cumulative rainfall in a certain year is statistically analyzed through the time dimension, or the cumulative rainfall in a certain area is statistically analyzed through the area dimension, or the cumulative rainfall in a certain region in a certain year is statistically analyzed through the time dimension and the area dimension; the metric refers to the statistical rule, such as sum, average value, sample number, mean square deviation, etc. The user's creation process is only to select in the list of the visual user operation interface. The corresponding codes of possible statistical objects and statistical rules have been pre-encapsulated as rule models in the list. After the user selects, the corresponding rule model can be saved for subsequent parsing and execution; Step S14: Perform data slicing according to the created dimensions and metrics. For example, the cumulative rainfall in a certain region in a certain year is a data slice, which is a data slice generated according to the time dimension, the area dimension and the rainfall sum metric. During the slicing process, the saved rule model is parsed into the corresponding codes for execution, so as to complete the creation of a new multi-dimensional table.

[0022] Among them, the view table is to splice multiple tables for display, which is convenient for users to view multiple tables at the same time. It is not a real table and only has a display function and does not save data itself. The creation process of the view table is also a visual configuration process. The specific configuration process is as follows: Step S21: Define the data source of the view table. This step is the same as the operation in the aforementioned step S1; Step S22: Fill in the name of the view table to be created, that is, name the view table to be created; Step S23: Select the original tables, existing view tables, multi-dimensional tables, or existing synthetic tables to be referenced from the defined data source. The operation process is the same as step S12; Step S24: Configure basic information. For example, whether to remove duplicates, whether to query all parent node data and child node data. This basic information is also provided to the user for selection in a list. The corresponding codes have been pre-encapsulated into rule models. After the user makes a selection, the corresponding rule model can be saved for subsequent parsing and execution; Step S25: Configure the association conditions and filtering conditions between the selected tables. For example, one table stores rainfall information for all years, and another table stores snowfall information for all years. These two tables can be associated based on the time field information to generate a view containing rainfall and snowfall for all years; The filtering condition is, for example, that the table stores rainfall amounts for all years, and the filtering condition is set to only take the rainfall data for 2016. This condition can be a constant such as "2016" or a parameter; Similarly, this configuration is still selected by the user in a list. The corresponding codes for the association conditions and filtering conditions have been pre-encapsulated into rule models. After the user makes a selection, the corresponding rule model can be saved for subsequent parsing and execution; Step S26: Click Save. The background starts to parse the rule models saved in the above steps, and a new view table can be generated.

[0023] Embodiment 2: Based on Embodiment 1, Embodiment 2 of the present application provides a more specific report development method with no coding configuration, including: Decompose the creation process of the report into steps including defining the table template, defining the report area, defining the data source, fetching data, and counting data; Pre-abstract the codes corresponding to the step of defining the table template, the step of defining the report area, the step of defining the data source, the step of fetching data, and the step of counting data into corresponding rule models for encapsulation, and provide a corresponding visual user operation interface.

[0024] When the user defines the table template, defines the report area, defines the data source, fetches data, and counts data through the visual user operation interface, the corresponding rule models are called and saved one by one; When parsing the report template, the saved rule models will be parsed into corresponding codes for execution to generate a report.

[0025] Such asFigure 1 As shown in the figure, the specific steps for the user to define a table template, define a report area, define a data source, fetch data, and count data through the visual user operation interface are as follows: Step S1: Draw a table using the table template. For example, the table can be drawn through the CELL table plugin. Step S2: Define the table data source through the configuration form. For example, Figure 2 as shown in the figure, that is, fill in the address of the data source in the visual user operation interface, or fill in the database name, username, and password. Step S3: Define the report area through the configuration form. For example, Figure 3 as shown in the figure, the corresponding area in the drawn table template can be selected by the mouse and defined as the header area, footer area, and data area respectively. According to needs, the dimension area, index area, template area, or grouping area can also be defined.

[0026] Step S4: Reference the original table, multi-dimensional table, view table, synthetic table, or result set of the table data source. If the multi-dimensional table, view table, synthetic table, or result set to be referenced does not exist, create it and then reference it. For another example, Figure 4 as shown in the figure, bind fields on the cells of the report template to complete data fetching. Step S5: If data counting is required, the configuration operation for data counting can be further performed, that is, data slicing is performed according to the created dimensions and indexes. Step S6: Finally, parse the report template to generate a report. Among them, the parsing process is performed in the background, and the user only needs to click the save button for the operation.

[0027] Among them, the result set is similar to the view table and is also formed by splicing multiple tables for display. However, it has an additional process of defining parameters compared to the view table, that is, defining the association conditions and filtering conditions between the selected tables. During the creation process, other unnecessary parameters can be discarded according to the association conditions and filtering conditions, making the display result more concentrated and prominent. The creation process of the result set is also a visual configuration process, and the specific configuration process is as follows: Step S31: Define the data source. This step is the same as the operation in the aforementioned step S1. Step S32: Fill in the name of the result set, that is, name the result set to be created. Step S33: Select the original table, existing view table, multi-dimensional table, or existing synthetic table to be referenced. Step S34: Configure the basic information. This step is the same as the operation in the aforementioned step S24. Step S35: Define parameters. The parameters here are, for example, conditional filtering parameters. The parameters will be opened, and when using the result set, the values of the parameters need to be specified for the result set to return data. Step S36: Configure conditions, that is, configure the association conditions and filtering conditions between the selected tables. For example, one table stores rainfall information for all years, and another table stores snowfall information for all years. These two tables can be associated based on the time field information to generate a view containing rainfall and snowfall for all years. The filtering condition is, for example, the table stores rainfall amounts for all years, and the filtering condition is set to only retrieve the rainfall data for 2016. Similarly, this configuration is still carried out in the way of user selection in the list. The encodings corresponding to the association conditions and filtering conditions have been pre-encapsulated as rule models. After the user makes a selection, the corresponding rule model can be saved for subsequent parsing and execution. Step S37: Save the association conditions and filtering conditions between the configured selected tables, including the query field information and the name of the SQL rule, and generate a new result set.

[0028] Among them, the synthetic table is similar to the view table but still has differences. The difference is that the synthetic table needs to save the data of the referenced tables, so it is a real table in the true sense. Therefore, when the data of the referenced tables changes, it needs to be synchronized to this synthetic table. Therefore, the synthetic table also includes the step of synchronizing data. The creation process of the synthetic table is also a visual configuration process, and the specific configuration process is as follows: Step S41: Define the data source, that is, define the data source of the synthetic table; Step S42: Fill in the name of the synthetic table; Step S43: Select the original tables, existing view tables, multi-dimensional tables, or existing synthetic tables to be referenced; Step S44: Configure the basic information; Step S45: Configure the association conditions and filtering conditions between the selected tables; Step S46: After clicking save, the background starts to parse the rule model saved in the above steps to generate a new synthetic table, which copies the data of the selected tables and synchronizes with the data of the selected tables.

[0029] It should be noted that the same or similar parts in this embodiment and Embodiment 1 can be referred to each other and will not be elaborated in this application.

[0030] Embodiment 3: Based on Embodiment 2, the present invention further provides a report development system that can be configured without coding, which includes a data definer 100, a report definer 200, a parsed report module 300, and a visual user operation interface 400; The data definer 100 includes: A define data source module 101, which pre-abstracts the encoding corresponding to the process of defining the data source as a rule model for encapsulation. When the user performs the operation of defining the data source, this rule model is retrieved and saved; The data fetching module 102 abstracts the encoding corresponding to the data fetching process into a rule model in advance for encapsulation. When the user performs a data fetching operation, this rule model is retrieved and saved. The statistical data module 103 abstracts the encoding corresponding to the statistical data process into a rule model in advance for encapsulation. When the user performs a statistical data operation, this rule model is retrieved and saved. The report definition device 200 includes: The table template definition module 201, which is for the user to draw the table of the report and can be a CELL table plug-in. The report area definition module 202 abstracts the encoding corresponding to the report area definition process into a rule model in advance for encapsulation. When the user performs a report area definition operation, this rule model is retrieved and saved. It enables the user to select corresponding areas in the drawn table template through the mouse and define them as the header area, the footer area, and the data area respectively. According to needs, the dimension area, the index area, the template area, or the grouping area can also be defined. The area behavior or layout behavior of each area corresponds to a pre-abstracted and encapsulated rule model for the user to select and configure in the visual user operation interface.

[0031] It should be noted that the system provided in this embodiment is the system corresponding to the method provided in Embodiment 2. Therefore, for the parts that are the same or similar in this embodiment and Embodiment 2, reference can be made to each other and will not be elaborated in this application.

[0032] Embodiment 4: Based on Embodiment 3, Embodiment 4 of this application provides a more specific report development system with no-coding configuration, which includes a data definition device 100, a report definition device 200, a report parsing module 300, and a visual user operation interface 400. The report parsing module 300 is used to parse and generate a report. When parsing, the saved rule model is parsed into the corresponding encoding for execution by a computer, a handheld device, etc. The visual user operation interface 400 is an operation entry for the user to define the data source, fetch data, count data, draw a report, and define the report area. Among them, when the user performs the data source definition operation, the user fills in the address of the data source in the visual user operation interface, or also fills in the database name, the user name, and the password. When fetching data, the user selects tables, selects fields, configures the association conditions and filtering conditions between each table, and the source of the basic information of the table, etc. When counting data, the user creates dimensions, indexes, and multi-dimensional tables in the visual user operation interface. Of course, the division of the functions of the above modules in the present invention is not limited to the above embodiments, as long as the total functions of each module can meet the above function requirements. It should be noted that for the parts that are the same or similar in this embodiment and Embodiment 3, reference can be made to each other and will not be elaborated in this application.

[0033] Although the specific embodiments of the present invention have been described above, those skilled in the art should understand that the specific embodiments we described are illustrative rather than used to limit the scope of the present invention. Equivalent modifications and variations made by those skilled in the art in accordance with the spirit of the present invention should be covered by the scope protected by the claims of the present invention.

Claims

1. A report development method that can be configured without coding, characterized in that: The steps include: Break down the report creation process into several creation steps; The codes corresponding to the creation steps are pre-abstracted into corresponding rule models for encapsulation, and a corresponding visual user operation interface is provided; When the user performs the operations of the creation steps through the visual user operation interface, the rule models corresponding to the creation steps are retrieved and saved one by one; When parsing the report template, the saved rule model will be parsed into corresponding codes for execution to generate a report.

2. A report development method capable of non-coding configuration according to claim 1, characterized in that: The several creation steps include a table template definition step, a data source definition step, a report area definition step, a data acquisition step, and a statistical step.

3. A report development method capable of non-coding configuration according to claim 1, characterized in that: The operation of the user performing the creation step through the visual user operation interface specifically includes: Step S1: Draw a table using a table template; Step S2: define the data source, that is, define the data source of the report; Step S3: define report areas; the definition of report areas is to select corresponding areas in the drawn table template to define them as different areas, the different areas include the header area, the footer area, and the data area, and the regional behavior or layout behavior of each area corresponds to a pre-abstracted and encapsulated rule model for the user to select and configure in the visual user operation interface; the different areas also include dimension areas, indicator areas, template areas or grouping areas; Step S4: reference the original table, multidimensional table, view table, composite table or result set of the data source. If the multidimensional table, view table, composite table or result set to be referenced does not exist, create it and then reference it; then bind the field to the report template cell; Step S6: parse the report template and generate a report.

4. A report development method capable of non-coding configuration according to claim 3, characterized in that: The step S4 and step S6 also include Step 5: Slice the data based on the created dimensions and indicators.

5. The report development method capable of non-coding configuration according to claim 3, characterized in that: The creation process of the multidimensional table: Step S11: define the data source, that is, define the data source of the multidimensional table; Step S12: Select an original table to be referenced, an existing multidimensional table, an existing view table, an existing result set or an existing composite table; Step S13: Create dimensions and indicators on each selected table; Step S14: Slice the data according to the created dimensions and indicators, thereby completing the creation of a new multidimensional table.

6. A report development method capable of non-coding configuration according to claim 3, characterized in that: The creation process of the view table: Step S21: define the data source, that is, define the data source of the view table; Step S22: Fill in the name of the view table; Step S23: Select the original table to be referenced, an existing view table, a multidimensional table or an existing composite table; Step S24: configure basic information; Step S25: configuring association conditions and filtering conditions between the selected tables; Step S26: Generate a new view table.

7. A report development method capable of non-coding configuration according to claim 3, characterized in that: The creation process of the result set is as follows: Step S31: define the data source, that is, define the data source of the result set; Step S32: Fill in the name of the result set; Step S33: Select the original table to be referenced, an existing view table, a multidimensional table or an existing composite table; Step S34: configure basic information; Step S35: define parameters; Step S36: configuring association conditions and filtering conditions between the selected tables; Step S37: Save the association conditions and filter conditions between the selected tables, including the query field information and the name of the SQL rule, and generate a new result set.

8. The report development method capable of non-coding configuration according to claim 3, characterized in that: The creation process of the synthesis table is as follows: Step S41: define the data source, that is, define the data source of the synthesis table; Step S42: Fill in the name of the synthesis table; Step S43: Select the original table to be referenced, an existing view table, a multidimensional table or an existing composite table; Step S44: configure basic information; Step S45: configuring association conditions and filtering conditions between the selected tables; Step S46: Generate a new synthesis table, which copies the data of the selected table and is synchronized with the data of the selected table.

9. A report development method capable of non-coding configuration according to any one of claims 3 to 8, characterized in that: Defining the data source is to fill in the address of the data source in the visual user operation interface; defining the data source also includes filling in the database name, user name and password of the data source.

10. A report development system that can be configured without coding, characterized in that: It includes multiple creation step modules, report analysis module and visual user operation interface; Each of the creation step modules corresponds to a creation step in the report creation process. The code corresponding to each creation step is pre-abstracted as a corresponding rule model for encapsulation. When the user operates the creation step through the visual user operation interface, the rule models corresponding to the creation step are retrieved and saved one by one. The report parsing module is used to parse and generate reports. During parsing, the saved rule model will be parsed into corresponding codes for execution; The visual user operation interface allows the user to perform the operations of the creation step through the visual user operation interface.

Citation Information

Patent Citations

  • Zero-code generation method of application software and generation platform thereof

    CN101470601A

  • Report creation method and device

    CN116611407A

  • Custom report generation method and system

    CN118607497A