Report generation method and device as well as WEB server

Abstract

The invention discloses report generation method and device as well as a WEB server. The method comprises the steps of: receiving a query conditional value, replacing a placeholder of a structural query language (SQL) sentence of a database with the query conditional value; acquiring report data to be queried according to the SQL sentence; storing the acquired data into a temporary table of the database when the report data includes a graph or a matrix; and formatting the stored data and calculating an aggregate item to generate a corresponding report. In the report generation method and device as well as the WEB server which are provided by the invention, the placeholder in the SQL sentence is utilized for access once, and the data of the complicated report is stored into the temporary table of the database, thereby accelerating the access speed and data processing speed and realizing rapid report generation.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a report generation method, device and WEB server. Background technique [0002] refer to figure 1 , the existing report system includes a report generation device 2 and a report design device 3, the report design device 3 is used to generate the configuration data of the report, that is, the format of the report, the report configuration data and the report business data are stored in the database 5, and the report generation device 2 generally Running on the WEB server, when the peripheral object 6 such as enterprise resource planning software (Enterprise Resource Planning, ERP) client calls the report generation device 2, the report generation device 2 calls the report configuration data and corresponding information from the database 5 through the database connection pool 4. report business data, and return the data to the peripheral object 6 after processing to complete the g...

AI Technical Summary

Problems solved by technology

[0003] There are multiple methods for obtaining the report generation device 2. Usually, the structured query language (Structured Query Language, SQL) of the database is used to obtain the data in stages according to the query conditions and store it in the result set of the WEB server memory where the report generation device 2 is located. Then process the data in the result set and return to the peripheral object 6. This report generation method needs to fetch data multiple times and send it back to the WEB server after each fetch. The speed of data fetching is slow and the efficiency is low, especially when the amount of report data is large. And when the data is called remotely, it will affect the running speed of the report system and reduce the report generation speed

Images