Intelligent verification algorithm, method and device for report designer

Abstract

The invention relates to an intelligent verification algorithm, an intelligent verification method and an intelligent verification device for a report designer. The method comprises the following steps of: verifying according to a data source, function parameters, a calculation and display expression, a statistical chart expression, cell cross-reference dependence and the like configured in a report designer template rule, after completing configuration of one item for the report designer automatically triggering verification whether the specifications or requirements of a verification algorithm are met or not, i.e., automatically verifying a design expression or other functions and the like after the design expression or a function is completed, so that the conditions that sending all verification requests to a background for verifying one by one during click storage after the design of an entire report sheet is completed, and causing unnecessary background service pressure are eliminated, and the rapidness and friendliness of report design verification are realized. Verification comprises data source verification, expression verification, function parameter verification, cell verification and the like.

Description

technical field [0001] The invention relates to the field of report calculation and verification processing, in particular to an algorithm, method and device for intelligent verification of a report designer. Background technique [0002] Reports are the basic measures and approaches of enterprise management, the basic business requirements of enterprises, and the basis for implementing BI (business intelligence) strategies. Reports can help enterprises access and format data, and present data information to users in a reliable and secure manner. In-depth insight into the operation of the enterprise is a powerful driving force for the development of the enterprise. [0003] The report designer is a set of visual operation pages for designing reports, and usually provides operation modes such as wizards and drag and drop to improve development efficiency. Reports can be quickly developed through the report designer. The Report Designer provides all configuration and valida...

AI Technical Summary

Problems solved by technology

However, the trigger verification method of the traditional report listed above is just the opposite, which has a great impact on improving the user's work efficiency.

[0007] 2. Verification methods for multi-data source reports: Traditional reports cannot effectively verify dynamic and multi-data source reports; Chinese-style reports have high requirements for data accuracy and complexity; The multi-source of data is also ever-changing, and the multi-source of report data is hardly verified in traditional reports; therefore, we believe that a good verification method, while meeting the various basic verification requirements of the report, It is also necessary to perform better verification processing on the accuracy of the data, and to improve the user's grasp of the accuracy of the data source more efficiently and quickly

[0008] 3. Expression and function verification methods: Traditional reports can only verify expressions and functions based on some relatively basic methods; such as: whether the expression is empty, simple statistical functions, etc.; traditional report expressions cannot support Now the most used JAVASCRIPT operators, cell addresses, data set fields and other verification; at the same time, the function verification of traditional reports does not support data set function verification, etc.; such as: cross-data set function name prefix and parameter verification, etc.

[0009] 4. Cell verification method: The cell verification of traditional reports is mainly to perform basic verification on the data type of the cell or the characters in the cell, such as: whether the cell data type is an integer or floating point number customized by the user etc.; modern cells cannot meet the mutual cross-reference and dependency functions due to many common points, and if there is no circular verification when performing mutual cross-references, it is easy to cause an infinite loop problem caused by cell cross-reference dependencies. Many traditional reports do not support mutual cross-reference circular verification of the cells of the report;

[0010] 5. Display of verification prompt results: When the traditional report verification fails, all verification prompts are displayed by the pop-up prompt box. This method is not very effective in terms of user experience and friendliness, and The efficiency of locating various configuration verification problems is not very high; with the rapid development of computer informatization, users have higher and higher requirements for verification problem prompts. The requirement to quickly locate and prompt the problem is becoming more and more common

Images