Configurable report export design method and system

Abstract

The invention relates to the technical field of computers, in particular to a configurable report export design method and system. The method comprises the steps that a front end requests a back-end report export interface, and a report ID is sent to a back end; the back end obtains a data query class corresponding to the report ID according to the dynamic proxy and reflection mechanism; the back end calls a data query method, confirms a data template corresponding to the report ID, and renders data to generate a report file; the back end imports the generated report file into a file server; and the front end requests the file server according to the file downloading address of the file server, acquires the asynchronously generated file information and downloads the asynchronously generated file information to the local. According to the method, the report export function can be quickly developed and assembled, and the maintenance cost is reduced; and in addition, through the modes of data front batch processing and file asynchronous processing, the front-end request waiting response time is greatly shortened, network timeout is avoided, and the customer experience degree is greatly improved while the efficiency is improved.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and system for exporting and designing configurable reports. Background technique [0002] At present, most business integration systems involve a large number of report query and export functions, which are used for data analysis such as input and output, operational efficiency, hot products, bills, etc., so that system operators can continuously optimize and improve the system, and quickly adapt to the ever-evolving environment. market business. [0003] The traditional report export method is to query data in real time through the interface, then generate an Excel file according to the corresponding template rendering data, and then return the corresponding stream to the front end. Every time a new type of report is added, the corresponding data query needs to be added to the back end. Interfaces, templates, and the logic for generating Excel, developers need to wr...

AI Technical Summary

Problems solved by technology

[0003] The traditional report export method is to query data in real time through the interface, then generate an Excel file according to the corresponding template rendering data, and then return the corresponding stream to the front end. Every time a new type of report is added, the corresponding data query needs to be added to the back end. Interfaces, templates, and the logic for generating Excel, developers need to write a specific back-end interface for each report export type, which will greatly increase the developer’s time cost and resource cost; at the same time, because the data are all real-time queries, the data source may be Different systems and different databases may require multi-table joint query, and there may also be cross-system query, so many network interaction processes need to be designed, which will lead to low query efficiency, long waiting time for response, and even timeout problems; secondly , due to the variety of data sources, it will also bring about the tedious problem of verifying the accuracy of the exported data

Images