Method and system for generating parameterized report

Abstract

The embodiment of the invention discloses a method for generating a parameterized report. The method comprises the steps of generating a report model by using a report designer; sending the report model to a report processing engine to process; generating report results according to report parameters set by a user and a plurality of data sources; and displaying the report results. According to the method and the system for generating the parameterized report, two report tabulating manners are invented so as to distinguish users, so that the users without the professional report tabulating ability can use the reporting tools. The data sources of different origins can be supported and the plurality of data sources are supported to conduct a contrast display in the same report; and meanwhile, the parameterization of the report is supported so as to improve the reusability of the report; the optimized intelligent area distribution algorithm is provided, so as to ensure that the report results during report running corresponds to the design expectations; furthermore, abundant data adapter interfaces are provided so as to support the data from different types of the data sources; and rich data operating functions are provided, so as to support different complex operating scenes.

Description

technical field [0001] The invention relates to a report tool, in particular to a method and system for generating a parameterized report. Background technique [0002] Since the construction of enterprise IT informatization, different manufacturers have developed many report making tools. The following report generation tools are available: [0003] 1. Fixed-style report making [0004] Usually a part of the data in the system needs to be displayed in the form of a table, and the display of this part of the data is regular. In this case, considering the development cost factor, it is usually implemented by using a fixed style report. This built-in report form is relatively simple, and the form styles, such as fonts, colors, etc., are fixed. The most common is the display table of query results in database management tools. This table is a two-dimensional structure, the number of rows is determined by the number of data entries, and the number of columns is determined b...

AI Technical Summary

Problems solved by technology

[0013] 2) Although the production of reports in a structured manner can realize the personalized customization of reports, it cannot support the production of reports with complex unstructured forms;

[0014] 3) The structured standardization of data models is very demanding, for example, most of them require multi-dimensional models, which makes the workload of data preprocessing very large; the support for complex modeless reports is weak, and the production process requires a lot of scripts Development requires high technical level of report producers, and the production efficiency is low; in addition, penetrating queries cannot be realized, and special complex formulas are not supported enough, such as: ranking formulas, year-on-year formulas, data offset formulas, etc.;

[0015] 4) Although the standardization level of data is not high, it usually requires developers to code and implement it, which is difficult for end users to use. Its tabulation workload is heavy and maintenance is very difficult. When the report style needs to be fine-tuned locally, it is often necessary to Tear down the entire report and start over;

[0016] 5) For unstructured reports with complex calculations and large data volume processing, there is a common problem of low processing efficiency

Images