XML (Extensible Markup Language)-based report generating method

Abstract

The invention discloses an XML (Extensible Markup Language)-based report generating method, comprising the steps of: a system presetting a general report template and a CSS (Cascading Style Sheet) file for controlling the style of a report; receiving the uploaded XML report data file, and generating a report design file according to the XML report data file and the general report template, wherein the XML report data file is used for saving report logics required by services; generating a report according to a data source provided by a database, the report design file and the CSS file, and providing the report to the service for displaying. The method can simplify the report generating mode.

Description

technical field [0001] This application relates to computer technology, in particular to a report generation method based on XML. Background technique [0002] Currently, in the computer field, there are two relatively common ways of generating reports. Among them, one is by writing codes, and the other is by creating reports through the report library. Both of these methods have significant limitations. Specifically, in the way of generating reports through code, for any new report function, it is necessary to develop code and re-release the version; while the way of creating reports through the report library can only be used for a limited number of preset indicators and objects. Production reports, once the business is complex, the function realization and performance will face bottlenecks. [0003] For example, the invention patent application with the application number 201110152520.0 and the invention title "Method and Device for Generating Performance Reports" uses...

AI Technical Summary

Problems solved by technology

[0007] 2. By customizing the report, the user can configure the report, but once the logic is complicated, the data model needs to be rebuilt, and the performance cost rises sharply;

[0008] Specifically, in order to avoid each new report, there is a report generation method without modifying the code. By writing a huge SQL statement, all the data models must be associated in advance. Once the intermediate logic changes, the change will be huge. In addition, due to the The associated operation of all index tables, the general SQL is extremely complex, and the performance faces great challenges;

[0009] 3. At present, the business usually not only presents the business in the form of reports, but also needs to combine graphics and reports. At present, there is no solution that can achieve the rich presentation of the upper picture and the lower table only through a very simple XML

[0010] Specifically, reports and graphs can be presented through the graphics of Birt itself, but the graphics effect of Birt is very poor, and it cannot provide support for the current popular ECharts. In the current solution, new reports and new graphics need to be generated through The code is written separately, and it is impossible to configure an XML file. It can display reports alone or combine charts without modifying the code.

[0011] 4. XML files are used as data sources. When encountering a scenario with a large amount of data, the XML load will become very heavy, and the separation of data and styles is not achieved.

[0012] Specifically, some schemes automatically generate XML containing original data through certain rules. One is that the data is huge, and the performance will face a huge bottleneck. In addition, it is very inconvenient for related queries. The original data is stored in the database, so there is no such problem.

[0013] 5. In the JSP environment, Excel is generated through XML, and the versatility is not high

[0014] Specifically, firstly, the front-end is based on the JSP environment, which is not in line with the trend of increasingly emphasizing the separation of dynamic and static. In addition, the report is not only Excel, but it is not common enough to operate Excel, and it is difficult to evolve and expand.

[0015] 6. For tables with complex forms such as merging and combination, they cannot be presented only through simple XML configuration

[0016] Specifically, the way of applying XML in the current solution is mainly to solve the problem of the data source, and the style of the report cannot be customized

Images