Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Analytic method, device and operation system of report formula

A technology of formula analysis and analysis method, which is applied in the field of computer software, can solve problems such as repeated citation of formula codes, and achieve the effects of shortening the length of formulas, avoiding repeated citations, and avoiding double calculations

Inactive Publication Date: 2012-05-09
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF3 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the embodiment of the present invention is to provide a report formula analysis method, aiming at solving the problem of repeated reference of the same formula code in the report formula

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Analytic method, device and operation system of report formula
  • Analytic method, device and operation system of report formula
  • Analytic method, device and operation system of report formula

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0029] figure 1 The implementation process of the parsing report formula provided by the embodiment of the present invention is shown, and the details are as follows:

[0030] In step S101, analyze the report formula;

[0031] In step S102, it is judged whether a temporary variable is used in the report formula to represent an expression in the report formula, if yes, step S103 is executed, otherwise, step S104 is executed.

[0032] In the embodiment of the present invention, the method of using a temporary variable to represent an expression is the following function provided by the embodiment of the present invention:

[0033] The function is: V(varID{, exp}), through which a temporary variable is defined to represent the expression in the report formula.

[0034] in:

[0035] The parameter varID is the identifier of the temporary variable, and the value range can be an integer or an English string, and one or more temporary variables can be defined arbitrarily in a formu...

Embodiment 2

[0056] figure 2The structure of the report formula analysis device provided by the embodiment of the present invention is shown, and for the convenience of description, only the parts related to the embodiment of the present invention are shown. The report formula analysis device may be a software unit, a hardware unit, or a combination of software and hardware built into the business system, or integrated into the business system or the application system of the business system as an independent component. in:

[0057] The formula analysis unit 1 is used to analyze the report formula.

[0058] The variable calculation storage unit 2 is configured to create the temporary variable and store the value of the expression in the temporary variable when the formula parsing unit resolves to use a temporary variable to represent an expression in the report formula.

[0059] In the embodiment of the present invention, the following functions provided by the embodiment of the present...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention is suitable for the filed of computer software, and provides an analytic method, a device and an operation system of report formula. The method includes that analyzing the report formula, establishing a temporary variable when the temporary variable is used for showing expression in analysis of the report formula, enabling the value of the expression to be stored in the temporary variable, and reading the value of the temporary variable when the temporary variable is quoted in the analysis of the report formula. The method uses the temporary variable to show the expression in the report formula, thereby avoiding repeated reference and repeated calculation of the same formula code in the report formula, improving execution efficiency, and being convenient to maintain. The action range of the temporary variable is only the current report formula.

Description

technical field [0001] The invention belongs to the field of computer software, and in particular relates to a report formula analysis method, device and business system. Background technique [0002] Most of the traditional report tools summarize and count data by writing program codes and stored procedures. Most of the more advanced reporting tools in the existing technology support writing formulas in report templates for summary and statistics. When executing reports, the report engine parses and executes the formulas. Since writing formulas can be done in the report design tool, the writing difficulty is lower than writing codes, and it is also easy to maintain and deploy, so it has become a mainstream practice. However, in many cases, in order to achieve some relatively complex functions, formulas often need to be written longer and more complicated, and repeated formula codes often appear, making: the formula becomes longer and the readability is reduced; the modific...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/24
Inventor 黄勇乔昕明
Owner KINGDEE SOFTWARE(CHINA) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products