Data reading device based on network reports and method

Abstract

The invention provides a data reading device based on network reports and a method. The device comprises a request sending unit, a data acquisition unit, a report creating unit, a data importing unit, a serial number adding unit, a sorting unit, a grouping unit, a dependence numerical value determining unit, a numerical value determining unit and a data output unit, wherein the request sending unit sends a report inquiry request to a network server, the data acquisition unit acquires report data, the report creating unit creates a first intermediate table, a second intermediate table and a third intermediate table, the data importing unit imports the corresponding report data into the first intermediate table, the second intermediate table and the third intermediate table, the serial number adding unit adds a first serial number column into the first intermediate table, and adds a second serial number column into the second intermediate table, the sorting unit sorts out the report data in the first intermediate table, the grouping unit groups the report data in the second intermediate table, the dependence numerical value determining unit determines dependence numerical values, the numerical value range determining unit determines a numerical value range, and the data output unit outputs the corresponding data in the report data to a browser. By the aid of the data reading device and the method in the technical scheme, partial data can be accurately acquired, and insufficiency of cache of a server is avoided.

Description

technical field [0001] The invention relates to the technical field of data acquisition, in particular to a data acquisition device and method based on a network report. Background technique [0002] Reports provide enterprises with the required accurate data through query, statistics and analysis. The most notable feature of an enterprise-level reporting system is its ability to generate highly flexible report formats. Data can be presented to information consumers in various forms, and business reports need to query real-time data for consumers. [0003] Existing reports are designed based on Microsoft's ReportView control interface. This design idea is to hand over most of the work to the control to complete on the web side. The Microsoft Reportview control needs to obtain all the data when displaying the interface, and cache it on the web server. It can only be displayed after memory calculation, and the memory is always occupied during the calculation process. In the ...

AI Technical Summary

Problems solved by technology

[0017] Since the above solution relies on the engine of the ReportView control, the control engine performs data grouping, paging, and small notes, etc. Therefore, the control needs all the data to operate, and large data is cached on the WEB server, which will inevitably lead to memory overflow of the WEB server , the phenomenon that the product runs slower and slower

Images