Report data processing device and report data processing method

Abstract

The invention provides a report data processing device, comprising an information storage unit, an initialization loading unit and a lazy loading unit, wherein the information storage unit is used for storing main information and auxiliary information in table cells of a report, and the auxiliary information comprises first loading formation and second loading information; the initialization loading unit is used for loading main information and the first loading information in the table cells when the report is browsed, the main information is displayed in the table cells, and the main information and / or the first loading information is or are used for loading other table cells; and the lazy loading unit is used for loading second loading information lazily according to the received specific trigger action. The invention also provides a report data processing method. Through the technical scheme of the invention, data in the table cells can be loaded by steps, so that the browsing demands of users are met, and the table data can be efficiently loaded and dynamically extended.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a report data processing device and a report data processing method. Background technique [0002] In the field of analytical reports, usually a cell displays a data content, and the cell also stores the value or formula that generates the data content. [0003] But in many cases, not only the displayed data is needed in the report, but also invisible data is needed in many applications. For example, the report usually displays field information such as code, name, quantity, and amount, but does not display the primary key information at the database level to the user. In the front-end application of the report, it is necessary to perform formula-dependent calculations based on the primary key (bring in the Other attributes of business entities), data linkage query or drilling, unique matching, etc., which requires that the primary key information be loaded and r...

AI Technical Summary

Problems solved by technology

[0006] This method first has a problem of loading efficiency, because these three fields are in an equal position and are loaded at the same time when the report is browsed, but it is not sure whether the primary key and code field are used at this time - for example, the user is After clicking the "product name" cell, the joint search is performed according to the product's primary key, so the data is not actually needed before the user performs a similar operation; especially for an analysis table that may have thousands of cells There are even more grids, and the loading efficiency of unit-level information is crucial. The loading of a large amount of "useless" data information is obviously not conducive to user experience

[0007] Secondly, when a certain data processing must act on a specified cell, but depends on data other than the cell, it will bring operational inconsistency to the expansion of the cell

For example, when preparing to group the inventory name field, since the uniqueness of the name field cannot be guaranteed, we hope that the grouping basis is the inventory primary key, and the inventory primary key is hidden in another cell. It is still a secondary grouping, which cannot achieve the required statistical intent-in fact, we only want to group by the primary key field, but the content displayed in the group is the name

Images