TWI742549B - A report generating method and system under multi-dimension template technology - Google Patents

Abstract

A report generating methodology and system under multi-dimension template technics which include a database and a reporting engine. The database store the data from data-collection system. The reporting engine provide user interface to collect report structure and data process requirements. The reporting engine assembly the templates by their structure and aggregate the corresponding data into template(s) to finish the report generating job.

Description

Multi-dimensional template report output method and system

The present invention relates to a method and system for generating a multi-dimensional template report.

Making reports is an indispensable paperwork for the industrial and commercial society, such as: company operating annual reports, project closure reports, equipment inspection reports, and so on. Different from the multi-page presentation in a single format of a general report, the report is composed of a book, including a cover, a table of contents, a header, a footer, a page number, and a combination of different chapters and texts under different conditions. Each The format of the page is basically different, so it cannot be handled by traditional report development tools and design techniques. Therefore, a complete and organized report requires a lot of manpower to compile, and the efficiency is really low. For some service units or organizations that often need to produce a large number of reports, the organization of reports is usually the biggest problem, because the reports for different needs or purposes, although the styles are similar, must be adjusted for each different need and purpose. The template of the report, and this requirement/problem will make the template version of the report have to be continuously expanded, leading to technical problems that are difficult for template management.

In order to solve the existing report output process, a large amount of manual input is required to input the technical problems and the quality of the output, which leads to tedious work and the quality of the output. Moreover, for the standard template, it is necessary to manage a large number of different templates in order to meet different purposes and needs. Invented this method for managing difficult technical problems. The present invention provides a multi-dimensional template report generation method and system, which includes a database and a report generation engine. The database stores a data in a database file format. The report generation engine is used according to The definition of the person is obtained from the database and written into the multi-dimensional template defined by it The report output engine drives the database to obtain data from the data collection interface. The report output engine defines the structure and content of a report produced, and the report output The engine obtains the content to be filled in the framework from the database, and aggregates it into templates at various levels according to the user's requirements to complete the production of the report.

Wherein, the multi-dimensional template report generation method and system includes a data collection interface connected to the database, the data collection interface accepts a data data, converts it into the database file format, and stores it in the database.

Among them, the template of the report output engine includes multiple levels, a plurality of definable attributes, a static data, and a dynamic data.

The present invention also provides a report generation method, the steps of which include: accepting selection of a report template, the report template including at least a first-level template, and a plurality of second-level templates subordinate to the first-level template, wherein , At least one of the second-level templates includes an attribute; by reading a data to be input, the data to be input corresponds to the field of the report template format; judging the type and attribute of the data to be input; according to The form and attribute adjustment of the data to be input corresponds to the attribute of the report template; and the data to be input is input into the report template.

Based on the foregoing description, the present invention proposes a multi-dimensional template report generation method and system, which can use the report generation engine, after the test results are input, according to the selected report format, in the database Obtain the data and the attributes of each level template defined by the report output engine, and fill in the content of the data into each template to generate a report. In this way, the present invention solves the problem of insufficient functions caused by a single-level template and complicated version management in the prior art. At the same time, it also achieved the technical effect of automating the report output.

10: Data collection interface

20: Database

30: Report output engine

32: First-order template

34: second order template

36: Third-order template

A: Information

B: report

X: File number structure

Y: top specification structure

Z: table structure

P: Static data

Q: Dynamic data

FIG. 1 is a schematic diagram of the structure of a preferred embodiment of the present invention.

FIG. 2 is a diagram of a multi-dimensional template architecture of a preferred embodiment of the present invention.

3A and 3B are examples of implementation of multi-dimensional template data aggregation according to a preferred embodiment of the present invention.

4A~4C are the report structure and output example of the preferred embodiment of the present invention

Please refer to FIG. 1, the multi-dimensional template report generation method and system of the present invention includes a data collection interface 10, a database 20, and a report generation engine 30 that are signal-connected to each other.

