Cell grid quotation method based on non-linear report generation method

Abstract

The invention discloses a cell reference method based on a non-linear statement generating method, which belongs to a statement manufacture technology field. In the prior art, the non-linear statement generating method based on a semantic layer only achieves reference of simple relationship cells, and hardly achieves the reference of complex relationship cells stepped over a different nominative area. The method described by the invention, firstly, a byname is given to a quoted filed or an index in a semantic view, then the index needed quote is set operation expression, the quoted filed and the index is expressed as the byname; in the statement design process, when the filed and / or the index carried the byname are / is added in the statement cell, the byname is simultaneously given a corresponding cell; finally, the statement is extended and calculated according to the non-linear statement calculation rule. The method of the invention is used for decreasing operation complexity for the reference of the complex cells in the non-linear statement generating method and increasing statement design efficiency.

Description

technical field [0001] The invention belongs to the technical field of report production, and in particular relates to a cell reference method based on a non-linear report generation method. Background technique [0002] The report is a periodic reflection of the operation and management indicators of the unit and department, and is an important basis for the relevant person in charge to monitor the business operation status and make decisions. With the application of information systems, computer automatic calculation and report generation have gradually replaced traditional manual statistical methods, greatly improving work efficiency and increasing accuracy. [0003] At present, the tool software used to make reports can be divided into two categories: one is a static report making tool represented by Microsoft Excel, which is characterized in that the designed report is static and will not be linked with the data in the database. Automatically increase or decrease the n...

AI Technical Summary

Problems solved by technology

For this kind of calculation, the business personnel can only input the expression according to the current report situation when the report is designed, but this kind of expression is often abstract and difficult to understand, and it is difficult to grasp, which violates the semantic layer and makes it difficult for business personnel to use original design intention

Images