The data collection interface 10 obtains an external data A through a receiving process, determines a format and a numerical content of the data A, and outputs them to the database after identification. The so-called receiving procedure is that the data collection interface 10 receives an external device, a carrier, and other information sources of the data A to obtain a data. The so-called equipment may be an unrestricted type of detection equipment, and may be a detection equipment with features such as weight, optics, material, surface features, structure, and mechanics. The data collection interface obtains the data from the devices; or, it can read the data from the carrier or the file. Among them, the carrier may include all software, hardware, or networks that can store files, such as optical disks, hard disks, floppy disks, and networks. The format of the data is not limited, such as CSV, EXCEL, HTML, TXT, WORD... etc.

After the data collection interface 10 obtains the data A, it recognizes the format and numerical content of the data A, and stores the data A in a database file format preset by the database 20. The database 20 cooperates with different devices and carriers to predefine the file format of the database. For example, the data A is an EXCEL file, and the number of fields, worksheet names, field names, numbers, and lengths of the EXCEL file The format is the format, and the data or text in each field is the numerical content. The database is pre-defined in accordance with the format and the content of the value. The corresponding database file in the data A Format and store the value content. In other words, the format and value content of each data A are different. The database 20 needs to define the database file format corresponding to each data A, so that the database file format is determined by the database 20 after the data A is judged. Be stored.

Please refer to Figures 2 and 3, the report generation engine 30 obtains data from the database 20 and writes it into a template of plural levels defined by it. The report generation engine 30 drives the database 20 to collect the data. The interface 10 obtains data, wherein the report output engine 30 defines a structure and a content of a report B produced, and the report output engine 30 obtains the content to be filled into the structure from the database 20 After inputting, complete the report B and output it. The aforementioned content is stored in the database 20 in a predefined file format of the database. The structure of the report B is composed of the pre-selected templates. For example, the structure of the report B is composed of 3 first-level templates, and each first-level template may contain different functions according to requirements Corresponding to the configured second-level templates, each second-level template can also be combined by more than one third-level templates.

Each template contains a plurality of definable formats, attributes, static data P and dynamic data Q. Please refer to FIG. 3A. In this embodiment, the three-level template includes a first-level template 32, a second-level template 34, and a third-level template 36. The first-level template 32 defines the basis of the report B. Structure, such as a cover, a first page, a last page, a table of contents, an appendix, a chapter, a drawing... etc. Each first-level template 32 includes more than one second-level template 34, and each second-level template 34 defines a structure in the first-level template 32 in detail. The following examples illustrate:

Example 1: The first-level template 32 defines the cover format, catalog format and display style of a report, while the second-level template 34 can define the display style and internal presentation data of the chapters in the report , The layout and display style of the chart, such as borders, table configuration position, character format (font, size, color), skipping rules, space type, etc.

Example 2: The first-level template 32 defines the internal display data content and basic layout of a specific chapter, and the second-level template 34 defines the static data and the dynamic data of the specific chapter. Advanced configuration of state data.

Please refer to Figure 3B. The structure can be such as but not limited to the following examples: a file number structure X, a header specification structure Y, a table structure Z, etc. The following example illustrates: the file number structure X is defined in the second The specific location in the level template 34 can include the static data and the area specified by the dynamic data. For example, the Report No. belongs to the static data, the E5/2019/50001 belongs to the dynamic data of the report, and the attribute defines the The numerical format, size, type, line spacing, etc. of the static data and the dynamic data, so that the dynamic data and the static data can be read by the database 20.

The header specification framework Y defines the form version, issuer information, etc. of the second-level template 34.

The table structure Z defines the advanced configuration of the table of the second-level template 34, such as fields and styles, such as the number of fields in the table, and the position of the table in the report.

The third-level template 36 further defines the static data and the dynamic data in all content presentations of the first-level and second-level templates 34 and the corresponding attributes, such as a cell of the second-level template 34 (Dynamic data) the merging conditions, the internal data format and other data of this attribute. As shown in FIG. 3A, it is one of the pages of an antenna test report. The structure of the second-level template 34 defines its table position, format, fields, etc., and the third-level template 36 defines the second-level template. 34. The attributes in the framework, such as the content and value length of the table in the antenna test report, Chinese and English, content types, data variables, etc., that is, the third-level template 36 of this embodiment defines the second-level The processed attribute of the input data and the processed attribute of the output data in the template 34.

Example 3: Taking Figures 3A, 3B, and Figures 4A~C as examples, in the database 20, the value of a network analysis device to detect the antenna under test is stored in the database in the database file format, where The database file format includes the values and contents corresponding to the static data P and the dynamic data Q defined by the second-level template 34. When the report output engine 30 decides to generate the report B, the resource The database 20 obtains the content and fills it into the form defined by the second-level template 34. When the form is filled in, the report output engine 30 publishes the content in the template according to the attributes of each level template 32~36. Inside.

Further, when the static data P and the dynamic data Q are input into the report B from the database 20, since the templates 34 and 36 may contain attribute settings, the static data P, the dynamic data Q, etc. are input In the report B, the report generation engine 30 determines the content specifications of the static data P and the dynamic data Q, and adjusts the attributes of the templates 34 and 36 so that the static data P and the dynamic data Q with different content specifications can be Adjust the attributes of the templates 34, 36, so that the same templates 32, 34, 36 can be used for materials with the same nature but different amounts. Illustrate with practical examples:

Example 4: The report generation engine 30 imports an antenna test data in the database 20 in the report B which pre-selects one of the templates 32, 34, 36, where the antenna test data is due to differences in different antenna models And there are different numbers of test results, for example, reduce or increase the test data of a field. In this embodiment, after the report generation engine 30 receives the detection results of different numbers, it uses the attribute adjustment of the template 34 or the template 36, so that a table corresponding to the antenna detection data in the report B can be generated through the attribute adjustment. The effect of adding or subtracting fields, merging fields, etc. It can be seen from this that when the report B is generated in this embodiment, the same templates 32, 34, 36 can be used, and the report B can be directly completed after importing the detection result.

The report generation engine 30 generates the report B through a report generation method, and the steps may include: accepting selection of a report template, the report template includes at least a first-level template, subordinate to the first-level template A plurality of second-level templates, wherein at least one of the second-level templates includes an attribute; by reading a data to be input, the data to be input corresponds to the report template format; and the type of the data to be input is determined state; Adjust the corresponding attributes of the report template according to the form of the data to be input; and input the data to be input into the report template.

Based on the foregoing description, the present invention proposes a multi-dimensional template report generation method and system, which can use the report generation engine to input the test results in the database according to the selected report format. Obtain the data and the attributes of each level template defined by the report output engine, and fill in the content of the data into each template to generate a report. In this way, the present invention solves the complicated version management problem in the prior art, and at the same time achieves the technical effect of automatic report generation.

10: Data collection interface

20: Database

30: Report output engine

A: Information

B: report

Claims (4)

A multi-dimensional template report generation system, which includes a database and a report generation engine. The database stores a data in a database file format. The report generation engine obtains data from the database. Write the multiple-level template defined by it. The report generation engine drives the database to obtain data from a data collection interface. The report generation engine defines the structure and content of a report generated by the report generation engine. A first-order template of a complex order defines the structure of the report, a first-order template of the plural order includes at least one second-order template, and the second-order template defines a corresponding framework in the first-order template, The second-level template of the plurality of levels includes at least one third-level template, the third-level template defines an attribute in the corresponding second-level template, and the report output engine obtains the required input from the database Enter the content of the structure and complete the report. For example, the multi-dimensional template report output system described in claim 1, which includes the data collection interface to connect to the database, and the data collection interface accepts a data, converts it into the database file format and stores it in the database Inside. For example, in the multi-dimensional template report output system of claim 1 or 2, the template of the report output engine includes a plurality of definable attributes, static data, and dynamic data. A report generation method, the steps include: accepting to select a report template, the report template includes at least a first-level template, a plurality of second-level templates subordinate to the first-level template, wherein, at least one of them A second-level template includes an attribute, the first-level template defines the structure of the report, the second-level template defines a corresponding structure in the first-level template, and the second-level template includes at least a third The third-level template defines the attribute in the second-level template corresponding to the third-level template; reads a data to be input, wherein the data to be input corresponds to the report template format; determines the type of the data to be input; Adjust the attributes of the corresponding second-level template according to the form of the data to be input; and Enter the data to be entered into the report template.

Images